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, *
FROM [Catalog]
WHERE Parameter LIKE '%<PromptUser>False</PromptUser>%'

Leave a Reply

Your email address will not be published. Required fields are marked *