ALL object

[system]

hi there,

I’m building a report in webi with more than 10 prompts/filters. That’s how the user wants it coz he’s patterning it after a certain application. Anyway, he gets to input all these 10. but there are instances that he may just want to supply a few and the rest to pick everything.

I understand that I can actually create an ALL object and display this as part of the LOV but am just not sure how.

Any help is greatly appreciated and do you have any advice performance wise?

Thanks,
Newbie to BO

---

sofia (BOB member since 2009-01-09)

[system]

Search it in this forum

---

peacock (BOB member since 2002-11-07)

[system]

You need to set it up in the universe first:

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…

---

Namlemez (BOB member since 2005-03-14)