Verifying Reporting Service 2005 Report Parameters

Sometimes the setup of the reports are to be checked via script on Reporting Service 2005. From the reporting service database the table Catalog contains the parameters setup for the report in the XML Parameter column Selecting wheither at least one of the prompt users have been set. XQuery is better for spefific queries SELECT¬†Parameter,¬†* […]

Using multivalue parameters in reports in Reporting Service 2005

Using multivalue parameters in reports in Reporting Service 2005 The multivalue parameter is transformed into a list expanding @Name parameter with the values “BE”,”AV” used in “Company IN (@Name)” to “Company IN (‘BE’,’AV’)” and thus making it impossible to pass the value to a user defined function or stored procedure. To pass the parameter an […]