Report Design: Displaying Null records

Print Page | Close Window

Displaying Null records

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12202
Printed Date: 18 May 2024 at 2:44pm

Topic: Displaying Null records

Posted By: crystalgal
Subject: Displaying Null records
Date Posted: 01 Feb 2011 at 5:13am

Hello,

Am trying to figure out how to display the records with zero values.

The report contains how many students took the end of the semester survey for each class. SOme class have no evaluations submitted and the report needs to show this.

Any thoughts.

Thanks in advance.

Replies:

Posted By: lockwelle
Date Posted: 02 Feb 2011 at 3:26am

if isnull({table.field}) then

else

{table.field}

Posted By: crystalgal
Date Posted: 02 Feb 2011 at 3:47am

Thanks. Helped me in right direction.

Print Page | Close Window