In SSRS subcription, how to retreive the parameter type of subscription parameter
In SSRS subscription, I would like to get the type parameter before setting a value but I have no luck finding any code on how to do it. In this link
http://msdn.microsoft.com/en-us/library/reportservice2006.reportingservice2006.getsubscriptionproperties(v=SQL.100).aspx only parametername and parametervalue are available.
any help?
August 6th, 2012 1:58pm
I cannot find a supported way of doing this.
But in the Catalog table there is a Parameter field which contains the data type in the <Type> node.
So you could get the GUID of the report from the subscription, then shred the XML in the Catalog table to get the data type - joining on the parameter name.
This would be pretty easy in C#Josh Ash
Free Windows Admin Tool Kit Click here and download it now
August 7th, 2012 7:19pm