Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Top 3 report
Top 3 report [message #697084] Fri, 15 July 2011 09:38 Go to next message
sam va is currently offline sam va
Messages: 121
Registered: July 2011
Senior Member
Hi
I have a report where it displays the top 3 items and the 4th row will be a sum of all the rest of the rows.
The query is

Select item_count, amount From table1

If the query returns less than 4, it will display those details.
In case the query returns more than 3 rows, lets assume 10 for now, the first 3 rows will be displayed as is, but the 4th row will be sum of all the rows from 4 thru 10.

any way to achieve this?

Thanks
Re: Top 3 report [message #697092 is a reply to message #697084] Fri, 15 July 2011 10:01 Go to previous message
sam va is currently offline sam va
Messages: 121
Registered: July 2011
Senior Member
No worries. I got it.

This is how I have done.

1) Hide all the rows after row 3
2) Add 2 rows in the footer.
One will aggregate all the values from row 4 to row 10
One will aggregate all values

Thanks
Previous Topic:How do i proceed to create automatics parameters in DataSet ?
Next Topic:How to retrieve enumeration type using BIRT?
Goto Forum:
  


Current Time: Wed Apr 16 03:34:48 EDT 2014

Powered by FUDForum. Page generated in 0.02915 seconds