Solved

Crystal 2011 not calculating percent of field the way it did in Crystal11

Posted on 2012-04-03
1
386 Views
Last Modified: 2012-08-13
I have a report that worked fine in Crystal 11, we upgraded to Crystal 2011 and had to change the Select Expert to Groups because records were dropping off if we left the Record Selection.
This report is built with groups that count the number of days a loan is in process, so the groups are configured with the Specified Order equaling a number of days.  We are trying to get a percent of grand total however the Grand Summary total is recalculating at the end or each group so the results are incorrect.
We tried adding a Cross-Tab inserted in the Report Footer and are almost correct, but are getting a rouge record (which happens to be the first loan ever entered in the database and is not listed in the report).
Any help or direction is appreciated.
0
Comment
Question by:ISBTECH
1 Comment
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 37802688
The rogue record is in the report just suppressed by the group selection.

Group selection simply suppresses groups, it doesn't really do a record selection.  You get all the data so summaries get affected since records that don't display are included.

I think you need to troubleshoot the selection formula to determine why some records are not getting selected.

mlmcc
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

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 …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

747 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

11 Experts available now in Live!

Get 1:1 Help Now