Skip to main content



      Home
Home » Archived » BIRT » look-ahead aggregate(look-ahead aggregate)
look-ahead aggregate [message #890309] Thu, 21 June 2012 16:38 Go to next message
Eclipse UserFriend
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 11:34 Go to previous messageGo to next message
Eclipse UserFriend
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 12:34 Go to previous messageGo to next message
Eclipse UserFriend
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 17:09 Go to previous message
Eclipse UserFriend
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 Jul 16 22:19:02 EDT 2025

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

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

Back to the top