Handling Nulls 3

[ganjass]

CR 10

Hi all, i'm looking to have a record slection criteria that selects records where stage to <> Stage from, problem is the stage from can be null, how would i change the crystal syntax to substitue a string for a null, like the nvl() function in SQL.

Thanks in advance

 

[kandikcj]

You could use:
file
report options
convert database null values
or
If isnull(Field) then 0
else (field)

 

[lyanch]

Just create a SQL expression (with the nvl()) and use that in your selection statement.

//%StageFrom

nlv(table.StageFrom,"") // or whatever the currect SQL syntax is

//Selection formula

{table.StageTo} <> {%StageFrom}

Lisa

 

[ganjass]

like your style