Adding a column restriction in Management Reporter

The Column Restrictions cell can include code that restrict or suppress row formatting, details, amounts, and so on for that column.

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

In this topic

Column Restriction Codes

Add a restriction to a column in a column definition

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).

Top of Page

Add a restriction to a column in a column definition

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

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

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×