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
In Report Designer, open the column definition to modify.
Double-click the Column Restrictions cell for the column that you want to restrict.
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. .gif "Note") Note
Not all data providers support unposted transactions. For more information, see the data integration guide for your Microsoft Dynamics ERP system.
|