BusinessObjects Board

how to add 'ALL' in prompt? and does it works?

building reports desktopintelligence
#1

Hi,
I tries this option to add ‘ALL’ option in a LOV.
Here
When I run report its showing me ‘ALL’ option in LOV but when I select ‘ALL’ and run report it shows ‘no data fatch’ there are data in a table.
I also tried another method which is explained in Businessobjects_advance.pdf that is
COS_COE.MV_PT in (select case @Prompt(‘Choose a country or
countries’,‘a’,‘COS_COE.MV_PT’,multi,constrained) when ‘ALL’ then COS_COE.MV_PT else @Variable(‘Choose a master port’) end)
but it also generated error. I opened case in BO Tech but they haven’t get back to me.
Any more ideas…
Thanks in advance

wack_jack (BOB member since 2005-12-28)

#2

I usually prompt for values “in list” when I want to give users the option to pick all. They just multi-select all the values in the available list and move them to the selected list.

Hope that helps.

capecam :us: (BOB member since 2006-01-23)

#3

Did you create the *ALL object and set up a union query?

Try taking a look at these as well:

https://bobj-board.org/t/15227/2

or here

https://bobj-board.org/t/60982

ngosz :us: (BOB member since 2003-09-25)

#4

Can you post your prompt code?

Michele Pinti (BOB member since 2002-06-17)

#5

Now this code is worked for me.
(@Select(Ffs Cos Coe Mv\Coe Cd) IN @Prompt (‘Enter COE ID:’,‘A’,‘Ffs Cos Coe Mv\Coe Cd’, MULTI, FREE)) OR (‘all’ IN @Prompt (‘Enter COE ID:’,‘A’,‘Ffs Cos Coe Mv\Coe Cd’, MULTI, FREE))
Before I tried without @select function but it was giving me error.
Can anyone explain me what does @select mean and how its works in a query?
As I know if we use @select function in a select it will point to another object select cluse(pointer) but what does it mean in a where clause of object?

Thanks to everyone…

wack_jack (BOB member since 2005-12-28)