ALL option in the LOVs

[system]

Hi Pradeep,

Thanks for the reply, I tried the following also:

120×120 10.4 KB

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…

and I get two different prompts as I already have but the link (FAQ: Designer ) you forwarded me(thanks for that) says to override the sql, but how to override and save the sql, i went through the steps written but it does not save it,
and the second approach was to create a universe object(how can we associate it with sys.dual table and how to locate this table?),
thirdly do we need to follow both the approaches or either of them will let me get the all or one option in a single prompt?

Could you please help on this.

Thanks,
singh

---

singh (BOB member since 2005-09-26)