I am using Business view manger and dynamic cascading (LOV) when i run my report the scenarios is like this
In the first prompt values are
and my second prompt when i select one from above
All operations will give me all operation
and when i select 2 option EM: ford i get required values which is as follows
EM:Ford5 for this i have added All EM FORD (through Dual in sql )operations now the second prompt becomes like this
All EM FORD
When i select All EM FORD or all other options(EM:Ford1.......) the output must be same since All EM FORD is added by me it will not give me any results in report how to write a selction formula for this?if i select All EM FORD it must take all values but not show in prompt .