Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » look-ahead aggregate(look-ahead aggregate)
look-ahead aggregate [message #890309] Thu, 21 June 2012 20:38 Go to next message
ivkina Mising name is currently offline ivkina Mising nameFriend
Messages: 44
Registered: April 2012
Member
Does BIRT 3.7.0 support them and if yes what is the signature? thanks...
Re: look-ahead aggregate [message #890574 is a reply to message #890309] Fri, 22 June 2012 15:34 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Yes BIRT supports look ahead aggregates:
http://wiki.eclipse.org/BIRT/FAQ/Scripting#Q:_Does_BIRT_support_look-ahead_.28two-pass.29_aggregates.3F
The above wiki page is a bit out of date. Instead of using the total
function the suggested approach is to use aggregation report item or
computed columns with aggregate functions.

Open the help guide in the designer and search for aggregating data.

You can even implement your own aggregates using Eclipse plugin:
http://birtworld.blogspot.com/2006/09/optimistic-sums.html

Jason

On 6/21/2012 4:38 PM, ivkina Mising name wrote:
> Does BIRT 3.7.0 support them and if yes what is the signature? thanks...
Re: look-ahead aggregate [message #890605 is a reply to message #890574] Fri, 22 June 2012 16:34 Go to previous messageGo to next message
ivkina Mising name is currently offline ivkina Mising nameFriend
Messages: 44
Registered: April 2012
Member
Jason,
So there is no special checkbox or other indicator to say that this a look ahead aggregate...just use the aggregate function anywhere in the report (table header for instanse) and Birt should figure out that automatically?

Thanks,
Aleksey
Re: look-ahead aggregate [message #890692 is a reply to message #890605] Fri, 22 June 2012 21:09 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

This depends I believe on the type of aggregate. For example TOPN and
BOTTOMN aggregates require multiple passes where others do not. BIRT
figures this out on its own based on the implemented functions. In fact
if you implement your own you can set the number of passes.

Jason

On 6/22/2012 12:34 PM, ivkina Mising name wrote:
> Jason,
> So there is no special checkbox or other indicator to say that this a
> look ahead aggregate...just use the aggregate function anywhere in the
> report (table header for instanse) and Birt should figure out that
> automatically?
>
> Thanks,
> Aleksey
Previous Topic:JSP-Files behind Toolbar
Next Topic:Suppress group headers based on condition
Goto Forum:
  


Current Time: Wed Sep 23 10:44:05 GMT 2020

Powered by FUDForum. Page generated in 0.01462 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top