Default Value for prompts 1

[Raja05]

Im new to BO and trying to generate a prompt where the users can enter values. IF the user wants to select all the data, he can enter "All" which shud do a "select *" but if he selects a specific value, then it retrieves that value alone. I tried to create an object in Designer like this
in the where clause
mytable.myvalue = @Prompt('Enter a Project','A',,multi,free) OR ('All' = @Variable('Enter a Project'))

But it gives me an Parse failed:invalid definition.

Any other way to solve this problem?

TIA
Raj

 

[ShyamRewaskar]

Hi.
mytable.myvalue = @Prompt('Enter a Project','A',<variable>,multi,free) this statement is enough.

This will prompt you with available list of values.

Choose a particular value(s) from the list and it will generate the report accordingly...
Now if you want to see the whole data select all from the list of values..

Further frendliness can get from VBA scripts.

Shyam