Eclipse Community Forums: BIRT » Mapping a Single Report Param to 2 query params

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

Eclipse User

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

Eclipse User

param_1 -> report_param1
param_2 -> report_param1

Not?

Attachment: birt_param.jpg
(Size: 87.38KB, Downloaded 202 times)

[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

Eclipse User

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

Eclipse User

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:

-=] Back to Top [=-

Current Time: Sun Jul 20 10:22:47 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter