aggregates group

Teun Aben

Hello,

I would create a report and this is almost finished but I field (textbox15) has the wrong value.
I would create a sum of all itemprices (item_price) in one group (description).

I think I am almost there but I could not see it.

Coul someone help me please.

(in the attachment the rtf-file)

thanks in advance.


Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-file-uploads/ttjaben/LO_Trimergo.rst]LO_Trimergo.rst[/url]

Philipp Knecht

Hi Teun

When working with GroupBands its much more easier to get the Sums.
Just define your Sum in the Total Collection of the DataBand.

Then in the GroupBand Footer just Write : GetTotal("MySum"), that's it.

fyi: Don't use :

"Subtotaal " +advancedDataBand1("description") 

in the footer. Use:

"Subtotaal " +groupBand1("description") 

instead.

hth