Solved

Insert Summary (Sum) Gives Me a Value Much Higher than the Column Total

Posted on 2011-02-17
4
322 Views
Last Modified: 2012-05-11
I have a report that pulls certain SKUs from my full sales database.  The data presented in my CR view is correct.  However, when I use Insert Summary (Sum) to total the values listed in the column, I get a huge number.  My guess is that it's summing the entire database, not just the SKUs that I show on my report.  

To narrow the SKUs, I'm using a Select Expert - Group.
{ITEMS.ITEM} in ["IZT1-UP-MG", "IZT1-UP-MR"]

How can I tell CR to sum only what is shown on the report?
0
Comment
Question by:cgettel
4 Comments
 
LVL 12

Accepted Solution

by:
JayConverse earned 250 total points
Comment Utility
Put {ITEMS.ITEM} in ["IZT1-UP-MG", "IZT1-UP-MR"] into the Record Selection formula.
0
 
LVL 26

Assisted Solution

by:Kurt Reinhardt
Kurt Reinhardt earned 250 total points
Comment Utility
When you use the Group criteria, it only hides groups that fail to meet the criteria.  The data has still be returned from the database and is present in the report.  Summary fields sum every records, whether they're displayed or not.

So, the real question is "why are you using group selection criteria?"  Is it simply that you used Group instead of Record?  If so, Jay's advice is good - just move the criteria.  If there's a good business reason for using it in the group selection criteria, though, then instead of a summary your best bet is to use a running total field that only increments the sum based on the values you want.

~Kurt
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Summary functions use all the records that the report pulls from the database.  So even though you are suppressing them, you are still using them in the summary.

You could create a formula like
    if  {ITEMS.ITEM} in ["IZT1-UP-MG", "IZT1-UP-MR"]  then
          {NumberField}
    else
          0

You can then use a summary on that

mlmcc
0
 

Author Closing Comment

by:cgettel
Comment Utility
That did it!  Thank you so much.  
Jay's answer fixed the problem.
rhinok's answer helped me understand so I don't make the same mistake again.
So, I split the points.  
Sorry mimcc, I saw the other two answers first.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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 …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

743 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

8 Experts available now in Live!

Get 1:1 Help Now