4.4. Report Parameters

From the users' standpoint, all our sample reports up to this point have been "what you see is what you get." These reports each ran a predetermined query to create the dataset. No user input was requested.

In the real world, this is not the way things work. Most reports require the user to specify some criteria that can help determine what information is ultimately in the report. The user may need to enter a start and an end date, or they may need to select the department or sales region to be included in the report. Users like to have control over their reports, so they receive exactly the information they are looking for. Our next report demonstrates how Reporting Services enables you to get user input by using report ...

Get Microsoft SQL Server 2005 Reporting Services, 2nd Edition 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.