Passing NULL in a ReportParameter Object to ReportService.asmx

Came across a need to pass NULL to a paremeter in a Reporting Services report through the ReportService web service.  Turns out (thanks Teo Lachev) that if this is what you need, omit the parameter altogether from the parameter collection that is passed into the web service.  Teo mentioned that he figured this out by doing a server trace.  Very clever.  He remembered that Reporting Services is using the ReportService.asmx to render the reports itself and so all he had to do was render the report using the null checkbox in the parameter box and see what it was doing.  Well done.

Mark

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: