CODEWITHSUNDEEP
reporting-services
Ed Harper
Ed Harper

Reputation: 21505

Pass NULL to SSRS URL access parameter?

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

Upvotes: 19

Views: 17107

Answers (1)

Ed Harper
Ed Harper

Reputation: 21505

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

Upvotes: 28

Related Questions