Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Dynamically Add Group To Table in BIRT
Dynamically Add Group To Table in BIRT [message #1006418] Thu, 31 January 2013 05:13 Go to next message
Paul Cockerill is currently offline Paul Cockerill
Messages: 12
Registered: August 2012
Junior Member
I want to GROUP my report based on a parameter selected by the user. I am able to drop the current group in BeforeFactory, however how can I pass the parameter selected by the user to update the value the data will be grouped by.

For example I will provide a parameter with the Values "AREA" and "SALESMAN". Depending on what's selected I would like the report to group by the selected data.

Thanks in advance
Paul
Re: Dynamically Add Group To Table in BIRT [message #1006770 is a reply to message #1006418] Fri, 01 February 2013 13:31 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1546
Registered: July 2009
Senior Member

Have you tried just using the expression builder, for the group field to change the grouping based on the parameter? Then, you could do something similar in a dynamic text for the group header.

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Dynamically Add Group To Table in BIRT [message #1007367 is a reply to message #1006770] Tue, 05 February 2013 11:14 Go to previous messageGo to next message
Paul Cockerill is currently offline Paul Cockerill
Messages: 12
Registered: August 2012
Junior Member
Not been using BIRT for very long. I will give it a go and let you know how I get on.

Thanks
Re: Dynamically Add Group To Table in BIRT [message #1007379 is a reply to message #1007367] Tue, 05 February 2013 11:41 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1546
Registered: July 2009
Senior Member

Ah. Well, let me know if you run into issues. If you give me your BIRT version, I can make an example.

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Dynamically Add Group To Table in BIRT [message #1007383 is a reply to message #1007379] Tue, 05 February 2013 11:55 Go to previous messageGo to next message
Paul Cockerill is currently offline Paul Cockerill
Messages: 12
Registered: August 2012
Junior Member
Thanks. Version Number 2.5.2 Bit behind but our ERP supplier prefers this version for compatibility reasons.

Hopefully we will be able to upgrade when we install the next major release.

Thanks
Paul
Re: Dynamically Add Group To Table in BIRT [message #1007399 is a reply to message #1006418] Tue, 05 February 2013 13:11 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1546
Registered: July 2009
Senior Member

Take a look at this example. Look at the expression for the grouping on the table. Also, look at the expression in the text box in the group header.

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Dynamically Add Group To Table in BIRT [message #1009763 is a reply to message #1007399] Fri, 15 February 2013 11:57 Go to previous messageGo to next message
Paul Cockerill is currently offline Paul Cockerill
Messages: 12
Registered: August 2012
Junior Member
Thanks, just what i needed.

Paul
Re: Dynamically Add Group To Table in BIRT [message #1009879 is a reply to message #1009763] Fri, 15 February 2013 17:58 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 1546
Registered: July 2009
Senior Member

Not a problem. Let us know whenever you've got questions!

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Previous Topic:chart Zooming
Next Topic:Change BIRT Logging level for specific class/package
Goto Forum:
  


Current Time: Tue Jul 22 09:43:37 EDT 2014

Powered by FUDForum. Page generated in 0.01660 seconds