Read How_to_create_subtotals_in_listing_based_on_join_structure.pdf text version

Report Studio

How to Subtotal on Sections in a Listing Report Based on a Join Structure

In this example, a listing report is required to provide subtotals for each Grant and for each Account within the grant. The problem is in the generation of subtotals when the source query is a product of joined queries. Notice in the picture in Step 3, after aggregating (total) on the amount column, subtotals are only generated for Grant ID. The trick is to manually insert subtotals for the Account group. Step 1 Set up the report in a list with the fields that you want to group on at the left side (probably best to arrange them in the order of sectioning).

Step 2: Group on Grant ID and then Account

Step 3: Click on Bill_Transaction_Amount and aggregate it (total)

6/30/2010

Page 1

Report Studio

Step 4: Click on the Header/Footer button, select `List Headers and Footers', and add a footer for Account by clicking on the box next to it:

You will notice that the footer row is one large cell (see Step 5 below).

6/30/2010

Page 2

Report Studio

Step 5: Click on the Account summary line and then click on the Split Cell button

Step 6: Click on the lock to Unlock the report and then drag Bill_Transaction_Amount over into the cell in the Trans Amount column:

Step 7: Lock the report and create your sections by clicking on Agency ID and then Account:

6/30/2010

Page 3

Report Studio

Run the report

Note: Create the groups first and then create the sections after the subtotals have been created. Also note that this technique is not necessary when the source query is not a product of other queries joined together.

6/30/2010

Page 4

Information

4 pages

Find more like this

Report File (DMCA)

Our content is added by our users. We aim to remove reported files within 1 working day. Please use this link to notify us:

Report this file as copyright or inappropriate

1034976


You might also be interested in

BETA