Total by items not values
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
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=3546
Printed Date: 02 May 2025 at 12:33am
Topic: Total by items not values
Posted By: brufam
Subject: Total by items not values
Date Posted: 27 Jun 2008 at 6:24am
|
Hi There,
I am trying to get a Crystal report to total the colum of patients names, but I keep getting funky numbers. There must be a simple way to do this. but what is it? As you can tell, I'm fairly new to Crystal.
Thank you for your help,
BRUFAM
|
Replies:
Posted By: saoco77
Date Posted: 27 Jun 2008 at 12:07pm
|
Depending on what you are trying to report out on one of the two formulas should work
count({table.patientname}) distinctcount({table.patientname}) Hope this helps. Sarah |
Posted By: brufam
Date Posted: 27 Jun 2008 at 12:12pm
I hate to ask you this, but where do I put the formulas? I tried using the autosum but I kept getting the weird total . Thank you sooo much 
|
Posted By: BrianBischof
Date Posted: 27 Jun 2008 at 12:52pm
|
In the Field Explorer, right-click on Formula Fields and select New. Give the formula a name and enter the formula that Sarah mentioned. Save it. Then you can drag and drop it anywhere on your report. Another alternative is to right-click on the field you want to summarize and select Insert > Summary and then pick Count as the summary calculation. If you're new to Crystal Reports, you might want to check out my Crystal Reports Encyclopedia book with many tutorials to get you the right start. You can find out more about my books at http://www.amazon.com/exec/obidos/ASIN/0974953601/bischofsystem-20 - Amazon.com or reading the http://members.crystalreportsbook.com - Crystal Reports eBooks online. ------------- Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a> |
Posted By: brufam
Date Posted: 03 Jul 2008 at 9:17am
|
I keep looking at the book when I go to Amazon...I just can't decide whether or not to go hard copy or get it online from here.
Thank both of you for the expertise!
|