BusinessObjects Board

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

building reports webintelligence
#1

This is the query I wiritten in default filter.

@Select(Vw Bus Cov Date\Region) IN @Prompt(‘01. Region Name’,‘A’,‘Vw Bus Cov Date\Region’,MONO,FREE)
OR
(‘ALL’ IN @Prompt(‘01. Region Name’,‘A’,‘Vw Bus Cov Date\Region’,MONO,CONSTRAINED))

I what to display ‘ALL’ from second query, allways at the bottom of the list of values return from first query in prompt drop down list.

Any Ideas in this regard, Please help me.

jinkaleo :india: (BOB member since 2007-01-25)

#2

Hi, You need to modify the sql from universe, object. Add

Union
select ‘ALL’ form Dual

in the sql…

pramodkumbhare :india: (BOB member since 2008-08-13)

#3

See this thread for more details. 2 ways to achieve the same are mentioned there.

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

#4

In the Universeedit the query of the region field(object) and add

Select “ALL” from DUAL.

Thanks,
Pragna

Pragna (BOB member since 2007-07-25)

#5

But can’t take ‘ALL’ from dual, Beacuase whenever we rename the universe name, the dual table will be disappear. We are changing the universe name while moving to the production, renaming the universe name is our requirement.

please any other idea.

jinkaleo :india: (BOB member since 2007-01-25)