Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Dynamically Add Group To Table in BIRT
Dynamically Add Group To Table in BIRT [message #1006418] Thu, 31 January 2013 10:13 Go to next message
Paul Cockerill is currently offline Paul CockerillFriend
Messages: 14
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

Report message to a moderator

Re: Dynamically Add Group To Table in BIRT [message #1006770 is a reply to message #1006418] Fri, 01 February 2013 18:31 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
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

Developer Evangelist, Silanis

Report message to a moderator

Re: Dynamically Add Group To Table in BIRT [message #1007367 is a reply to message #1006770] Tue, 05 February 2013 16:14 Go to previous messageGo to next message
Paul Cockerill is currently offline Paul CockerillFriend
Messages: 14
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

Report message to a moderator

Re: Dynamically Add Group To Table in BIRT [message #1007379 is a reply to message #1007367] Tue, 05 February 2013 16:41 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
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

Developer Evangelist, Silanis

Report message to a moderator

Re: Dynamically Add Group To Table in BIRT [message #1007383 is a reply to message #1007379] Tue, 05 February 2013 16:55 Go to previous messageGo to next message
Paul Cockerill is currently offline Paul CockerillFriend
Messages: 14
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

Report message to a moderator

Re: Dynamically Add Group To Table in BIRT [message #1007399 is a reply to message #1006418] Tue, 05 February 2013 18:11 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
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

Developer Evangelist, Silanis

Report message to a moderator

Re: Dynamically Add Group To Table in BIRT [message #1009763 is a reply to message #1007399] Fri, 15 February 2013 16:57 Go to previous messageGo to next message
Paul Cockerill is currently offline Paul CockerillFriend
Messages: 14
Registered: August 2012
Junior Member
Thanks, just what i needed.

Paul

Report message to a moderator

Re: Dynamically Add Group To Table in BIRT [message #1009879 is a reply to message #1009763] Fri, 15 February 2013 22:58 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member
Not a problem. Let us know whenever you've got questions!

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: Dynamically Add Group To Table in BIRT [message #1766723 is a reply to message #1009879] Mon, 26 June 2017 13:50 Go to previous message
hatra atrin is currently offline hatra atrinFriend
Messages: 20
Registered: February 2014
Junior Member

Thanks this sample is very useful, I have similar but a little more complicated requirement
We have got a column "Type" returns A,B,C,D ( this could be static value , for know we assume "Type will return these " )
We want to group this values if "A" group by aa, ab, ac, ad, if "B" group by bb , bc, if "C", ca, cb, cd and if "D" group by da, dc, dd , then have total of each group individually as well as grand total of all groups,
any suggestions or sample you can share.
thanks

Version: 4.3.1
Build id: M20130911-1000

Report message to a moderator

Previous Topic: Pass parameter to BIRT via PHP
Next Topic:BIRT report designer 4.6.0
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 03:35:00 GMT 2024

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly