Dynamic parameter in record select expert

[crystaldev1]

Hello,

I'm using CR2008. I created a dynamic parameter and using it in record select expert. I would like to know how I can use this parameter where if noting is selected for this parameter then show everything (=TRUE) in record select expert. Right now, dynamic parameter is requiring a value which I do not want to select. In the record select expert, I have

if {?dynamic_param} = "" then TRUE
else Field1 = {?dynamic_param}

Thanks.

 

[lbass]

Create a command like this:

select field1
from table
union
select 'All'
from table

Then use {command.field1} as the source for the dynamic parameter. In the main report, use a record selection formula like this:

(
(
{?parm} <> "All" and
{table.field1}={?Parm}
) or
{?parm}="All"
)

-LB