开发者

Parameters in SSRS

I am trying to develop a report in SQL Server Reporting Services using parameters.

I have no problem creating the parameters and running the reports, but I always have to select an item from each of the parameters to make it run. Can I have the option to leave one of the parameters blank and still have the report run? Right now when I hit 'view report', I al开发者_如何学JAVAways get the error that I must make a selection to continue.


Check off the Allow blank value checkbox for the parameter(s) you want to allow a blank value for.

  1. Right click anywhere outside the report on the Layout tab
  2. Select Report Parameters
  3. Select the parameter you want to allow blank values for
  4. Check off the Allow blank value checkbox

Repeat as needed for each parameter.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜