Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: How to print a Count of zero when no records? Post Reply Post New Topic
Author Message
brooksr
Newbie
Newbie


Joined: 08 Jul 2013
Online Status: Offline
Posts: 6
Quote brooksr Replybullet Topic: How to print a Count of zero when no records?
    Posted: 05 Nov 2013 at 2:26am
I have a subreport with a report footer and a field to print the count of records in the subreport.  It works fine if there are 1+ records, but if there are zero records, the field is blank.  I'd like it to show zero. 
 
In the Format Editor for the field, Number tab, I've tried:
 
1. Style = -1,123
 
2. Style = Custom Style, then Suppress if Zero = unchecked, Show Zero Values as = 0.
 
Any help appreciated.
 
Thx,
 
Brooks
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 07 Nov 2013 at 9:03am
you could have a object that has 0 in it, and if the count of records is > 0 to suppress it and show the 'true' count.

Basically have 2 objects and only display 1 at a time based on the count.

HTH
IP IP Logged
brooksr
Newbie
Newbie


Joined: 08 Jul 2013
Online Status: Offline
Posts: 6
Quote brooksr Replybullet Posted: 07 Nov 2013 at 10:04am
Hi lockwelle,
 
Thanks for the post and idea.  I was looking for a solution within the field but this would be a workaround.
 
Brooks
IP 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.031 seconds.