Agggregating across two tables

JasonW

It is often better to use a crosstab when wanting to aggregate data acrosss multiple datasets but you can also use a bit of scripting. In the attached example look at the oncreate script of the aggregation element. It stores a global variable that is used in the expression of a later table.