Solved

Grand Total Based On A Field

Posted on 2011-03-03
2
917 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

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 …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Suggested Courses

734 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