Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Mapping a Single Report Param to 2 query params
Mapping a Single Report Param to 2 query params [message #846207] Sun, 15 April 2012 21:58 Go to next message
Tan Qten is currently offline Tan Qten
Messages: 2
Registered: April 2012
Junior Member
Hi


My dataset is a subquery, accepting a single param called NumDays in two WHERE clauses. I need to map a single report parameter to these and cannot see how to get this to work without creating two separate report params. Any ideas anyone?

TIA
-Tan
Re: Mapping a Single Report Param to 2 query params [message #846560 is a reply to message #846207] Mon, 16 April 2012 07:07 Go to previous messageGo to next message
Sergey Syr is currently offline Sergey Syr
Messages: 19
Registered: February 2012
Junior Member
param_1 -> report_param1
param_2 -> report_param1

Not?

[Updated on: Mon, 16 April 2012 07:12]

Report message to a moderator

Re: Mapping a Single Report Param to 2 query params [message #846924 is a reply to message #846560] Mon, 16 April 2012 21:58 Go to previous messageGo to next message
Tan Qten is currently offline Tan Qten
Messages: 2
Registered: April 2012
Junior Member
Hi,

Thanks - but that is what i tried already. I mapped two report params to the same query param thinking I'd get just one prompt at run time but it's not working that way.

-Tan
Re: Mapping a Single Report Param to 2 query params [message #847017 is a reply to message #846924] Mon, 16 April 2012 23:36 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Not sure if this what you are asking, but the only way to map one report
parameter to two data set parameters is to use property binding or
script to change the query. For example

define a data set with a query like select * from orderdetails

use a beforeOpen like
this.queryText = this.queryText + " where
ordernumber="+params["myparameter"].value;

Jason

On 4/16/2012 5:58 PM, Tan Qten wrote:
> Hi,
>
> Thanks - but that is what i tried already. I mapped two report params to
> the same query param thinking I'd get just one prompt at run time but
> it's not working that way.
>
> -Tan
Previous Topic:Reg: Grid lines in Excel files
Next Topic:Bubble chart color serie
Goto Forum:
  


Current Time: Sat Oct 25 05:47:11 GMT 2014

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

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