When I import numbers from a file into crystal 7, a field with four decimal places does not transfer properly (ex. the number .4562 displays in crystal as .4500). <br><br>Has anyone else experienced this problem?
We had a problem with the query part of CR7. It was not pulling the 'float' data types correctly. We had to reduce the version of some these .dll files:<br><br> sqlsrv32.dll 2.65.0240<br> p2lodbc.dll 7.0.100.1<br> p2sodbc.dll 7.0.100.28<br> odbc32 &<br> odbc32int 3.510.3002.13<br>The problem has been fixed in CR8.<br>
I am selecting numeric data from a database column. Unfortunately, the data contained in the column has multiple leading zeros. The true source of this problem I believe is the fact that this is a CHAR column in the database and not a numeric.<br>Is there any way to fool Crystal into believing this is a DECIMAL column and remove the leading Zeros from the report?<br><br>PS Using Crystal 7<br>
Create a formula field and use 'ToNumber (x)' where (x) is your text field. The formula field will be numeric. To make sure all your text field holds a numeric use 'NumericText (str)'.<br><br>Example:<br> if NumericText (x) then<br> ToNumber(x)<br> else<br> 0<br>I got this information from the CR Online Help Files. <br> <p>LindaC<br><a href=mailto:lcastner@co.orange.ny.us>lcastner@co.orange.ny.us</a><br><a href= > </a><br>
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.