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 repotsreports, please refer to 8.1 - Excel Reports with Parameters
OfficeWriter uses Microsoft Query to add parameters to a report.
Note |
---|
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. |
...