Crystal XI - Summarizing on formulas with groupings, part 2

Posted on 2012-08-15
Medium Priority
Last Modified: 2012-08-16
I originally asked for summarizing on formulas which was fixed, but then discovered there were multiple lines for some employees, which then caused the count to be off from the DistinctCount on EE id# versus the count on the summarizing of the formulas.  I then created another grouping for employee last, first and id#, so am not sure how to add the additional grouping to the formulas which are now grouping on Job Codes for an accurate count or is there a way to put a distinct count on EE id# on formulas?
Question by:Grapelady
  • 2
  • 2
LVL 101

Expert Comment

ID: 38297826
LVL 35

Accepted Solution

James0628 earned 2000 total points
ID: 38299490
I'm not sure if this will fix your problem, but you have @CalcQuartileCounts in the detail section and GF4, so your counters are going to be incremented once for each detail record (formulas in a suppressed section are still evaluated) and then again in the group footer.  That seems wrong.

 I think you need to remove the formula from one of those sections.  I'm guessing that you want it in GF4 and not the detail section, but it depends on your data, etc.


Author Comment

ID: 38301881
I have bolded and colorized in purple the count on the left side for employee count and the area with the quartile counts the quartiles should add up to total on the left side.  So the count would be based on the Job Group and the employees under that Job Group and within the Quartile wage range.  At the moment that Quartile count is not matching the employee count.

Author Closing Comment

ID: 38302982
I deleted the CalcQuartileCounts in the detail line and kept the one in the group footer the numbers are now correct.  Thank you.
LVL 35

Expert Comment

ID: 38303650
You're welcome.  Glad I could help.


Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

621 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