Is Null Formula issue

building reports crystal reports
1

I am making a new report, some fields I have are:
wpoperation.wpoperation
wpoperation.description
wpoperation.opduration
wpoperation.inspector
wpoperation.completiondate

I want the report to only show these fields if they are “Null” thats all, and if these fields are “null” i want the text “null” there.

what is the proper formula to write to achieve this?

if isnull ({wpoperation.wpoperation}
{wpoperation.description}
{wpoperation.opduration}
{wpoperation.inspector}
{wpoperation.completiondate}
then totext (null)
else (N))

iqman152 (BOB member since 2010-02-23)

2

Can you tell us what product, and version, you are using so I can move this to the correct forum?

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

3

Crystal Reports XI verison: 11.5.0313

iqman152 (BOB member since 2010-02-23)

4

[Moderator Note: Moved to Crystal XI - Jansi]

Jansi :india: (BOB member since 2008-05-12)

5

if isnull ({wpoperation.wpoperation}) and
isnull({wpoperation.description}) and
isnull({wpoperation.opduration}) and
isnull({wpoperation.inspector} ) and
isnull({wpoperation.completiondate})
then ‘’
else ‘N’

Sanjay Kodidine :us: (BOB member since 2008-03-19)