Setting Format Groups in Sets

In sets, you can specify format groups . A format group represents a version of layout parameters for a report. You can specify format groups in:

  • Set rows of basic, data, single-dimension, and multi-dimension sets

  • The set header of basic and single-dimension sets to represent the set total

The format groups instruct the Report Writer which format to use for the set total represented by the set header or the data in the set rows. Report rows and columns corresponding to these set totals and set rows are then formatted according to the layout parameters for the specified format group.

Example Example

The report portrayed in using set formulas in Report Writer uses the column block TD-ACT-PLN-V and lists the following columns:

End of the example.

  • Plan data in local currency (HSL-1)

  • Actual data in local currency (HSL-0)

  • Variance (difference between plan and actual data in local currency)

By assigning a different format group to set row 003 (the variance column) in data set TD-ACT-PLN-V, you can change the layout of this column, such as the column width and number of decimal places.

You can specify a format group for:

  • Basic and single-dimension sets

  • You enter a format group in the format group field on the Create and Change Set: Basic Entries screens to represent the individual set rows.

  • You enter a format group in the format group field on the Create and Change Set: Header screens.

Format groups entered in the set header represent the total level in the set. In set hierarchies, the format group entered in the set header is only used for the highest total in the row or column block. For all other report rows and columns, the format group entered in the set row is used.

  • Data sets

You enter a format group in the format group field on the Create and Change Set: Basic Entries screens to represent the individual set rows.

  • Multi-dimension sets

You enter a format group for a set row in the format group field on the Create and Change Set: Basic Entries screen. You can use the format groups, for example, for set variables that have been entered directly into a multi-dimension set.

The value you enter in the format group fields instructs the Report Writer to select a specific format group value listed in the report parameters for the set row or set header for which you enter the format group.

The format groups refer to certain parameters that are displayed on the Create Report: Layout or Create Standard Layout screens. Each of the fields listed below is made up of six input fields; each of these six input fields stands for one of the six format group 0 through 5. The Report Writer selects the corresponding format information according to the value you entered for the format group.

On the Create Report: Column Totals screen, the format group applies to the following parameter fields affecting column format:

  • Column width

  • Right margin

On the Create Report: Layout: Representation screen, the format group applies to the following parameter fields affecting numeric format:

  • Decimal places

  • Scaling

  • Change +/- sign

  • Print unit

To enter the format groups, from the Create Report: Layout: Column Totals and Create Report: Layout: Representation screens, choose the function Variants . A dialog box appears with additional entry fields for the format groups 1 to 5.

Example Example

For a basic set row value, enter in the format group field the format group 1 . When you use this set in a report, the Report Writer looks to the second input field of the parameter for the format it should use in the report.

End of the example.

The format group values for the number of decimal places, scaling, column width, currency/quantity width, and the right margin are only valid for columns . This means that the format group value you enter in a set (for these fields) is only valid if the set is used in a column.

You can find more information on creating sets under creating sets .