Hi All,
I have just started using Crystal Reports for reporting on my ASP.NET site and have figured out the basics but now I have a problem.
I am trying to create a formula that will give me a count on a field when the field is a 2.
ie. I have the following
Count ({dbt_Patient.pt_Sex},2)
Where {dbt_Patient.pt_Sex} is either equal to 1 or 2.
As far as I can tell this should work.. I have also tried
Count ({dbt_Patient.pt_Sex},{dbt_Patient.pt_Sex},2)
but I am getting the following error message
"The summary / running total field could not be created"
Thanks,
Gavin
I have just started using Crystal Reports for reporting on my ASP.NET site and have figured out the basics but now I have a problem.
I am trying to create a formula that will give me a count on a field when the field is a 2.
ie. I have the following
Count ({dbt_Patient.pt_Sex},2)
Where {dbt_Patient.pt_Sex} is either equal to 1 or 2.
As far as I can tell this should work.. I have also tried
Count ({dbt_Patient.pt_Sex},{dbt_Patient.pt_Sex},2)
but I am getting the following error message
"The summary / running total field could not be created"
Thanks,
Gavin