Skip to Content
0
Former Member
Oct 06, 2013 at 08:23 PM

Custom Prompt value Selction

35 Views

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 .