How to get parameter to return nulls

[awholtsIT]

crystal 8.5
I have a report design off a sql view.
In Crystal, I'm grouping by a field in the view that has null values.
I've created a parameter on this field with null values.
When I generate the report the null values do not return.
The null values return in my sql query so I know they're there.
There is something I'm not doing correct in Crystal to ensure the null values are return. In that field's parameter, I've tried enerting no lower bound and 'zzzzzzzzzzz' as the uppper bound thinking all values, including null, will be between those enteries. No go.

If I remove the parameter, all the values, including the nulls, are returned. However, the user wants a parameter on this field so they can select subsets of the data.

What am I doing wrong?

Appreciate any suggestions and responses.

Thanks,

Andrew

 

[CR85user]

If you wish to include any nulls as well as the selected subsets then use a formula within the selection criteria as follows

//Selection criteria to include

isnull({table.field}) or {table.field} in {?Parameter}


If this isn't what you atrying to acheive then please post again with more specific information.

'J