Crystal Reports Total not showing up for one date only

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Total not showing up for one date only

<< Prev Page of 2

Author	Message
DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 26 Aug 2011 at 11:25am
	I think there is time values being included. Can you double check your raw data at the source to make sure there isn't any time values messing it up.
	IP Logged


Kitty1 Senior Member Joined: 14 Apr 2010 Online Status: Offline Posts: 159	Posted: 30 Aug 2011 at 9:57am
	Hi there, there are date values in another field, but I'm not using that field to select at all.
	IP Logged

Kitty1 Senior Member Joined: 14 Apr 2010 Online Status: Offline Posts: 159	Posted: 31 Aug 2011 at 6:00am
	Hi, Just wanted to let you know I came up with a new formula which corrected the problem...weird. but it's working now, so I can't complain! Thanks again so much for trying to help me figure this one out!
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 31 Aug 2011 at 10:32am
	if youa re comfortable please post your working formula for others to reference (if they run into the same problem).
	IP Logged

Kitty1 Senior Member Joined: 14 Apr 2010 Online Status: Offline Posts: 159	Posted: 02 Sep 2011 at 4:31am
	good idea...will do. thanks!
	IP Logged

Kitty1 Senior Member Joined: 14 Apr 2010 Online Status: Offline Posts: 159	Posted: 02 Sep 2011 at 4:32am
	this is the formula that worked: {#RTotal0}+{@shared arch}-{@shared arch deletes}+{@shared govt}-{@shared govt deletes}+{@shared indus}-{@shared indus deletes}+{@shared other}-{@shared other deletes}
	IP Logged

<< Prev Page of 2

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