regarding dynamic parameter

[americvish]

Hi,
I have dynamic parameter in the report and i have the requirement to get all values in the drop down list to get all the values selected.
I have tried but not able to get it.

So wanted to know
Is it possible to get all option in the dynamic parameter list? and
is it possible to pass custom values to the parameter?
and finally
can we assign default values in the dynamic parameter?

thanks in advance.

 

[lbass]

You could create a command like the following (using the Xtreme database):

Select Orders.`Ship Via`
from Orders
Union
Select 'All'
from Orders
Union
Select 'Default'
from Orders

You would not link the command to the table used in the report (Orders), and then you would create a record selection formula like this:

(
if not({?My Parameter} in ['All','Default']) then
{Orders.Ship Via} = {?My Parameter} else
if {?My Parameter} = 'Default' then
{Orders.Ship Via} = 'UPS' else //'UPS' is the default value here
if {?My Parameter} = 'All' then
true
)

-LB