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

Help

Home

Home » Eclipse Projects » BIRT » How do I do multi-select parameter?

Show: Today's Messages :: Show Polls :: Message Navigator

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

Thu, 21 July 2011 20:50

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

Report message to a moderator

(no subject) [message #699941 is a reply to message #699634]

Fri, 22 July 2011 11:12

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

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

Jason Weathersby

BIRT Exchange

Report message to a moderator

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

Tue, 26 July 2011 19:00

Brian Lavender
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.

Report message to a moderator

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

Thu, 18 August 2011 10:01

gavinR
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

Report message to a moderator

Re: (no subject) [message #716817 is a reply to message #716806]

Thu, 18 August 2011 10:06

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