Display totals on a report

In the Report Designer, add group and report totals using the Stripe container.

  1. Open the report design (.4rp) file.
  2. In the Report Design window, define Stripes in the design document, one for each total.
  3. Use Tool Box elements to hold the values, for example, Decimal Format Boxes.
  4. In the Structure View, drag each Stripe and drop it onto the trigger node for the corresponding group trigger. This will position the Stripe as a child of the trigger node and display it at the end of the group. It is important that the total stripes are the last child element of a report trigger node.

Example

In this example, the line_total Stripe is the last child of the Group linenum, the order_total Stripe is the last child of the Group orderid, and the user_total Stripe is the last child of the Group userid. The report_total Stripe was dropped onto the Page Root, the main page for the report. This positions the Stripe as a child of the Page Root, and places it at the very bottom of the child list for that trigger.

Figure: Example Report Structure

This figure shows the Report Structure created by modifying the report application to include an order_total, store_total, and report_total in the report. See the surrounding text for more information about modifying the report application and Report Structure to add group and report totals.

On each change of data, the specified data for every corresponding row will print, and the appropriate Stripe will print after each change of Group. The report_total Stripe will be the last thing to print out on the report. The values of any data objects in the Stripe are taken from the immediately preceding row of data (the last report line of the container for onEveryRow trigger).