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.
- Right click anywhere outside the report on the Layout tab
- Select Report Parameters
- Select the parameter you want to allow blank values for
- Check off the Allow blank value checkbox
Repeat as needed for each parameter.
精彩评论