Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Values are automatically rounded after 15 posts

Hello,

we are working with a MySQL Database 5.0.18. To access of this database we use a MySQL ODBC 3.51 Driver. In the database is the value 8012115284696055 fromTyp bigint (20) When we paste this field in the report, we get the value 8012115284696060, but we need a not rounded value. What can we do?

Thank you.

Former Member
Former Member replied

Can you convert the number into a string and display it unless you are using it for other calculations?

Here I have found something which might help you a little. taken from another source

"

The fix there was to actually convert the number to a string (VARCHAR) within the database, so the value that CR got was a string, instead of a number. That may or may not be an option for you, depending on your circumstances.

If you simply want to show the value on a report, you could try creating a formula like the following:

+CStr ({table.field} / 100000, "#") ++

CStr (Round ({table.field} - (Truncate ({table.field} / 100000) * 100000)), "00000")

Make the formula name whatever you want. Replace every {table.field} with your field name and put that formula on the report. The formula just tries to split the number into two pieces, convert each piece to a string and concatenate them back together. No guarantees!"

Let me know if the above helps?

Regards

Jehanzeb

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question