
Crystal won't display currency field values.....
Environment
SQL Server 6.50.0255
SQL Driver version 3.60.0310
ODBC Driver version 3.50
Crystal Version 6.0
Crystal fails to display SQL currency field type values on a report.
The report has been generated a single table with numerous fields. All
other field values are displayed, they include varchar, integer, float,
byte.
If you open the "Insert Fields" dialogue box and browse the data, the
various values are displayed except those of "Currency" type.
Below is a simple sample of the problem:
BNMP Actual List Bid Gross Disc SalesID
Disc Order
Cost Price Profit %
$ Status
hit1808 0.00 0.00 0.00 0.00 0.00 0.17 330
0.00 0
hit1810 0.00 0.00 0.00 0.00 0.00 0.22 211
0.00 0
hme0023 0.00 0.00 0.00 0.00 0.00 0.15 154
0.00 0
hme0028 0.00 0.00 0.00 0.00 0.00 0.17 211
0.00 0
jd0057 0.00 0.00 0.00 0.00 0.00 0.17 107
0.00 0
jd0080 0.00 0.00 0.00 0.00 0.00 0.17 319
0.00 0
jd0117 0.00 0.00 0.00 0.00 0.00 0.17 211
0.00 0
tad128 0.00 0.00 0.00 0.00 0.00 0.18 154
0.00 0
Actual Cost, List, Bid Price, Gross Profit and Disc $ (Discount) are all
currency values.
All these records have currency values.
HAs anyone any suggestion please?