Creating total counts 1

[RenaG]

I am using Crystal 10.

My report looks something like this:
GH1: PatID PatName PatRace PatEth PatZip
GH2: ApptDt
D: AssessmentDesc AssessmentResult
An example of the detail:
Communication Type Face to Face
Communication With Patient & Other

I need to generate a list at the end of the report of totals of the AssessmentResults within the AssessmentDesc. For example:
Communication Type
Face to Face 10
Email 15
Phone 5

Does that make sense? How do I go about this?

TIA!!!
~RLG

 

[lbass]

Try inserting a crosstab in the report footer that uses assessment description and assessment results as the row fields, with count of patientID as the summary field. This should work if you have only one row of data per patient contact date.

-LB

 

[RenaG]

As usual, LBass you came through again!! Thank you for pointing me toward using a cross tab and for the steps in setting it up. It works perfectly. I showed it to my boss and once she saw the numbers, what do you think the first thing she said she wanted? Percentages!! I have been playing around with it and have a very nice report now. Thank you again!!!

Warmly,
~RLG