COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: CArnold40 on 25 May 2007 12:12:47 PM

Title: [RS] Problem with a cascading prompt in 8.2
Post by: CArnold40 on 25 May 2007 12:12:47 PM
 ???

In COGNOS 8.1, I have a report that has 3 prompts, each cascading. IN other words:

Prompt1
Prompt2 (Cascade Source - Prompt1)
Prompt3 (Cascade source - Prompt2)

All prompts work fine in their current environment (8.1).

When I export this report from 8.1 and import it into our new COGNOS 8.2 environment:

Prompt1 works just fine (it's just a date range prompt).
Prompt2 seems to work fine.
Prompt3 just comes up blank, with nothing to select.

In both environments (8.1 & 8.2) I'm hitting the same data source.
I even tried rebuilding the 3rd prompt in the 8.2 environment and I still have the same issue.

Has anyone come across this problem before? And if so, what did you do to resolve it?

ANY help is greatly appreciated.

Chris
Title: Re: [RS] Problem with a cascading prompt in 8.2
Post by: goose on 26 May 2007 03:49:22 AM
I did a test woked fine try these steps:

1. Check that the Prompt 3 query has a filter for the parameter set to Prompt 2

2. Check that auto submit is true for prompt 2 (otherwise you must click Next for Prompt 3 to get populated)

Hope this helps, otherwise replicate using GOSL and post report spec