O'Reilly logo

SQL Server 2016 Reporting Services Cookbook by Robert C. Cain, Dinesh Priyankara

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required