Is there a way to specify a field type in the select statement of the SQL query? The reason I ask is that I have a number with two decimal places in my providex tables but Crystal is rounding the number to 0 decimals places when it imports the data. Can I get it to return the number as a string so that I do not lose the decimal information?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Changing Field Types
- Thread starter will77
- Start date
lisanguyen
Technical User
Hi,
If it is available to you, you can use a SQL Expression to convert your number to text and this will do the conversion server side before the number will get to Crystal.
But have you checked if the number is just formatted to no decimal places? Have you tried changing the rounding and the decimal places displayed?
If it is available to you, you can use a SQL Expression to convert your number to text and this will do the conversion server side before the number will get to Crystal.
But have you checked if the number is just formatted to no decimal places? Have you tried changing the rounding and the decimal places displayed?
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question