OfficeWriter and Reporting Services allow you to use parameters to filter the data returned by your database query, and display a subset of the data in your report. This will cover how to define parameters in a report using MS Query in the OfficeWRiter Designer. For more on parameters in OfficeWriter reports, please refer to Reports with Parameters.
If Microsoft Query cannot display a query graphically, it will not allow you to define a parameter for the query. For example, if a query contains the TOP keyword, which cannot be represented graphically, Microsoft Query will warn you that the query cannot be shown graphically and will not allow you to add parameters to the query. |
Let's add a parameter to a sample query. The sample will use the AdventureWorks sample database, which ships with Reporting Services.
Download an .rdl file created with Microsoft Query and OfficeWriter.