Adding 'All' as value in LOVs

[system]

Hi BO Gurus,
I have a requirement as given below:
I have a report where there are some prompts where I need to add value ‘All’ in LOVs of those prompts in such way that if user selects ‘All’ then it should display all the available data for that prompt.

All and all Optional Prompt does the same but the requirement to have value ‘All’ in LOVs.

Your help is appreciated.

Thanks

---

swap_l (BOB member since 2009-04-09)

[system]

Hi,

These 2 Designer’s FAQ will help you:

FAQ: Designer

Is there any way to set up a prompt that will allow a user to select one value, many values, or type ‘ALL’ for all values in a list? Yes. Below is a sample of the syntax required to allow a user to select one, many, or all values from a prompt. (@Select(Sales Geography\Country Group) IN @Prompt('Select Country Group or enter * for all groups','a','Sales Geography\Country Group',multi,free) ) OR ('*' in @Prompt('Select Country Group or enter * for all groups','a','Sales Geography\Co…

FAQ: Designer

Now that my LOV lets me use ALL for all values, how do I get the ALL in the list? Author: Dwayne Hoffpauir There are two approaches - overriding the LOV SQL, and creating a universe object. Overriding the LOV SQL Press the SQL button in the query panel of the LOV Add the phrase UNION SELECT ‘ALL’ FROM DUAL or similar dummy table for your particular database. For SQL Server (if you don’t care if the object parses or not) add SELECT xx From xx UNION SELECT ‘ALL’ (You don’t need a FRO…

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Hi,
Select the object that should be displayedas LOV in universe doubleclick on the object.select edit option in the properties window.The query panel will apppear. Clicl on sql in the tool bar. Append
SELECT ‘ALL’
UNION
with the existing query.Save and close.in the properties window click on display. you can see ‘ALL’ added with existing LOV

---

Lali_Sekar (BOB member since 2014-02-13)

[system]

I’ve tried the solution mentioned and was able to get the ‘ALL’ option to work.

But my Business demands that, the prompt should work only when the Object is placed in the ‘Query Filters’-WEBI.

Is there a way I can achieve this?

Thanks in advance.

AVBO

---

avbo (BOB member since 2012-03-16)