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

Note Note

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

Add a column restriction in a column definition

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

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

  3. In the Column Restrictionsdialogue 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 TOTand CALrows, from the row definition, in this column.

DR

Restricts the amounts in an FDcolumn to debit amounts.

CR

Restricts the amounts in an FDcolumn 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.

Note Note

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

See Also