|
(no subject) [message #699941 is a reply to message #699634] |
Fri, 22 July 2011 15: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
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 #716817 is a reply to message #716806] |
Thu, 18 August 2011 14:06 |
|
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 513 times)
|
|
|
Re: (no subject) [message #716820 is a reply to message #716806] |
Thu, 18 August 2011 14:06 |
|
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 486 times)
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03966 seconds