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

Question about drilling thru from crosstab to detail list

Started by Arsenal, 05 Jun 2007 11:01:51 PM

Previous topic - Next topic

Arsenal

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? :-[