Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Problem with sum of counting fields by group Post Reply Post New Topic
Author Message
gerryveltjen
Newbie
Newbie
Avatar

Joined: 07 Dec 2009
Location: Belgium
Online Status: Offline
Posts: 1
Quote gerryveltjen Replybullet Topic: Problem with sum of counting fields by group
    Posted: 07 Dec 2009 at 3:30am
Hello,
 
I have a field gender that has the value 'M' for Male and 'V' for Female.The
report is a list of students grouped by schoolyear. I need to count the amount of male students and female students for every schoolyear.
I made a formula countmale :
 
if {107623_211_OUDLLN_OUDLLN.GESLACHT} = "M" then 1 else 0;
 
and a formula countfemale:
 
if {107623_211_OUDLLN_OUDLLN.GESLACHT} = "V" then 1 else 0;
 
then i summarize the countmale and countfemale fields and put them in the group footer.
 
The amount of male students is showing correct but the amount of female students is always showing 0 for all schoolyears?
 
Thanx in advance
 
Veltjen gerry
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 08 Dec 2009 at 6:25am

since they look the same, I would think that they would work the same.  Since it is a simple count, have you tried shared variables, or just displaying the values on the report and see if they displaying correctly ( I use this method alot for debugging).

 
HTH
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.016 seconds.