Display details with qty grouped as a total

Hi,

I'm new here and hope someone can help me on this. I'm using birt version 2.3

I have a report with a group and within that group I want to display the details but when it comes to the qty, I don't want to display the qty of each record.
Instead I want to display the total qty of that group at the 1st record of that group.

From the screen shot below, let's say I want to display qty ordered as 72 (which is 30 + 42) instead of 30 and don't display 42.

Find more posts tagged with

Comments

mwilliams

Hi Psych,

So, you're wanting to keep a running total over the group? As in display 30 and 72? Or are you just wanting the total for the entire product, 72? Let me know. I'd be glad to help.

Psych

Hi Michael,

Thanks for your reply.

I just want the total for the entire product, that is, 72.

mwilliams

Psych,

Putting an aggregation in the "product" group footer should be the only thing you'd need to change here.

Psych

Thanks Michael.

However, 72 will appear on both lines.
I only want it to appear at the line for 6jan2003. I used suppress duplicates but it did not work.

Psych

Found a solution.

I created a prev_product_group variable.
At details - onCreate, I set the prev_product_group to be the current product group.

At the visibility property, hide when the current product group is equal the prev_product_grp (which is a data field that i created and set to prev_product_group)