Skip to main content


Eclipse Community Forums

      Home
Home » Archived » 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
Eclipse UserFriend
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
Eclipse UserFriend
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.
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
Eclipse UserFriend
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
Eclipse UserFriend
Ah. Well, let me know if you run into issues. If you give me your BIRT version, I can make an example.
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
Eclipse UserFriend
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
Eclipse UserFriend
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.
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
Eclipse UserFriend
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 messageGo to next message
Eclipse UserFriend
Not a problem. Let us know whenever you've got questions!
Re: Dynamically Add Group To Table in BIRT [message #1766723 is a reply to message #1009879] Mon, 26 June 2017 09:50 Go to previous message
Eclipse UserFriend

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
Previous Topic: Pass parameter to BIRT via PHP
Next Topic:BIRT report designer 4.6.0
Goto Forum:
  


Current Time: Wed Jul 23 12:24:31 EDT 2025

Powered by FUDForum. Page generated in 0.10069 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