@Prompt with no value selected

[system]

Hi for all!

I´m trying use a @Ptompt in a WebI report, but the users wants select one or more values in prompt, but sometimes they need select no one value.

But, when leave the prompt in blank, the “execute” button is disabled.

EX.:

upper(dbo.f_dviagemRPT.EMPRESA_COTACAO) In @prompt(‘Enter value(s) for Empresa Aerea:’,‘A’,‘Filtro processo\Empresa Aerea’,Multi,Free,Persistent,User:1) with various values…

upper(dbo.f_dviagemRPT.EMPRESA_COTACAO) In @prompt(‘Enter value(s) for Empresa Aerea:’,‘A’,‘Filtro processo\Empresa Aerea’,Multi,Free,Persistent,User:1) with no values

someone can help whith this?

*** Sorry by my poor English.

Thank you!

---

martins.lfelipe (BOB member since 2010-03-30)

[system]

Hi,

Which BO version do you use? There are optional prompts in BO XI 3.

If you use lower version then explore the “ALL in LOV” concept. In few words, not entering any value in a prompt is the same as using the value ALL which is transformed behind the scenes into a condition that is always true (ALL=ALL):

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)