Updates for the "Passing a Report Parameter on a URL" topic and the "CSV Device Information Settings" topic in Reporting Services Books Online

Article translations Article translations
Article ID: 842853 - View products that this article applies to.
Expand all | Collapse all

On This Page

INTRODUCTION

This article contains additional information that should be included in the following topics in Microsoft SQL Server 2000 Reporting Services Books Online:
  • "Passing a Report Parameter on a URL"
  • "CSV Device Information Settings"

MORE INFORMATION

The "Passing a Report Parameter on a URL" topic

The "Passing a Report Parameter on a URL" topic provides information about how to pass the report parameters to a report by including the report parameters and the corresponding values in a URL. Additionally, the "Passing a Report Parameter on a URL" topic should also include information about how to pass the Null-valued report parameters to the report through a URL. The following information is currently included in the topic:

"To set a report parameter on a URL, simply add the parameter name followed by the equals sign (=) followed by the value of the parameter. The syntax would be param=value."

However, the topic should read as follows:

"To set a report parameter on a URL, simply add the parameter name followed by the equals sign (=) followed by the value of the parameter. The syntax would be 'param=value'. Additionally, you can also pass a null value for a parameter to a report by adding 'param:isnull=true' to the URL. For example, if the SalesOrderNumber is a Null-valued report parameter that must be passed to the report, add the 'SalesOrderNumber:isnull=true' string to the URL."

The "CSV Device Information Settings" topic

In Reporting Services, you can pass the device information settings through URL access and also as an XML string that can be passed to the Render method. The value of the FieldDelimiter setting that is a part of CSV Device Information Settings varies based on the method that you use to pass the device information settings in Reporting Services. Therefore, the "CSV Device Information Settings" topic should include the following information for the FieldDelimiter setting:

"You must specify the HTML encoded value of the field delimiter character when you specify the FieldDelimiter Device information setting through URL access to render a report to the CSV format. For example, for the TAB character to be specified as a field delimiter character, you must use '%09'.

Similarly, if you use the FieldDelimiter device information setting in an XML string, you must use XML encoded value of the field delimiter character. For example, a TAB character as a field delimiter in an XML string must be '	'."

REFERENCES

For more information, visit the following MSDN Web sites:
http://msdn2.microsoft.com/en-us/library/aa237815(SQL.80).aspx
http://msdn2.microsoft.com/en-us/library/aa179571(SQL.80).aspx

Properties

Article ID: 842853 - Last Review: April 3, 2007 - Revision: 1.3
APPLIES TO
  • Microsoft SQL Server 2000 Reporting Services
Keywords: 
kbupdate kbtshoot kbonlinedocs kbreport kbdocfix kbinfo KB842853

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com