Report Designer: Showing detail of accounts in place of a total

Alerts and notices

In the Report Designer, you can set up a report or statement to display the details of individual accounts that make up an amount. For example, on the Balance Sheet - Current Year financial statement, the Stockholders' Equity section displays the total amounts for Capital Stock accounts.

Show the Stockholder's Equity section of the report in the design grid.

Use the following steps to set up the Balance Sheet - Current Year statement to display the account details that make up the total for Capital Stock.

  1. In the design grid, select the cell that contains the text Capital Stock, right-click and choose Delete Cell Contents.
  2. In the same cell insert the [ChartofAccountsActivity.Core.GLAccountDescription] variable. Show the Variables section in the Design Tools frame.
  3. With the same cell selected, open the Cell Properties section in the Design Tools frame to verify that the Grouping content matches in all cells with the variables on that row.
  4. Right-click the row number button for the same row and choose Group into repeating level. Show the right-click menu.
    Right Click Menu
    The report should now include the account detail in place of a total, as shown below.

    Note: If rows were inserted or removed in this section, be sure to review the formulas for the totals to ensure that the correct cells are included in the report.

    Modified Report
  5. Click row 48 and drag your cursor to row 51 (where the total is displayed), and then right -click and choose Group into repeating level to add these rows within the larger grouping level that includes rows 42-48.

Related topic: Report Designer: Procedures

Share This