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?
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
On 4/16/2012 5:58 PM, Tan Qten wrote:
> 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.