Crystal Reports Displaying Null records

Report Design
Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design

Topic: Displaying Null records

Author	Message
crystalgal Groupie Joined: 20 Feb 2009 Location: United States Online Status: Offline Posts: 66	Topic: Displaying Null records 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.
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 02 Feb 2011 at 3:26am
	if isnull({table.field}) then 0 else {table.field}
	IP Logged

crystalgal Groupie Joined: 20 Feb 2009 Location: United States Online Status: Offline Posts: 66	Posted: 02 Feb 2011 at 3:47am
	Thanks. Helped me in right direction.
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.016 seconds.