How does one specify a NULL value when passing a parameter to an SSRS report using URL access?
i.e. when using the form
http://server/ReportServer/Pages/ReportViewer.aspx?Report&Parameter=value
How does one specify a NULL value when passing a parameter to an SSRS report using URL access?
i.e. when using the form
http://server/ReportServer/Pages/ReportViewer.aspx?Report&Parameter=value
Use the syntax
Parameter:IsNull=True
In the example given above:
http://server/ReportServer/Pages/ReportViewer.aspx?Report&Parameter:IsNull=True
Reference: http://msdn.microsoft.com/en-us/library/ms155391(loband).aspx
And how about if you're using Classic ASP, and your code is like the following:
rpt = New Report rpt.AddParameter "ParamOne", "ParmValue1" rpt.AddParameter "ParamTwo", "ParmValue2"
rpt.ExecuteClientURL
And you need to have ParmValue2 be null ?