BusinessObjects Board

Using 'All' in cascading prompts

Hi Guys,

I want to create cascading prompts with ‘All’ in the LOV? When i select ‘All’ it should give me all list of values.
I tried adding ‘All’ in the object properties “UNION
SELECT ‘All’ FROM SYSIBM.SYSDUMMY1” but this does not solve my purpose. Its not displaying all the list of values when ‘All’ is selected.

Please help me if anyone has tried this…

Thanks in Advance
GJR


gjr (BOB member since 2005-06-09)

I suspect that you implemented partial solution.
By editing LOV, you are displaying All in the list for user to select.

Check the condition you implemented.

Your where clause of the DP will be something like
column in (‘All)’ if you select All.
So for Data base server it`s value you are looking for.

Your condition need to be created considering Database.

Hope this will help you.

Sujit Patange.


sujit_patange (BOB member since 2005-07-19)

Did you check out this entry in the Designer FAQ?


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

For oracle “Select ‘ALL’ from dual” will help. At the same time you should modify the prompt to make it understand that if you select ALL, then all the values in LOV should be selected.


bobjboy (BOB member since 2006-02-22)