Chapter 4 Managing a Report

Defining a filter criterion for a selected report item

The Define Sort and Filter dialog box lets you refine the selection of objects in your report by adding a filter criterion to the list of objects. You can set the following parameters to define the criterion:

Parameter To define
S column Means sorted, indicates the attribute will be taken into account for the sort

Used to set an order and define a priority among attributes
Expression column Used to restricts the selection to a defined expression
U column Applies the filter expression to the corresponding column

The expression syntax uses standard wildcards as in the Customize Columns and Filter dialog box.

For more information about the expression syntax, see the "Defining a filter on a list" section in the "Using the PowerDesigner Interface" chapter in the General Features Guide .

You have to click OK to commit the criterion. If you click the Switch to Selection button you display the Select Objects dialog box and you do not commit the criterion.

Note   Lists in books
The Switch to Selection button is not available if the list you are sorting belongs to a book item.

Extended attribute as filter criterion

You can select an extended attribute as filter criterion for the list of objects, if your model has an associated language, DBMS or extended model definition containing extended attributes. For example, extended attributes defined for tables in the DBMS associated with a PDM are available for selection in a book or List item.

For more information about extended attributes see the "Managing Profiles" chapter of the Advanced User Documentation .

Steps To define a filter criterion:

  1. Right-click a book or a List item in the Report Items pane and select Selection.

    or

    (Matrix items only) Right-click a matrix item in the Report Items pane and select Row Selection or Column Selection.

    The Define Sort and Filter dialog box is displayed.
  2. Type an expression in the Expression column to restrict the selection in the column to a defined expression.
  3. Select the U column to apply the filter expression to the corresponding column.
  4. Select the S column to take the attribute into account for the sort.
  5. Click the Include Sub-Objects tool to apply the filter on all the sub-objects recursively.
  6. Click the Include Shortcuts tool to apply the filter on all the shortcuts recursively.
  7. Click OK.

Note   Cancel filter expression
If you want to keep the expression in memory but disable this filter for a while, you can clear the corresponding check box in the U column. The expression parameter will no longer be taken into account.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.