Hi all,
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
1)All operations
2)EM; Ford
3)EM: Cell
4)EM: Tell
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:Ford1
EM:Ford2
EM:Ford3
EM:Ford4
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
EM:Ford1
EM:Ford2
EM:Ford3
EM:Ford4
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 .