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

Help

Home

Home » Archived » BIRT » Mapping a Single Report Param to 2 query params

Show: Today's Messages :: Show Polls :: Message Navigator

Mapping a Single Report Param to 2 query params [message #846207]

Sun, 15 April 2012 21:58

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

Report message to a moderator

Re: Mapping a Single Report Param to 2 query params [message #846560 is a reply to message #846207]

Mon, 16 April 2012 07:07

Sergey Syr

Messages: 19
Registered: February 2012

Junior Member

param_1 -> report_param1
param_2 -> report_param1

Not?

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

[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

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

Report message to a moderator

Re: Mapping a Single Report Param to 2 query params [message #847017 is a reply to message #846924]

Mon, 16 April 2012 23:36

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

Report message to a moderator

Previous Topic:	Reg: Grid lines in Excel files
Next Topic:	Y-axis scale

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 19:56:56 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter