Eclipse Community Forums: BIRT » look-ahead aggregate

Help

Home

Home » Eclipse Projects » BIRT » look-ahead aggregate(look-ahead aggregate)

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

look-ahead aggregate [message #890309]

Thu, 21 June 2012 20:38

Aleksey

Messages: 42
Registered: April 2012

Member

Does BIRT 3.7.0 support them and if yes what is the signature? thanks...

Report message to a moderator

Re: look-ahead aggregate [message #890574 is a reply to message #890309]

Fri, 22 June 2012 15:34

Jason Weathersby

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...

Report message to a moderator

Re: look-ahead aggregate [message #890605 is a reply to message #890574]

Fri, 22 June 2012 16:34

Aleksey

Messages: 42
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

Report message to a moderator

Re: look-ahead aggregate [message #890692 is a reply to message #890605]

Fri, 22 June 2012 21:09

Jason Weathersby

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

Report message to a moderator

Previous Topic:	JSP-Files behind Toolbar
Next Topic:	Suppress group headers based on condition

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 19 13:38:14 GMT 2020

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter