Skip to Content
Sep 11, 2017 at 01:55 AM

Cascading Prompt issue


context.pngHi, I want to create a Cascading prompt, but i am facing context issue, Example: I have a table A,B,C,D,E,F Want to create Cascading Prompt from Table A Object and Table C Object, The Context i have created one for A, B,D and C - Context name : CNT1 The other Context i have created for A, E,F and C - Context name: CNT2 I have created the Cascading prompt and When i runt the report its showing list of context CNT1 and CNT2 to choose Cascading prompt i created in below method In designer from Table A object went to query panel and the Condition created prompt from the Table C object. Also i have did context set in the report level, if i delete the cascading prompt report is fine its not asking the context to choose The problem is Table A and Table C is applicable for both the context , Due to this its asking which path you want to choose, can you please advise me how to resolve.


context.png (14.6 kB)