Solved

Crystal Summarizing Max

Posted on 2009-07-14
5
1,116 Views
Last Modified: 2013-11-15
I have a report that I want to display the sum of field {priceinfo.tsc}; however, it also displays field {mbillcode.total} which could have many results for just the first one.  I made priceinfo.tsc into a max summary so that it would only display the result once.  I know that you can't summarize a summary so I can't come up with a solution.  If I put the same max summary in the report footer, it just shows 1 result.  Can anyone help?
0
Comment
Question by:fleets9876
[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
  • 2
5 Comments
 

Author Comment

by:fleets9876
ID: 24854874
Max points
0
 
LVL 5

Expert Comment

by:jgbreeden
ID: 24855420
You can use a sum on the original field, you just need to figure out what to put in the "Evaluate When" so that it only evaluates once per parent record.   if priceinfo has an ID field you could use priceinfo.ID <> previous(priceinfo.ID), or if mbilltotal has a sequence it could be mbilltotal.sequence=1.
0
 
LVL 35

Accepted Solution

by:
James0628 earned 500 total points
ID: 24856659
I assume that you have a group on the report and when you said "I made priceinfo.tsc into a max summary so that it would only display the result once", you meant that you were doing a maximum of that field for that group.

 I am also assuming that priceinfo.tsc is a numeric field.

 You can get a total using a running total.  Put {priceinfo.tsc} in the detail section, if it's not already there (you can delete it later).  Right-click that field and select Insert > "Running total".  Change the running total name if you like.  The "Type of summary" would be Sum.  Under Evaluate, select the "On change of group" option and select the appropriate group from the dropdown list.  Then the field will only be added once for each group.  If this is a grand total, under Reset, select Never.  When you click OK, a running total field will be put on the report.  Move it to the report footer if it's not already there.  That should give you your grand total.

 If you added {priceinfo.tsc} to the detail section at the start of this, you can delete it now.  I just had you put it there to make it easier to create the running total.

 James
0
 

Author Closing Comment

by:fleets9876
ID: 31603440
This worked perfectly!
0
 
LVL 35

Expert Comment

by:James0628
ID: 24865714
Glad I could help.

 James
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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 …
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

688 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