Include null values in Dynamic parameter selection

[GCL2007]

Using Crystal 11 on Oracle...Have a report where I need to set up dynamic parameter based on a segment within an account number field.
I was going to add the below using Add Command so I could set up a dynamic parameter and add the new command table as a standalone table in my report.
Select SUBSTR(num,10,2) from account
My problem is I will I have a number of records that will not have an account number, but I still want to report them. What would be the best way to accomodate this? Ideally I would like null to appear in the parameter selection along with the other entries from the Command table.
Any thoughts?

Thanks

 

[lbass]

Change your command to:

Select SUBSTR(num,10,2)
from table
union
select 'Null'
from table

Then use a record selection formula like this:

(
(
{?num} = "Null" and
isnull({table.num})
) or
mid({table.num},10,2) = {?num}
)

-LB