(RUS) Assign a constant value for a cell in the Financial reports generator report
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
Use the Field setup form to assign a constant numeric or text value for a cell in the Financial reports generator (FRG) report that uses a Microsoft Excel template. In the lower pane of the Field setup form, when you create two consecutive lines with numeric values, an arithmetic operation is performed, and the value is displayed in the cell. If one of the lines has a string value, it is concatenated with the line with the numeric value.
Example
For the values in the table below, the following line is created: 2500Rubles500Rubles900Rubles.
Operator |
Line type |
Data |
|---|---|---|
+ |
Constant |
50 |
* |
Constant |
50 |
/ |
Constant |
Rubles |
+ |
Constant |
500 |
+ |
Constant |
Rubles |
+ |
Constant |
300 |
* |
Constant |
3 |
+ |
Constant |
Rubles |
Use the following procedure to assign a constant value for a cell.
Click General ledger > Setup > Financial reports generator > Financial reports generator. Select a report line, and then click Setup.
–or–
Click General ledger > Setup > Financial reports generator > Document templates. Select a document template, and then click Report. Select a report line, and then click Setup.
Select a report cell, and then in the lower pane, click Add to create a line.
In the Operator field, select a mathematical operator that is applied to the cell value.
In the Line type field, select Constant.
In the Data field, enter the value that is used to calculate the cell value.
See also
(EEUR) Create report cell operations