Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » How do I do multi-select parameter?
How do I do multi-select parameter? [message #699634] Fri, 22 July 2011 00:50 Go to next message
Brian Lavender is currently offline Brian LavenderFriend
Messages: 12
Registered: July 2009
Junior Member
What is the latest for creating a multi-select parameter? Is it baked into Birt now?

select name, state, zip, phone
from
people
where state in ('AZ','CA','NY','UT');

I want the user to be presented with a dynamically generated list and he selects multiple states from the list.


brian

(no subject) [message #699941 is a reply to message #699634] Fri, 22 July 2011 15:12 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Brian,

You can do this with a dataset filter or a little script in the
beforeOpen event of the datasource. I prefer the script as it pushes
down the in clause to the db. Take a look at the attached example.

Jason

On 7/21/2011 8:50 PM, Brian Lavender wrote:
> What is the latest for creating a multi-select parameter? Is it baked
> into Birt now?
>
> select name, state, zip, phone from
> people
> where state in ('AZ','CA','NY','UT');
>
> I want the user to be presented with a dynamically generated list and he
> selects multiple states from the list.
>
>
> brian
>
>
Re: (no subject) [message #702880 is a reply to message #699941] Tue, 26 July 2011 23:00 Go to previous messageGo to next message
Brian Lavender is currently offline Brian LavenderFriend
Messages: 12
Registered: July 2009
Junior Member
Great. Thanks for the example. The "Before Open" property is a little obscure, but it works. It took me a while to find it.
Re: (no subject) [message #716806 is a reply to message #699941] Thu, 18 August 2011 14:01 Go to previous messageGo to next message
gavinR  is currently offline gavinR Friend
Messages: 4
Registered: August 2011
Junior Member
Hello again Jason,

Do you have a similar report to this one, that is compatible with v2.3.2?

I have hit the same issue as Brian Sad

Regards,

Gavin

Jason Weathersby wrote on Fri, 22 July 2011 11:12
Brian,

You can do this with a dataset filter or a little script in the
beforeOpen event of the datasource. I prefer the script as it pushes
down the in clause to the db. Take a look at the attached example.

Jason

Re: (no subject) [message #716817 is a reply to message #716806] Thu, 18 August 2011 14:06 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

It is attached. I also attached how to do this if the where component
requires an integer.

Jason

On 8/18/2011 10:01 AM, gavinR wrote:
> Hello again Jason,
>
> Do you have a similar report to this one, that is compatible with v2.3.2?
>
> I have hit the same issue as Brian :(
>
> Regards,
>
> Gavin
>
> Jason Weathersby wrote on Fri, 22 July 2011 11:12
>> Brian,
>>
>> You can do this with a dataset filter or a little script in the
>> beforeOpen event of the datasource. I prefer the script as it pushes
>> down the in clause to the db. Take a look at the attached example.
>>
>> Jason
>
>
  • Attachment: querymod.zip
    (Size: 5.76KB, Downloaded 184 times)
Re: (no subject) [message #716820 is a reply to message #716806] Thu, 18 August 2011 14:06 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

It is attached. I also attached how to do this if the where component
requires an integer.

Jason

On 8/18/2011 10:01 AM, gavinR wrote:
> Hello again Jason,
>
> Do you have a similar report to this one, that is compatible with v2.3.2?
>
> I have hit the same issue as Brian :(
>
> Regards,
>
> Gavin
>
> Jason Weathersby wrote on Fri, 22 July 2011 11:12
>> Brian,
>>
>> You can do this with a dataset filter or a little script in the
>> beforeOpen event of the datasource. I prefer the script as it pushes
>> down the in clause to the db. Take a look at the attached example.
>>
>> Jason
>
>
  • Attachment: querymod.zip
    (Size: 5.76KB, Downloaded 187 times)
Re: (no subject) [message #989401 is a reply to message #699941] Thu, 06 December 2012 05:34 Go to previous messageGo to next message
Nihar Narla is currently offline Nihar NarlaFriend
Messages: 1
Registered: November 2012
Junior Member
Hi , I am new to BIRT,, Confused

Can u please explain me how did u do that parameter selection ..


I need the same logic for my report....


Please reply ASAP ,, very urgent ,,, Smile




Thank you

Nihar Narla
Re: (no subject) [message #989554 is a reply to message #989401] Thu, 06 December 2012 17:26 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1663
Registered: July 2009
Senior Member

Hi Nihar,

Where are you currently stuck at with this? Have you looked at the report above?


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:Is it possible to create dynamic datasets and how do I do this?
Next Topic:Scaling X-Axis
Goto Forum:
  


Current Time: Thu Nov 27 09:48:40 GMT 2014

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

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