Skip to main content
Report Designer

Show detail of accounts in place of total

In Report Designer, you might want to show details of the individual accounts that make up a total amount in a report or statement. For example, the Balance Sheet - Current Year financial statement has a Stockholder's Equity section that shows a total amount for Capital Stock. You can take the following steps to show the detail of accounts in place of this total.
  1. Select
    File
    , then
    Report Designer
    .
  2. Double-click
    Balance Sheet - Current Year
    .
  3. Go to the Stockholder's Equity section of the report in the design grid.
  4. Select the cell that contains the text: Capital Stock.
  5. Right-click this cell, then select
    Delete Cell Contents
     from the context menu.
  6. In the same cell insert the variable:
    [ChartofAccountsActivity.Core.GLAccountDescription]
    .
    Variables panel showing Chart of Accounts Activity, then Core expanded. In the Core section, there are 6 variables and the GL Account Description item is highlighted.
  7. With the same cell selected, open the Cell Properties section in the Design Tools frame.
  8. Verify that the
    Grouping content
     matches in all cells with the variables on that row.
  9. Select the cell that shows the amount in the same row and clear the
    Print total amount
     checkbox.
  10. Right-click the row number button for the same row, then select
    Group into Repeating Level
     from the context menu.
    note
    • The report should now include the account detail in place of a total, as shown below.
      Shows a report with the Stockholder's Equity section in view (rows 41 to 48). There are seven rows in this section. Row 44 is highlighted. It contains the [ChartofAccountsActivity.Core.GLAccountDescription] variable.
    • 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.
  11. Select row 48 and drag your cursor to row 51 (where the total is displayed).
  12. Right-click and select
    Group into Repeating Level
     from the context menu to add these rows within the larger grouping level that includes rows 42–48.
    note
    Cells that contain references to other cells are unable to calculate if the cell being referenced is included in a grouping level that is more than 2 grouping levels away. If you do not extend the grouping level 1 to include row 51, the values from row 44 will not be included in the total.

This article applies to:

  • Product: Workpapers CS
  • Subject: Reports

Related Content