Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 408
  • Last Modified:

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

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
ISBTECH
Asked:
ISBTECH
1 Solution
 
mlmccCommented:
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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now