Hi,
Let me start with what I'm trying to do. I'm pulling most of my information from a user information table containing, among other things, the users age group, location and sex. I've got my report grouped first by location and then by age group.
What I'd like to be able to do is calculate the total number of males and females in each age group in each location. Unfortunately this is givinc me quite a bit of trouble. Here is the code that I have right now, just to calculate the number of males:
Dim Male as Number
While {User.GENDER}<>""
If {Mortality.GENDER}="M" Then
Male=Male+1
End If
Wend
Formula = Male
This is throwing me an "A loop was evaluated more than the maximum number of times allowed" error. What am I missing or doing wrong here? I've only been workin with crystal reports for a couple of days here, so I'd really appreciate any tips or pointers.
Thanks in advance,
Sheryll
Let me start with what I'm trying to do. I'm pulling most of my information from a user information table containing, among other things, the users age group, location and sex. I've got my report grouped first by location and then by age group.
What I'd like to be able to do is calculate the total number of males and females in each age group in each location. Unfortunately this is givinc me quite a bit of trouble. Here is the code that I have right now, just to calculate the number of males:
Dim Male as Number
While {User.GENDER}<>""
If {Mortality.GENDER}="M" Then
Male=Male+1
End If
Wend
Formula = Male
This is throwing me an "A loop was evaluated more than the maximum number of times allowed" error. What am I missing or doing wrong here? I've only been workin with crystal reports for a couple of days here, so I'd really appreciate any tips or pointers.
Thanks in advance,
Sheryll