"ALL" Dynamic prompt

[system]

Hi,

Please guide me on how to create the prompts at universe level. I need to include the “ALL” to the object values.

Thanks and Regards,
Vipul

---

V’pul (BOB member since 2005-11-24)

[system]

Hi,

Please do a search prior to posting. This question is in the FAQ’s in the Designer forum

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…

---

irish_stan (BOB member since 2003-05-13)

[system]

Moved from “General Discussion” to the “Semantic Layer” forum, which is where Designer topics are discussed.

---

Anita Craig (BOB member since 2002-06-17)

[system]

Hi ALL,

Thanks for your reply…
But when I run the report then the report is not selecting any values.

I wrote the code as:

Select Clause :

@Select(Application\Application Name)

Where Clause :

(@Select(Application\Application Name) IN @Prompt(‘Select Application Name or Type All To Select All The Applications’,‘A’,‘Application\Application Name’,Multi,Free) ) OR
(‘All’ in @Prompt(‘Select Application Name or Type All To Select All The Applications’,‘A’,‘Application\Application Name’,Multi,Free))

There is no error in this code and parse is ok.

But when I refresh the report and provide the values for the prompt then report is not selecting any records.

Please help me in this problem.

Thanks and Regards,
Vipul Garg

---

V’pul (BOB member since 2005-11-24)

[system]

Well, your code looks to me corrent but try this things:
Edit LOV of Application\Application Name and add this code.

 UNION (Select 'ALL' from table name) 

Now save and close it and click on display button to check LOV and Click on Export with Universe check box. Then export universe and refresh reprot.

---

wack_jack (BOB member since 2005-12-28)