[Closed] Cascading Problem

[ratikant]

Hi Gurus,
I am facing a problem in my report. That report picks up from a Native Query subject. My report has two prompts, Region and Branch. I am cascading the Branch prompt which reference to Region prompt. The problem is, when I am imposing a filter like [Regions] = ?Region? to my report list, then cascading is not working. All branches are populating to Branch Prompt inspite of Region selected.

Note: To populate Region and Branch prompt I am using different query and its taking data from dimension table.

Please help me..

Thanks.

[davidsoc]

Have you checked that the prompt properties of both the Regions and Branch are set correctly? e.g. cascading source, auto-submit etc.

[sir_jeroen]

Have you looked into my tutorial on Cascading prompts?