-
November 2nd, 2011, 12:09 PM
#1
Creating Total Counts
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:
Code:
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:
Code:
Communication Type
Face to Face 10
Email 15
Phone 5
Does that make sense? Any suggestions on how I can do this?
TIA!!!
~RLG
-
November 2nd, 2011, 03:18 PM
#2
Re: Creating Total Counts
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|