Skip to main content



      Home
Home » Archived » 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 17:58 Go to next message
Eclipse UserFriend
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 03:07 Go to previous messageGo to next message
Eclipse UserFriend
param_1 -> report_param1
param_2 -> report_param1

Not?

[Updated on: Mon, 16 April 2012 03:12] by Moderator

Re: Mapping a Single Report Param to 2 query params [message #846924 is a reply to message #846560] Mon, 16 April 2012 17:58 Go to previous messageGo to next message
Eclipse UserFriend
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 19:36 Go to previous message
Eclipse UserFriend
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:Y-axis scale
Goto Forum:
  


Current Time: Tue Jul 15 07:37:45 EDT 2025

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

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

Back to the top