I’ve 3 type of class (Class A,Class B,Class C) for a product. In a report i need to prompt for class
Class A
Class B
Class C
All (how to get ALL in prompt )
how to achive this ?
niranjan_d (BOB member since 2003-11-21)
Here is a Designer FAQ which might help if you have universe design rights.
Nick Daniels 
(BOB member since 2002-08-15)
Use a prompt that asks for variable ‘In List’…
and the user can hold the Ctrl key to multi-select all if required, when they click the ‘values’ button.
cabby (BOB member since 2003-05-13)
I’m still not clear . Can u send me the exact syntax .
Thanks in advance .
niranjan_d (BOB member since 2003-11-21)
My understanding is , you need to customize your list of values,
to display “ALL”. In Designer, Object - properties tab - Edit …
Then customize your prompt, follow Designer FAQ link,
send by Nick Daniels
Shahubar Sadiq 
(BOB member since 2003-02-28)
When building the query, drag the object to the conditions screen.
Then, select ‘In List’ from the options on the left screen, and then ‘Type a new prompt’.
Enter the text of the prompt you wish to display when a user refreshes the report e.g. ‘Which Class?’.
When the user clicks to refresh, they will see the prompt, and if they click the ‘Values…’ button, they can select one or more or all of the options, by using the Ctrl or Shift key when selecting.
I use that a lot, and it is easier than creating new variables and objects in the universe.
But, that link put in has some good advice also.
cabby (BOB member since 2003-05-13)
hi
here is code
@Prompt(‘Please Select Class Or All’,‘A’,[{‘A’,‘B’,‘C’ALL’}],MONO,FREE)) =‘ALL’))
OR Refer the the Book “The Complete Reference” BO chapter 10 page 219
Regards
hassan 
(BOB member since 2003-08-01)
I got it now .Thanks a lot
niranjan_d (BOB member since 2003-11-21)