Article ID: 842853
Article Last Modified on 4/3/2007
APPLIES TO
- Microsoft SQL Server 2000 Reporting Services
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:
Additional query words: doc err csv null parameter
Keywords: kbupdate kbtshoot kbonlinedocs kbreport kbdocfix kbinfo KB842853
