HI,

I had developed an report which contains a pair cascading prompt from 1 table and one more pair of cascading prompt from other table.

For my report i should have All option as a default in all the prompt.

but when i try to include "ALL" option in the prompts by selecting the All option in the parameters tab ( available in properties) and then run the report i get a wrong result, i.e when i select ALL any one of the prompt and then run the report i get an output as though ALL option is selected for all the 4 prompts.

I tried to do some mannual coding but i was not successful.

I have also have to implement drill down in my report.

My other problem is when i select ALL option my drill down does not work, if i dont select all optin the drill down works.

I am fetching my value for the prompts dynamically.

Kindly help me with a suitable solution

The 'ALL' option returns FOC_NONE. Try to look into this link and see if it will help you.

https://forums.informationbuilders.com/eve/forums/a/tpc/...781098331#1781098331

Good Luck!

Remember that FOC_NONE causes the entire line that it appears on to be ignored. Put your WHERE statements on separate lines.

WHERE field1 EQ '&VAR1';
WHERE field2 EQ '&VAR2';

Thank you guys for your reply.

Now I am able to get proper report output, when i select all.

But i think you missed my other question

Question : If i select All option in any one of the prompt the Drill down does not work,
How to overcome this problem

Kindly give me a sutiable solution

Regards
Sengot