Predefining sort and filter conditions

You can predefine some sort and filter conditions for data components, which refer to banded objects, tables, charts and crosstabs, in page reports, so that when the page reports are published to JReport Server and are loaded in Page Report Studio, data in the components will be displayed in the order you prefer, or be narrowed down as you desire.

Predefining sort conditions

To predefine sort conditions for a data component, follow the steps below:

1. Select the component to which the sort conditions will apply.
2. Click Report > Edit Sort and Filter to show the Edit Sort and Filter dialog. The Sort tab is active by default. See the tab.

   

3. In the Fields box, all the fields in the dataset the component uses are displayed. Select the field by which to sort the data from the box and click to add it to the Sort By box. To sort by two or more fields, select all of them and then click .
4. To modify the sorting direction for a field, select (ascending) or (descending) in the Direction column.
5. To change the sorting priority of the fields, select the field in the Sort By box, and then click or to move it up or down.
6. Click OK to accept the settings.

Predefining filter conditions

To predefine filter conditions for a data component, follow the steps below:

1. Select the component to which the filter conditions will apply.
2. Click Report > Edit Sort and Filter to show the Edit Sort and Filter dialog, then switch to the Filter tab. See the tab.

   

3. Click the Add Condition button to add a condition line.
4. From the field drop-down list, select the field on which the filter will be based.
5. From the operator drop-down list, set the operator with which to compose the filter expression.
6. In the value combo box, type the value of how to filter the field or select the value from the drop-down list.
7. Click Add Condition to define another condition line and set the relationship between the two lines if required.
8. When done, click OK to apply the settings.