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

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Change to CS Support service hours

Our Support department is closed on Friday, April 28th for a company event. However, limited Accounting CS phone support is available on that date from 9 AM - 5 PM ET due to the approaching deadline for quarterly payroll tax forms.

Links to our most popular payroll tax processing topics are available in the Alerts and notices section on the right side of most pages.

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: Reporting and Report Designer: Procedures

Share This