BIRT Creating Your Own Running Sum in a Crosstab

mwilliams

This example shows a way to create a running sum across a crosstab. The column dimensions in this example don't really make sense to keep a running total of, but the concept is valid nonetheless. <br />
<br />
Since there is no running sum option for a crosstab measure, you have to make this funtionality yourself. The way it was done in this report was to use persistentGlobalVariables to keep track of each row's current total. The PGV's were named using the row dimension value so that the totals would not get mixed up. The script to do the addition, storing, and display is in the text box that was placed in the crosstab in place of the measure element. The grand total row has also been set up to display the running sum. Both the standard crosstab and running sum crosstab are displayed so that you can see what is being added.<br />
<br />
This report was designed in BIRT 2.5.1.