BusinessObjects Board

To Insert ' ALL' at top of lov selected in BO6.5

building semantic layer
#1

Hi all

I want to display ’ ALL’ value on top of list of values selected in BO 6.5

Can any one can suggest me

(i had some idea to use @prompt but it is failing)

Thanq

Anjaneyulu :india: (BOB member since 2008-03-20)

How to display 'ALL' bottom of the list of values in filter
#2

I think you are asking about including ALL in prompts. There are two ways to achieve this and they both are discussed here in Designer FAQ

Jansi :india: (BOB member since 2008-05-12)

#3

hi

open your universe and select the object for which you are going to include ALL.
click->properties->edit button-> SQL


SELECT    DISTINCT
  table.object
FROM
  table
union 
select ' ALL'  from dual

the space that you have given in the above code before ALL will make this to appear first.
try this

judia

judia (BOB member since 2008-06-24)

#4

Hi,
I tried it in another way. it was someting like this.

This should give the ‘ALL’ at the top. if you keep ’ ALL’, then if you any of the record somes with 2 spaces at the first then it can be an issue. Just to avoid this, I tried this way.

Omkar Paranjpe :us: (BOB member since 2006-02-13)