Solved

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

Posted on 2012-04-03
1
395 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
[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
1 Comment
 
LVL 101

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

695 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