Walkthrough of Report Components (8 min)

1. Navigate to the composite report “Trial Balance - Composite – EFM” by searching for it in the Search box, then click on the report

2. Open the composite report (without altering anything) and to see key elements – this should be in View mode (i.e., results/numbers will not be shown):

   1. Control Field

      1. Columns are indicated at the top of the table by C1, C2, C3, etc.  The Control Field is configured for this report as the first column (C1).

      2. Control Fields organize the data from the subreports by the Business Object

      3. Click on the Control field (C1) to highlight the column

      4. Note that when a column is highlighted, a down triangle appears

      5. Click the down triangle and select Edit

      6. The settings here allow you to specify the Business Object as the Control Field.  Click on the prompt for Business Object – note how there is only one available selection – Ledger Account.

         1. Note: There is another dependency below (Settings) that we will take a look at.

3. Data Column/s

   1. In C2-C5 are Data Columns – these columns display results from subreports

   2. Rows

   3. The first row R1 is a Combine Data row.  Combine data rows display all rows from the control field columns for all subreports.

   4. The second row is a Calculation.  This specific calculation is configured to total the sum of all rows above it.

4. Settings / Widget

   1. At the top right, beside the Run button, note the Settings icon (widget)

   2. Click the Settings icon

   3. The first tab “General” displays the Business Objects Enabled for Filtering and Grouping

   4. Note that only Ledger Account is there

   5. This is where additional Business Objects are added – however, in order to add more Business Objects, they must also be added to the subreports (yet another dependency).

   6. Click Cancel to return to the Composite Report

5. Run the report by clicking the “Run” button at the top rightNote the following:

6. Results are organized by the Ledger Account on the left hand-side

7. Four columns display to the right, each displaying results for a specific balance type (e.g., Beginning Balance)

8. This is a simple trial balance report that lists the accounting of balances for the organization by ledger account

9. Hover over the report name to use the Related Action > Custom Report > Print

   1. This provides you with the ability to print out a digestible view of your composite report (but not the sub reports) in case you need to provide a copy to a colleague

   2. On the tabs, click More > Sub Reports

   3. This lists the sub reports that make up the Composite report

   4. Note that there is only one sub report (but it is technically used multiple times – each time it is used for a different column)