• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 75
  • Last Modified:

Grand Totals on Crystal Reports

Hello,

I'm trying to insert totals on my sub totals (So grand totals) and I can't get it to work.
Can you please help?

Attached is a copy of the file with data.

Thanks you.
SupplierTransactionSummaryByLocation.rpt
0
jspc
Asked:
jspc
  • 4
  • 3
1 Solution
 
James0628Commented:
I looked at the report, but you didn't say exactly what you're trying to summarize, or what problems you're having ("can't get it to work" could mean various things).

 I'll make a guess.  If you're trying to create a grand total of your group totals, then, no, you can't do that.  CR won't do a summary of a summary.  But you can just create a new summary on the original field/formula (eg. @Amount) and make that summary a grand total, instead of a group total.

 James
0
 
mlmccCommented:
There is no need to make a NEW summary.  Just copy the existing one (right click and copy) then paste it into the report footer.  Crystal will update to use it as a grand total.

mlmcc
0
 
James0628Commented:
Good point mlmcc.  I never use that feature (I've actually found it annoying at times, when I just wanted to move a summary to another section, but CR changed it too :-).

 James
0
2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

 
mlmccCommented:
Thanks for sticking with him.  I was going to try to help but I figured 2 voices might be confusing and you seemed to have the problem well in hand

mlmcc
0
 
James0628Commented:
Did you post that in the right place?  I made one post before your first one here.  "sticking with him" seems a bit excessive.  :-)

 James
0
 
mlmccCommented:
I thought this was the other question you have been working for a while.

mlmcc
0
 
James0628Commented:
I thought that was probably it.  It made a lot more sense there.  :-)

 James
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now