Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » reuse parameter
reuse parameter [message #111776] Thu, 19 January 2006 19:32 Go to next message
Bart Maertens is currently offline Bart MaertensFriend
Messages: 10
Registered: July 2009
Junior Member
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 19:36 Go to previous messageGo to next message
Benoît Hericher is currently offline Benoît HericherFriend
Messages: 13
Registered: July 2009
Junior Member
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 22:29 Go to previous message
Gary Xue is currently offline Gary XueFriend
Messages: 193
Registered: July 2009
Senior Member
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:
  


Current Time: Mon Aug 19 14:19:08 GMT 2024

Powered by FUDForum. Page generated in 0.03302 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top