Previous Topic  Next Topic

Applying Filters to Page Report

You can apply filters to a page report to narrow down the data in the report. This topic describes how you can filter business views and data components such as banded objects, tables, crosstabs, and charts in page reports.

This topic contains the following sections:

• Applying Filters to Business Views
• Applying Filters to Data Components
  • Filtering Using the Filter Dialog
  • Filtering Using Shortcut Menu

Applying Filters to Business Views

For data components created on business views or converted to use business views in a page report, you can apply filters to the business views they use to narrow down the data scope of the business views. Filters for business views are defined into two categories in Logi Report: predefined filters and user defined filters. As the name suggests, predefined filters are defined in advance when creating or editing the business views using Logi Report Designer, and user defined filters are created on the business views while they are used.

Business view filters are defined on the component level in Page Report Studio, which means each time you create a data component, you can apply a filter to the business view it applies without affecting other data components based on the same business view.

You need a Logi Report Live license for Logi Report Server to use this feature. For more product information, including new purchases and upgrades, contact US Sales or UK Sales.

To apply a filter to the business view a data component uses:

1. Select any object in the data component.
2. Do any of the following to open the Query Filter dialog box.
   • Select the Query Filter button on the toolbar.
   • Select Menu > Report > Query Filter.
   • Right-click on the icon at the upper-left corner of the data component and select Query Filter from the shortcut menu.
3. Specify the filter to be applied to the business view.

   All the predefined filters of the business view the data component uses are listed in the Query Filter drop-down list. Choose the one you want to apply. If you want to further edit the filter, select the Edit button and then redefine the filter as required. The edited filter will then be saved as a user defined filter to the business view.

   If you prefer to define a filter on your own, select User Defined from the Query Filter drop-down list, then define the filter according to your requirements.

   The dialog box has the basic and advanced modes for you to define either simple expressions or complex expressions.

   • To define a filter using simple expressions:
     1. Make sure the dialog box is in the basic mode.

        

     2. From the field drop-down list, select the field on which the filter is based.
     3. From the operator drop-down list, set the operator with which to compose the filter expression.
     4. The values of the specified field are available in the value drop-down list. Select the required one by which to filter the field. You can also type the value manually in the text box and when you type multiple values, you should separate them with ",", and if "," or "\" is contained in the values, write it as "\," or "\\". To specify an empty string as the value for a field of String type, simply leave the text box blank (value length=0).

        You can also filter the field by another field by selecting and then selecting the field from the drop-down list. The provided field list contains the following: the group and detail information objects in the business view and the parameters in the current catalog which are of the same data type as the field to be filtered, and the special field User Name. To go back to filter the field by value, select .

     5. If you want to add another condition line, from the logic operator drop-down list,
        • To add a condition line of the AND relationship with the current line, select AND, then define the expression as required.
        • To add a condition line of the OR relationship with the current line, select OR, then define the expression as required.

        You can repeat this to add more condition lines. To delete a condition line, select on its left.

   • To define a filter using complex expressions:
     1. Switch the dialog box to the advanced mode.

        

     2. Select the Add Condition button to add a condition line.
     3. From the field drop-down list, select the field on which the filter is based.
     4. From the operator drop-down list, set the operator with which to compose the filter expression.
     5. The values of the specified field are available in the value drop-down list. Select the required one by which to filter the field. You can also type the value manually in the text box and when you type multiple values, you should separate them with ",", and if "," or "\" is contained in the values, write it as "\," or "\\". To specify an empty string as the value for a field of String type, simply leave the text box blank (value length=0).

        You can also filter the field by another field by selecting and then selecting the field from the drop-down list. The provided field list contains the following: the group and detail information objects in the business view and the parameters in the current catalog which are of the same data type as the field to be filtered, and the special field User Name. To go back to filter the field by value, select .

     6. To add another condition line, select the Add Condition button and define the expression as required. Then, select the logic button until you get the required logic to specify the relationship between the two filter expressions. The logic can be AND, OR, AND NOT, or OR NOT.
     7. You can repeat the preceding steps to add more condition lines.

        To group some conditions, select them and select the Group button, then the selected conditions will be added in one group and work as one line of filter expression. Conditions and groups together can be further grouped. To take any condition or group in a group out, select it and select Ungroup. It is the equivalent of adding parenthesis in a logic expression.

        To adjust the priority of a condition line or a group, select it and select the Up or Down button.

        To delete a condition line or a group, select it and select the Delete button.

4. Select OK to apply the filter to the business view. Only the data that meets the filter conditions will be fetched from the business view and displayed on the data component.

   If the special field User Name is used in the filter condition, the username used to sign in to Logi Report Server will be applied to compose the filter expression; if a parameter is used, after selecting the OK button you will be prompted to specify the parameter value to dynamically define the filter condition.

You can also apply a filter to the business view a data component uses in the Query Filter screen of the report wizard while creating the data component.

Applying Filters to Data Components

When applying filters to the data components themselves in a page report, there are the following ways you can take: using the Filter dialog box, using shortcut menu, or using filter controls.

Filtering Using the Filter Dialog

1. Select Menu > Report > Filter, or the Filter button on the toolbar. Server displays the Filter dialog box.

   

2. From the Apply to drop-down list, select the data component in the report to which you want to apply the filter.

   Tip: For page reports created in Logi Report Designer, the default selected data component and available data components in the Apply to drop-down list are determined by the Default for Filter and Invisible for Filter Dialogs properties of the components.

3. Define the filter conditions using either simple expressions or complex expressions as you would do while filtering the business view of a data component. However, there are the following differences when you edit conditions to filter a data component:
   • You cannot filter a field by another field.
   • To specify an empty string (value length=0) as the value for a field of String type, type a pair of single quotes ('') in the text box and then click outside of the condition line to accept the condition.
4. Select OK to make the filter take effect and return to the report.

Filtering Using Shortcut Menu

You can use filter-related commands on the shortcut menu to filter the data in a banded object or table. To do this, right-click any value of a field other than the group-by field by which you want to filter data, to show the shortcut menu. You will see the Filter submenu with these commands:

• Remove Filter
  Select to remove the filter from the field. Server enables this command after you have filtered the field.
• Top N
  Select to display the Top N dialog box, with which you can filter the field to display only its top N values.
• Bottom N
  Select to display the Bottom N dialog box, with which you can filter the field to display only its bottom N values.
  
• Field values
  "Field values" is not the name for a command on the Filter submenu, but represents the values of the field. Select a value, and the field will be filtered to show only the specified value.
• More
  Server enables this command if the Filter submenu cannot list all values of the field. Select the command to display the Select Values dialog box. Then specify a value, and Server filters the field to show only the selected value.

After you apply a filter using the Filter shortcut menu, if you open the Filter dialog box you can find that the corresponding filter expression in the dialog box.

Previous Topic  Next Topic