|
|
| Re: Multiple values for Report Parameters [message #221719 is a reply to message #221578] |
Wed, 28 February 2007 13:56   |
Eclipse User |
|
|
|
Originally posted by: xxx.xxx.cl
Ravi wrote:
> Keeping the question short ...
> Can multiple values be supplied to a report parameter?
Mauro answered at 2/1/2007 3:59 AM:
Message-ID: <eps355$e6u$1@utils.eclipse.org>
I have got around this problem by replacing the comma in the comma
seperated
list with ','
For example, I enter a parameter such as 37,23,47,58
In the Edit Data Set window, Property Binding section, I modified the query
to:
"SELECT .... FROM ... WHERE id in ('" +
params["pID"].value.replace(",","','") + "')"
The javascript replace() method replaces all instances of , with ','
So the query string executed is changed from '37,23,47,58' to
'37','23','47','58' which produces the correct output.
|
|
|
| Re: Multiple values for Report Parameters [message #236630 is a reply to message #221719] |
Thu, 26 April 2007 18:18 |
| Eclipse User |
|
|
|
Román wrote:
> Ravi wrote:
>
>> Keeping the question short ...
>> Can multiple values be supplied to a report parameter?
>
>
>
> I have got around this problem by replacing the comma in the comma
> seperated
> list with ','
> For example, I enter a parameter such as 37,23,47,58
>
> In the Edit Data Set window, Property Binding section, I modified the query
> to:
>
> "SELECT .... FROM ... WHERE id in ('" +
> params["pID"].value.replace(",","','") + "')"
>
Here is something I have tried:
For a query like
select * from tbl where id in (?,?,?)
The 'Parameters' in dataset editor can be used to set values for the
different '?' (dynamic markers) , this can be linked to report parameter
also.
regards,
Sunitha.
|
|
|
Powered by
FUDForum. Page generated in 0.03903 seconds
Home