views:

583

answers:

2

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
A: 

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

Ed Harper
A: 

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 ?

Steve