Eclipse Community Forums: BIRT

Help

Home

Home » Archived » BIRT » Top 3 report

Show: Today's Messages :: Show Polls :: Message Navigator

Top 3 report [message #697084]

Fri, 15 July 2011 13:38

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

Report message to a moderator

Re: Top 3 report [message #697092 is a reply to message #697084]

Fri, 15 July 2011 14:01

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 02:24:56 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter