Defining Row Sets
A Row Set defines the format and content of the rows in an FSG report. In FSG, the commonly assumed attribute for a row definition is an account assignment, whereas the attribute for a column definition is a time period (amount type).
When you define a row set, you can:
- Assign accounts -- to indicate which general ledger account balances you want to include in the row. You can assign an individual account or range of accounts to each row.
Note: If you have average balance processing enabled in your set of books, you can report on functional, foreign-entered, and translated average balances.
- Define calculations -- to perform a variety of complex computations in your report. The calculations can refer to any previous rows in a report, including rows you choose not to display.
- Specify formatting -- to control page breaks, indentation, line spacing, and underline characters.
You can define a new row set, or use FSG's AutoCopy feature to copy an existing row set, which you can then modify as needed.
To define a row set:
1. Navigate to the Row Set window.
2. Enter a Name and Description for the row set.
4. Enter a Line number for each row of the row set. The line number controls the order in which rows appear in a report. You also use the line number when creating a row calculation.
5. Enter a Line Item description for each row. This appears as the row label on any report you run using this row set.
6. (Optional) Enter the Format Options, Advanced Options, and Display Options for each row.
Note: If you want to create a report which reverses the commonly assumed attributes for row sets and column sets, you should also set your Balance Control Options for each row.
7. To have the row generate account balances on your report, choose Account Assignments to assign accounts to the row. To create a calculation row (for report totals and subtotals), choose Calculations.
Note: A row definition can have account assignments or calculations, but not both.
8. Define additional rows for the row set. (steps 4 through 7)
See Also
Row Set Format Options
Row Set Advanced Options
Display Options
Assigning Accounts
Defining Report Calculations
Defining Financial Reports
Copying Report Objects
Balance Control Options
Overview of Financial Statement Generator