Salesforce

How Do I Define Aggregates per Break Level? (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

How Do I Define Aggregates per Break Level? (Magic xpa 4.x)

To define your break level aggregates, there are 3 steps:

  1. Define the aggregate variables

  2. Update the aggregates

  3. Zero out the aggregates

Let’s take each of these step by step.

1. Define the aggregate variables

The variables used for aggregates are usually just virtuals, and they are defined in the Data View as you would any virtual. However, with aggregates it is a good idea to have some kind of standard naming convention to make them easy to spot, because it is easy to use the incorrect variable. In this example, we added a capitalized prefix to specify which variable goes with which break level.

2. Update the aggregates

The easiest way to update the aggregates is to increment them all as each record is read. That way all your updating logic is in one place, which makes debugging faster.

3. Zero out the aggregates

Last, you need to zero out the aggregates. This can be done in the Group Prefix break level, or in Group Suffix after the aggregates have printed.

See also

The Online and Rich Client Samples projects (program RP04 and RRP04)

Reference
Attachment 
Attachment