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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Drill through with differing Time granularity for the target report

Started by bioCam, 17 Oct 2011 08:32:19 AM

Previous topic - Next topic

bioCam

Hi,

The source report has a Date prompt filter that takes in a date value (yyyy mon day HH:MIN - internals of 30min) to run the report.  There is a drill through from this report to a target report.  But the target report displays on a daily time (yyyy mon day). 

The source parameter is 'yyyy mon day HH:MIN' but the target requires a 'yyyy mon day'.  Do you have suggestion what I can do to pass the correct parameter value to the target report? 

Thank you.

Arsenal

would it help if you added a data item to the report query with the expression cast(?dateprompt?,date) and then pass the value of this dataitem to the date filter in the target report?