Del via


Column restrictions in a column definition

You can use column restrictions to specify how a column definition uses data or calculates information. You can also restrict a report column to a specific unit or for specific dates.

Note

A Column Restriction code overrides any conflicting setting that is assigned in the row definition.

This topic contains the following sections:

  • Column Restrictions cell

  • Column restriction codes

Column Restrictions cell

The Column Restrictions cell can include codes that restrict or suppress information, such as row formatting, details, and amounts, for that column.

Add a column restriction in a column definition

  1. In Report Designer, open the column definition to modify.

  2. Double-click the Column Restrictions cell for the column that you want to restrict.

  3. In the Column Restrictions dialog box, select one or more codes in the list, and then click OK.

Column restriction codes

The following table describes the column restriction codes.

Column Restriction Code

Description

SU

Suppresses the underscore for a column for which either an underscore command ( --- ) or a double underscore command ( === ) is entered in the row definition. For example, you might not want to underline amounts that are the result of a percentage calculation.

ST

Suppresses totals and shows only details in this column, for example, in statistical columns.

SD

Suppresses details and shows only TOT and CAL rows, from the row definition, in this column.

DR

Restricts the amounts in an FD column to debit amounts.

CR

Restricts the amounts in an FD column to credit amounts.

ADJ

Restricts the amounts in the column to period adjustment amounts, if available.

XAD

Restricts the amounts in the column to exclude the period adjustment amounts, if available.

PT

Restricts the amounts in the column to include posted transactions only, if available.

UPT

Restricts the amounts in the column to include unposted transactions only, if available.

NoteNote
Not all data providers support unposted transactions. For more information, see the data integration guide for your Microsoft Dynamics ERP system.

See Also

Column definition