Crystal Reports: how to set up a dummy parameter for null value?

[former_member548403]

Hi.

I need to set up a dummy parameter and use it as null value selection. I created a formula such as:

if {parater} = "No name" then {dataset} = {parameter}

else {dataset} = {parameter}

This doesn't give me any error, but I am not sure if this is correct. And if it's correct, how to do proceed from here?...

[DellSC]

I do it this way - WITHOUT the If statement....

({?parameter} = "No Name" or {MyTable.Field} = {?parameter})

In general, If statements in the Select Expert will slow down the data processing because they generally cannot be passed to the database for processing. Best practice is to avoid using them there and instead use parentheses, and & or to build expressions that evaluate to true to select the data that you need.

-Dell