If you are unable to create a new account, please email support@bspsoftware.com

 

Specify in_range date parameter based on two separate dates (in drill-through)

Started by vebjornwa, 15 Dec 2009 03:22:49 AM

Previous topic - Next topic

vebjornwa

Hi,

We need to drill through to a destination report that has an in_range date parameter. The source report has two separate dates in the underlying query. These dates will always have values (not NULL).

Is it possible to "build" the input to an in_range parameter based on two separate date query items? We have tried to specify a new data item as a string expression utilizing the two dates, e.g.:

'Between ' || to_char([Date1], 'SomeDateFormat') || ' and ' || to_char([Date2], 'SomeDateFormat')

and send this data item to the parameter in the drill-thorugh definition, but it doesn't seem to work.

(The drilling is from a chart, where clicking on a week on the x-axis gives rise to the two dates (minimum and maximum within the week). This used to work when the destination report was using two separate date parameters instead of one in_range parameter, i.e. when the two dates could be sent directly to normal date parameters. This means that the drill-through is able to pick up the correct Date1 and Date2 values based on the click on the x-axis, but the specification of the in_range date parameter string is incorrect.)

All help is highly appreciated!