Skip to Content

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

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?...

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 04, 2017 at 11:03 PM

    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

    Add comment
    10|10000 characters needed characters exceeded