Solved

Grand Total Based On A Field

Posted on 2011-03-03
2
913 Views
Last Modified: 2012-05-11
I need to display a grand total both full total and a total based on the value of another displayed field.  For example, I have a report that looks something like this:
Salesman	Sales Amt	Phone Sales?
Joe Bleaux  123,456.00	    N
Jane Doe     54,756.24      Y
Fred Mertz   91,876.00      N

Sales Total 260,088.24
Phone Sales  54,756.24

Open in new window


How do I do this (and hopefully be able to display the total on the report header)

TIA
0
Comment
Question by:Clif
2 Comments
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 500 total points
ID: 35027595
For the Grand Total, simply right-click the Sales Amt field and choose Insert Summary.  Place the Summary in the Report Header or Foot

For the Phone Sales Total, create a formula that evaluates the Phone Sales Value:

If
  {table.phonesales} = 'Y'
Then
  {table.salesamt}
Else
  0

Add this field to the detail section of the report and then right-click it to Insert Summary and place summary in either the Report Header or Footer..  Remove from report once you've created the summary.

~Kurt
0
 
LVL 10

Author Closing Comment

by:Clif
ID: 35027878
That did it.

Thanks.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Query Builder on BOXIR2 7 54
Crystal Reports Formula Field 17 64
Crystal Reports 11 Ignoring Parameters 3 68
Parameter transfer to cristal report 3 69
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now