Print Page | Close Window

rounding problem on overall report summary

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5117
Printed Date: 16 May 2024 at 4:39pm


Topic: rounding problem on overall report summary
Posted By: ck12
Subject: rounding problem on overall report summary
Date Posted: 30 Dec 2008 at 7:02pm
Hi ,
 
Here's my problem.  I have an invoicing report where the overall summary for the whole report is let's say 200.1540 which comes out to 200.15, but when each detail line is broken down into it's respective grouping the group totals add up to 200.1570, which comes out to 200.16.  I need the totals to match but i am not sure how to affect them either way the rounding on both fields are set to 0.01 and i tried to adjust the formula for the overall summary , but CR would not let me sum the group total fields.  the error in formula explorer says "this field can not be summarized."
 
Has anyone seen this before, and is there an appropriate work around?
Thanks in Advance, All help is greatly appreciated.
 
CK


Print Page | Close Window