Creating Total Counts

[RenaG]

Hi,

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:

    Assessment             Result
    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? Any suggestions on how I can do this?

TIA!!!
~RLG

[RenaG]

I got it working!

I inserted a crosstab in the report footer that uses AssessmentDesc and AssessmentResult as the row fields, with count of patID as the summary field. Then I added another count of patID and selected the "show as percentage of" option. Then I played around with the Styles and have a very nice looking report now.

~RLG