sharronWilliams
asked on
Crystal Reports Count of Y and N in one field
I am very new to CR, I have been using Access. If I were doing this in access I would create a query with the same field one I would ask for all the "Y" and the other all the 'N" then I would create another field to perform my calculation. I am sure it is easy to do in Crystal Report, but I am stumped. I am pulling from a sql dw. This is all new to me, I am ready to just pull it all into an access database and forget it. Crystal Reports is very powerful and my new work loves the reports it can create. So I want to do it the correct way
ASKER
No they are one field from a SQL statement with differnt values y or n in the same filed. The field is flagging that a patient has met the requirements. Either a y for yes, or n for no. I tried to create a new field with a formula as I would in ACCESS. It would not work, it either pull all y or n, not both. I want the total. To top it all off. The programmer, decided to change the name of the field, so my report would not pull correctly. I keep trying to do it. The name change of the field was a huge set back. The data had to be remapped. So I am still at a stand still.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, this worked so well. It has made my day. Today I was able to finish 3 reports. That I have been stuck on for a week. You were right on!!!1
Are you able to modify the report source so that you can do the count on the query and just display it as a new field?