Crystal won't display currency field values..... 
Author Message
 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?



Thu, 04 Jan 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Crystal won't display multiple items selected in parameter field

2. ASP page won't display text from MS Access Memo field

3. Currency Fields Returning Null Values in DBGrid

4. Value of field formatted as Currency?

5. Crystal Report to view currency field

6. Btrieve Currency Field & Crystal 7.0

7. SQL Server and Crystal 6.0 currency field problem

8. Custom control won't display and problems with building dll's

9. IE5.5 + OCX + web page won't display on some PC's

10. Field.value doesn't show value in control

11. doesn't recognize Null value from a field value

12. copying a field's value to another field

 

 
Powered by phpBB® Forum Software