Print Page | Close Window

Issue with field format

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=433
Printed Date: 29 Apr 2024 at 2:55am


Topic: Issue with field format
Posted By: steve
Subject: Issue with field format
Date Posted: 29 Mar 2007 at 10:30am

The machine I was was running Crystal Reports 9 on crashed, so I installed a new copy of it on another machine.  I then ran the former reports I was before, reports I had backed up.  A problem has arisen with 2 subreports.  It appears the amounts are being rounded down.  Either that, or it is some formatting issue.  For example, amounts like $4.22 and $6.75 that appear in the underlying tables, appear as $4.00 and $6.00, repsectively, on the reports.  There are no formulas used here, just data from tables. 

When I run the undeyling SQL queries, I get the correct amounts.  Crystal Reports is formatting it in an incorrect way, but I do not see how.


Print Page | Close Window