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
jspcAsked:
Who is Participating?
 
James0628Connect With a Mentor Commented:
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
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.