Is there a way for Crystal Reports to understand "Nz" from Access? 1

[glthornton]

Hi,

Does anyone know why Crystal Reports (version 10 or 11) cannot understand the "Nz" function within MS Access? Does Crystal have any alternative to this function?

Thank you,

GlThornton

 

[Turkbear]

Hi,
What does "Nz"do in Access?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[vidru]

Turk:
I think the Nz function in Access is like the COALESCE or ISNULL function in SQL Server. It's a quick way to say "If this field is NULL, I want it to be this value, otherwise, just give me the original value).

glthornton:
I'm not aware of an intrinsic Crystal function that works quite the same. You'd need to write out the entire If statement like this:

If IsNull({Table.Field}) then
'Default'
Else
{Table.Field};

If you happen to be using an ODBC connection to Access, you can use SQL Expressions, in which you can use database specific functions.

-dave

 

[glthornton]

Vidru,
Thank you for your response. I thought that's what to the answer would be. I will be attending some advanced CR training given by Business Objects in a few weeks. While I am there, I will find out what the instructor has to say as well.

Merry Christmas!

Thank you,

GlThornton

 

[synapsevampire]

It's akin to an IIF with an Isnull, which Crystal does support.

iif(isnull({table.field}),"null","not null")

-k