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] Thu, 21 July 2011 20:50 Go to next message
Brian Lavender is currently offline 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

(no subject) [message #699941 is a reply to message #699634] Fri, 22 July 2011 11:12 Go to previous messageGo to next message
Jason Weathersby is currently offline 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
>
>


Jason Weathersby

BIRT Exchange
Re: (no subject) [message #702880 is a reply to message #699941] Tue, 26 July 2011 19:00 Go to previous messageGo to next message
Brian Lavender is currently offline 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.
Re: (no subject) [message #716806 is a reply to message #699941] Thu, 18 August 2011 10:01 Go to previous messageGo to next message
gavinR  is currently offline 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

Re: (no subject) [message #716817 is a reply to message #716806] Thu, 18 August 2011 10:06 Go to previous messageGo to next message
Jason Weathersby is currently offline 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
>
>
  • Attachment: querymod.zip
    (Size: 5.76KB, Downloaded 160 times)


Jason Weathersby

BIRT Exchange
Re: (no subject) [message #716820 is a reply to message #716806] Thu, 18 August 2011 10:06 Go to previous messageGo to next message
Jason Weathersby is currently offline 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
>
>
  • Attachment: querymod.zip
    (Size: 5.76KB, Downloaded 151 times)


Jason Weathersby

BIRT Exchange
Re: (no subject) [message #989401 is a reply to message #699941] Thu, 06 December 2012 00:34 Go to previous messageGo to next message
Nihar Narla is currently offline Nihar Narla
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 12:26 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 1424
Registered: July 2009
Senior Member

Hi Nihar,

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


Michael
Actuate – The BIRT Company™

BIRT Developer Center
Check out the new, free BIRT Viewer Toolkit
Previous Topic:Is it possible to create dynamic datasets and how do I do this?
Next Topic:Scaling X-Axis
Goto Forum:
  


Current Time: Mon Apr 21 03:17:27 EDT 2014

Powered by FUDForum. Page generated in 0.02445 seconds