Inserting aggregate function

Top  Previous  Next

So far we have manually inserted the aggregate functions into “Text” objects. Now we will look at other ways to insert aggregate functions.

 

Firstly, we can use the “System text” object to output an aggregate. In fact this object is similar to a “Text” object with its own special editor for more easily specifying system variables or aggregate functions:

 

clip0180

 

Select a function type, then a data band (over which the aggregate is to be calculated) and finally a DB field or an expression whose value is to be calculated. You can also set the “Count invisible bands” and “Running totals” flags, if required.

 

The second method is to use a “Text” object and click the _img140 button in its editor : this opens a dialogue similar to the “System text” object editor. When the OK button is clicked a call to the aggregate function is inserted into the object's text.