Managing and configuring parameters
In the construction of the tabular report earlier in this chapter (see Creating reports with a table data region recipe), in the query, the date range was hardcoded. It would be beneficial to the user of the report if they could select the date range to run the report with.
SQL Server Reporting Services uses the concept of parameters to accomplish this. In this section, we'll see how to implement parameters in the tabular report.
Getting ready
We will want to create a copy of the original tabular report and add it to our project so that we can work with it. This is actually a pretty common task; often times you will have a report that is almost, but not quite, what is needed for a new report. Copying that existing ...
Get SQL Server 2016 Reporting Services Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
