How To: Filter Reports

<< Click to Display Table of Contents >>

Navigation:  WireCAD PRO Manual > Reporting >

How To: Filter Reports

Previous pageReturn to chapter overviewNext page

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.

How To:

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

clip0053

5.From the Property grid select the Filter String [...] ellipsis button.

clip0054_zoom71

6.This opens the filter dialog from which you may select a number of different filters.

filter_zoom50

7.Select a field to filter on.

report_9_filter_field_zoom50

8.Select a filter operator.

report_9_filter_operator_zoom50

9.Enter a value.

report_9_filter_value_zoom50

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.