COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: bioCam on 17 Oct 2011 08:32:19 AM

Title: Drill through with differing Time granularity for the target report
Post by: bioCam on 17 Oct 2011 08:32:19 AM
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.
Title: Re: Drill through with differing Time granularity for the target report
Post by: Arsenal on 18 Oct 2011 09:48:58 AM
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?