Print Page | Close Window

Formula Help Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Tips and Tricks Forum Discription: Have you learned some great tricks to share with the group? Post them here! URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21097 Printed Date: 28 Apr 2024 at 10:25am Topic: Formula Help Posted By: micahjclark Subject: Formula Help Date Posted: 07 Oct 2014 at 5:23am I am trying to generate a report which will show total count of a field. I currently have the following formula in but it gives me multiple lines counting, i.e. Medical DD 1.00 Medical DD 2.00 Medical DD 3.00 etc if {cdcall.nature} = 'MEDICAL DD' then 1 I want to just have the MEDICAL DD field totaled on one line to show something like MEDICAL DD 2210 if there were 2210 counts in the parameter I am looking at. My report will have multiple items other then MEDICAL DD listed with sums of each. Thanks Replies: Posted By: z9962 Date Posted: 07 Oct 2014 at 11:05pm insert a group on {cdcall.nature} Then you can do a count summary field on {cdcall.nature}.

Print Page | Close Window