Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Multiselect parameter with dynamic sql(multi parameters)
Multiselect parameter with dynamic sql [message #1790552] Tue, 12 June 2018 18:56 Go to next message
Anna Barwick is currently offline Anna BarwickFriend
Messages: 3
Registered: June 2018
Junior Member
I have a report that pulls training taken. I need the user to be able to select which filter to use to run the report; ( ie - by shop, department, date course taken). The selected parameter then sets the query to be run through a script. This part of the report is working fine.

However along with this, I would like the user to be able to select more than one training course. I am using the Open Access Birt Report tool.

I have tried several things I have found without success. Can anyone help?

I have Eclipse Neon version 4.6.0 loaded. I am working against a MySQL database.

Thanks in advance
Re: Multiselect parameter with dynamic sql [message #1790870 is a reply to message #1790552] Tue, 19 June 2018 11:17 Go to previous messageGo to next message
Eric Davis is currently offline Eric DavisFriend
Messages: 17
Registered: March 2018
Junior Member
Use a Dynamic Filter Parameter. It gives the ability to select multiple values and several other options. Use the IN operator to achieve this.
  • Attachment: Capture.PNG
    (Size: 31.24KB, Downloaded 173 times)
Re: Multiselect parameter with dynamic sql [message #1790876 is a reply to message #1790870] Tue, 19 June 2018 13:10 Go to previous messageGo to next message
Anna Barwick is currently offline Anna BarwickFriend
Messages: 3
Registered: June 2018
Junior Member
The Open Source BIRT does not have that built in scripting function. My screen does not look like yours.
Re: Multiselect parameter with dynamic sql [message #1791021 is a reply to message #1790552] Thu, 21 June 2018 14:39 Go to previous message
Anna Barwick is currently offline Anna BarwickFriend
Messages: 3
Registered: June 2018
Junior Member
Help still needed
Previous Topic:Which task is fater (best performer)? (RunAndRender vs. Run and Render)
Next Topic:Maximo PDF Charts not rendering in SVG format
Goto Forum:
  


Current Time: Thu Mar 28 22:33:19 GMT 2024

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

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

Back to the top