Hey Guys,
I have a crosstab in RS(created off a cube) and a list report(created off a relational datasource as nomal). I want to be able to drill through from the crosstab to the list.
So, I went about setting up the drill format in RS for the crosstab. Everything works but the date parameters. I'm using a tree prompt for all my prompts. However, the date prompt just won't pass the parameters - doing so results in Cognos returning an error concerning expected date format for the list report.
The crosstab has the date filter setup with a IN and the list report has the optional prompt setup with an in_range
Any ideas/suggestions please? :-[