Eclipse Community Forums: BIRT » How do I do multi-select parameter?

Home » Archived » BIRT » How do I do multi-select parameter?

How do I do multi-select parameter? [message #699634]

Thu, 21 July 2011 20:50

Eclipse User

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 11:12

Eclipse User

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
>
>

Attachment: MultiselectParameterQueryMod.rptdesign
(Size: 19.38KB, Downloaded 1399 times)

Re: (no subject) [message #702880 is a reply to message #699941]

Tue, 26 July 2011 19:00

Eclipse User

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 10:01

Eclipse User

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 10:06

Eclipse User

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
>
>