CR6 x SQL Server - datatype "decimal" 
Author Message
 CR6 x SQL Server - datatype "decimal"

When I use datatype decimal on SQL Server (2000) the crystal dont show the
number correctly.
Sample:

In SQL the value is 1,25
In Crystal the value is 1,00

Im using an ODBC connection (and I need use it). When I use connectiion
with SQL Server direct everthing is right.

When I use datatype Real the crystal show 1,25.

What the problem?



Tue, 19 Aug 2003 23:21:43 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. CreateObject("Excel","//server"), MsgBox output

2. CreateObject("Excel","//server"), MsgBox output

3. Capturing SQL Server "Raiserror" in VB

4. "Required" property and SQL Server

5. "Development" version of MS SQL Server

6. CR6 "OUTER" join

7. "Cannot open SQL Server"

8. SQL - SERVER "ROWNUM" - Urgent pls

9. Bizarre ADO/SQL Server "Feature"

10. "Time out expired" by SQL Server

11. VB/SQL Server - "Failed Update"

12. "Changing Currency/Number Datatype format"

 

 
Powered by phpBB® Forum Software