<< Click to Display Table of Contents >> How To: Filter Reports |
|
By default a report will query the database for all records in the selected collection. For example if the report displays the project CablesCollection, all records will be displayed. This may or may not be desirable. If you wish to filter the record set to show a specific set of records you have two choices:
1.If the collection being displayed is the CablesCollection you may use the Cable Data Selector tab and make a manual selection there.
2.Otherwise you must create a filter.
1.Open a report.
2.Switch to the Report Designer tab.
3.Locate the Property window. Make sure that the Property window is displayed. If not click: Report Designer>Windows>Property Grid
4.From the Property grid object selector, select XRReport1
5.From the Property grid select the Filter String [...] ellipsis button.
6.This opens the filter dialog from which you may select a number of different filters.
7.Select a field to filter on.
8.Select a filter operator.
9.Enter a value.
10.Click [OK] to commit the filter. This filter with show only cables where the CableNo field begins with V-.
11.Select the Print Preview tab to render the report with the filter.