Data Area examples and sample reports

This topic describes examples of how the Data Area is used for filtering and sorting list elements.

These topics refer to the sample reports of the same name which are delivered with the Best Practices sample database:

See Connecting to the sample database.

The Data Area of the List Designer is enabled whenever you create a Value filter or sort. That is:

  • You select Filter By > Value in 'Filter Settings', at the bottom of the Filter pane, or
  • You select Type > Value in 'Sorting Criteria Settings', at the bottom of the Sorting pane.

You use the Data Area to specify the data to which a filter or sort applies. Often this will be the same as the data used in the report. For example, the report shows sales figures for a year and you create a filter to display only figures above 100000 in that year.

But you might want, for example, to display budgeted figures for a year only where the actual figures for the previous year were above a specified value.

Examples

Report RP001 contains examples of:

  • Why the Data Area is necessary when you create a Value filter.
  • One situation in which defining the Data Area is not necessary.

SeeRP001 .

RP002 contains an example using the Data Area to display budgeted figures in one year only where the actual figures for the previous year were above a specified value.

Report RP003 demonstrates sorting the elements of a hierarchy which is displayed in a single hyperblock, and the use of the Break Hierarchy option.

See RP003.

Report RP004 demonstrates sorting the elements of a hierarchy which is displayed in overlapping hyperblocks. It also demonstrates the use of the Break Hierarchy option.

See RP004.