Bunch's Blog

One day I'll have a catchy subtitle, one day
posts - 77, comments - 89, trackbacks - 0

My Links

News

Tag Cloud

Archives

Green

Thursday, July 16, 2009

SSRS – Passing Nulls and Blanks

Passing nulls and blank values to SSRS via an URL requires a very little bit of work. For a null value you first need to call up the Report Properties (in the Layout tab select the entire report and click on Properties on the right) in SSRS and click on the button in ReportParameters. Once the Report Parameters window has opened you can set the parameter to allow nulls by checking the ‘Allow null value’ box. Then from the application that runs the report use Parameter:isNull=True in your URL if you need to pass a Null value.

For a blank value call up the Report Parameters window again and check the ‘Allow blank value’ checkbox for the parameter(s) you need to be able to pass a blank value to. In your URL you can then use Parameter= to pass nothing. Here is an example URL with the Date parameter using Null, PlayerID with a blank value and Sport using a value:

&Date:isNull=True&PlayerID=&Sport=Soccer

Technorati Tags:
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

Posted On Thursday, July 16, 2009 4:59 AM | Feedback (0) |

Powered by: