Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: GrandTotal formular in GroupLevel Post Reply Post New Topic
Author Message
anguyen
Newbie
Newbie
Avatar

Joined: 02 Oct 2009
Location: United States
Online Status: Offline
Posts: 2
Quote anguyen Replybullet Topic: GrandTotal formular in GroupLevel
    Posted: 02 Oct 2009 at 12:13pm

Hello,

I am newbie.
 
I am working on a Crystal Report and want to get GrandTotal from the Group Level (BugetNumber)  Not Detail Level  --  
For example:  
        Group 2    BudgetNumber          Cost
                        201010                      10
                                                        20  
                                                        30
 
                         302020                     25
                                                        10 
 
        Sum for Buget Number 201010  = 60
 
                                         302020   = 35
  
 
        GrandTotal  = Sum ( 60 + 35)
        GrandTotal = 95
 
What is the Syntax ? So far I can come up with :
Global NumberVar SubTotal;
SubTotal := Sum ({CallDetail_Rpt;1.Cost}, {CallDetail_Rpt;1.BudgetNumber})
 
Help please
 
Thanks,
Ann
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 02 Oct 2009 at 12:49pm
Group totals: SUM({table.costfield},{table.budgetnumber})
Grand total: SUM({table.costfield})
IP IP Logged
anguyen
Newbie
Newbie
Avatar

Joined: 02 Oct 2009
Location: United States
Online Status: Offline
Posts: 2
Quote anguyen Replybullet Posted: 02 Oct 2009 at 1:23pm

Hello Dbank,

 
A silly question:  Can I get grand total from group total ? 
 
Global NumberVar SubTotal;
Global NumberVar GrandTotal;
SubTotal := Sum ({CallDetail_Rpt;1.Cost}, {CallDetail_Rpt;1.BudgetNumber})
GrandTotal = Sum(SubTotal) 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 02 Oct 2009 at 1:34pm

Not in that way (that I am aware of). The formulas I gave you do not require (nor should should they use) variables. They are just SUM functions.

Variables are not my forte so someone else will correct me if I am wrong here.
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.018 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.