Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Running total in report header Post Reply Post New Topic
Author Message
louisville2k10
Groupie
Groupie
Avatar

Joined: 13 Sep 2010
Location: United States
Online Status: Offline
Posts: 45
Quote louisville2k10 Replybullet Topic: Running total in report header
     Posted: 08 Feb 2011 at 3:58am
Hi, I have a running total field, and I would like to show the final running total (or total) in the report header. Can someone please help me figure this out?
 
Thank you!
Thanks for your help!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 08 Feb 2011 at 4:43am
RTs do not function in headers. Only Summaries that can be created using the insert summary function (sigma button) can reside in a header.
you would have to use a subreport in the header to dispaly the RT.


Edited by DBlank - 08 Feb 2011 at 6:16am
IP IP Logged
louisville2k10
Groupie
Groupie
Avatar

Joined: 13 Sep 2010
Location: United States
Online Status: Offline
Posts: 45
Quote louisville2k10 Replybullet Posted: 08 Feb 2011 at 5:46am

DBlank, how do I summarize the first occurrence of a group of repeated fields that change with a new username? For instance, I want to show the Item total of 300 for this report and the Price total of $130.00.

 
For example, I have:
Name                    Items                                     Price              
Bill                       100                               $45.00
                          100
                          100
                          100
Cliff                     200                               $85.00
                          200          
                          200
                          200
 
But I want...
Name                  Items          Total Items           Price   Total Price             
Bill                       100             300               $45.00      $130
                          100
                          100
                          100
Cliff                     200             300               $85.00      $130
                          200          
                          200
                          200
 
 
Thanks for your help!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 08 Feb 2011 at 6:13am

Are you showing all of the detail records in your sample or are there more that are suppressed?

Looks like
Total Items = SUM(items,username)
Price =?
Total Price = ?


Edited by DBlank - 08 Feb 2011 at 6:14am
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.