Eclipse Community Forums: BIRT

Home » Archived » BIRT » reuse parameter

Thu, 19 January 2006 14:32

Eclipse User

Hi list,

I'm looking for a way to reuse a parameter in the report designer.
I want to do something like 'where value_x between ? and ?-10'.

Regards,

Bart

Re: reuse parameter [message #111782 is a reply to message #111776]

Thu, 19 January 2006 14:36

Eclipse User

Bart Maertens a écrit :
> Hi list,
>
> I'm looking for a way to reuse a parameter in the report designer.
> I want to do something like 'where value_x between ? and ?-10'.
>
>
> Regards,
>
> Bart
Hi,

I have had the same problem and I have bound the two to the same value.
I don't know if there is an easier way... If the parameters could be
named (e.g : where value_x between ?v and ?v-10), it would be nicer.

Re: reuse parameter [message #111835 is a reply to message #111776]

Thu, 19 January 2006 17:29

Eclipse User

The easiest solution to your specific problem is this: "WHERE value_x -?
BETWEEN 0 and -10" :)

One possible solution for the more general issue is to use Property Binding
to bind the query text of a sql data set to a Javascript expression. Open
the Data Set Editor and go to the "Property Binding" tab, edit the query
text binding to an expression:
"SELECT ... WHERE value_x BETWEEN" + params["p1"] + " AND " +
params["p1"] + "-10"

regards,
--
Gary Xue
Actuate Corporation - Product Development
BIRT Committer
"Bart Maertens" <bart@bartmaertens.be> wrote in message
news:pan.2006.01.19.19.32.24.652147@bartmaertens.be...
> Hi list,
>
> I'm looking for a way to reuse a parameter in the report designer.
> I want to do something like 'where value_x between ? and ?-10'.
>
>
> Regards,
>
> Bart

Previous Topic:	Problems with the BIRT design engine API example
Next Topic:	BIRT demo

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Nov 03 17:10:51 EST 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter