Adding a 'Show All' Option to my LOV

[system]

I’m currently using BO XI r2. I want to create a WebI report which has filter prompts which include the option to show all values. Example - a report which prompts the user to select a Month and also Year. I want my users to have the option of selecting a specific month from the list of values, OR selecting ‘Show All’ from the same list, essentially deactivating that filter. Is there some way to implement this in Designer?

---

adricey (BOB member since 2008-07-09)

[system]

You would need to create a condition in the universe for this.

---

Marfi (BOB member since 2006-12-18)

[system]

Hi,

These Designer’s FAQs will help:

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)