how to sum up several datarows and place the computed value in a specific row.

I'm basically looking to build a report displaying top 10 records and 11 record
sums up all the remaining records.

Please advise how to implement it in single dataset using scripting and not multiple datasets.

Thanks and Regards,
Muthul.

Find more posts tagged with

Comments

Megha Nidhi Dahal

Hi Muthul,

You can use aggregation on every column that you want to sum up.

regards
Arpan

Hans_vd

Try this:

- Add a computed column to the dataset with a RUNNINGCOUNT aggregation
- Add a second computed column to the dataset with an expression in it that does this:
if value runningcount computed column > 10 then { your_value } else { 0 }
- Build an expression in the visibility property of the detail row, that hides the row if the runnincount computed column > 10
- add an aggregation in the footer row that is the sum of the second computed column

Hope this helps