Print Page | Close Window

add all results (numbers) located in group Headr?

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13705
Printed Date: 02 May 2024 at 3:38pm


Topic: add all results (numbers) located in group Headr?
Posted By: Marko0916
Subject: add all results (numbers) located in group Headr?
Date Posted: 11 Jul 2011 at 6:28am
I have a formula that i placed in the group header that gives me a total (number).  The formula is called "distinct_count"
 
I am trying to place the sum of all those totals in the group footer but i get an error saying that this field cann't be sum'd.
 
ex.
 
Group Header displays
 
Ursinfo.Lastname            @Distinct_count total number
 
Smith      220
Jones      234
 
So i would like to be able to add the 220 + 234 and place that total in the Group Footer.
 
 
I've been stuck on this one for a while.  Any help greatly appreciated.
 


-------------
Crystal Keeps me up Late


Replies:
Posted By: DBlank
Date Posted: 11 Jul 2011 at 7:55am

what is the DC formula doing?

likely rather than adding up 220 and 234 you can just add a new formula or Running Total to count the records again in teh way you want for a new total

Posted By: Marko0916
Date Posted: 11 Jul 2011 at 8:32am
I know i didn't word that question clearly, my apologies.
 
distinct_count =  Count ({USRINFO.LOGINNAME}, mailto:%7b@provider - {@provider name})
generates a number result in the group header field.  But i have lets say 6 rows (gh3 results) on page one, 8 on page 2. 
 
What is the formula for adding up the results of a formula field if it is a number?  I'm getting errors that this field cann't be sum'd for some reason.
 
I am a newbie to CR, sorry. 
 
 
 
 


-------------
Crystal Keeps me up Late

Posted By: DBlank
Date Posted: 11 Jul 2011 at 11:11am
Count ({USRINFO.LOGINNAME}, mailto:%7b@provider - {@provider name}) is a summary at the group level. FYI - This types of Summaries DO work in headers where as Running Totals or variable formulas do not.
Summarized fields (like a group count/summary) cannot be summarized again.
All you have to do is make a nother formula that summarizes without the grouping which is the same as adding your groups together...
Count ({USRINFO.LOGINNAME})
 


Print Page | Close Window