Create Reports - the Row Definition Tab
The same dimensions you moved to the Row Definition list box in the Axes tab now appears as columns in the Row Definition tab. These columns will contain information on exactly what you enter on each row, for example account codes or company codes.
All information on the Row Definition tab can be saved under a separate name and then be copied or reused in subsequent reports.
Example 1
On the Axes tab, you have selected the Account dimension in the Available list box and dragged it to the Row Definition list box. The Row Definition tab now displays the Account and Expand Account columns (local text and group text will always appear, regardless of the selected dimensions). In the Account column, you can enter which account codes or forms the report should contain. Select the Expand Account column if the underlying accounts should also be displayed when you generate the report. You can only expand summation accounts.
Text Strings/ Variables
You can enter the row texts for each row in both the local language and the group language. They can contain either one or more text strings or one or more variables. There are a number of variables for loading names and texts from the database. If you want to specify a number of variables or strings, use the Microsoft Excel function, which means that the strings appear one after the other in the same cell (on the same row) in the report.
Example 2
"=Concatenate(cc.fAcc()," ",cc.fAccName())".
For more information, see The Difference between Functions and Parameters.