Reporting > Filtering Reports

Menu: Reports>Report, Alternately: double-click the report in the Project Explorer

Default command line shortcut:

Report filtering is not available in XL free mode.

Applies To:

XLT PRO

Related Settings:

None

In order to filter a report the report must be in design mode

clip0056

Make sure that the Property window is displayed. If not click:View>Windows>Property Grid

From the Property grid object selector, select XRReport1

From the Property grid select the Filter String ... ellipsis button

clip0054

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

filter

Filters may also contain parameters that the user must enter before the report is generated. In order to make use of this function you must follow these steps:

1.	Add a parameter to the report while in Design view. Click the Parameters (...) ellipsis button to view the Parameters collection.

2.	Click the [Add] button to add a parameter to the collection.

3.	Enter description and default value information.

4.	Open the filter editor (see above)

5.	Add a condition and edit the comparison, then click on the icon to the right of the field to select parameters.

6.	Click [Preview] to preview the report. You will see a Parameters pane on the left hand side with a submit button.

7.	Enter a value and click [Submit].

clip0002

clip0003

clip0004

Step 5.

clip0005

clip0006