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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics