Large numbers not properly represented
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22990
Printed Date: 02 May 2024 at 12:14am
Topic: Large numbers not properly represented
Posted By: rando1000
Subject: Large numbers not properly represented
Date Posted: 22 Nov 2021 at 8:21am
I have two reports pulling data from SQL Server. The data field in SQL Server is datatype "real". The value is represented as 5.593069E+07 on the server. One report is translating this value to 55930690, which is what it was typed in as on the application that created the record. However, the other report is translating this to 55930688. I've checked the number formatting and the settings of the Details section, and I can't find a difference that accounts for the discrepancy.
Any ideas?
|
Replies:
Posted By: lockwelle
Date Posted: 22 Nov 2021 at 1:02pm
Silly question...
Are they for the same value?
55930688, I can see rounding up to 53593069E+07.
Technically, 55930690 is the best that you can do given the notation displayed...but it seems that SQL might store more digits.
it's an idea...
Hope it helps
|
|