Decimal value is automatically rounded off in Stimulsoft Fixed

stimulsoft automatic rounding

stimulsoft automatic rounding

I had a database field Qty which which was showing as integer in Stimulsoft MRT report but the value was actually of type double (decimal value). I played with formatting and added two decimal places to the number by right clicking the field and selecting “Text Format”. That added decimals but now the numbers were showing as 2.00, 5.00 etc. For example, 1.35 would be showing as 1.00 and 3.6 would be showing as 4.00. It turned out that I needed to change the data type in Stimulsoft SQL query.

To fix it, right click on the database field in the right side and select edit. This should popup the dialog above. Notice that the value here was int and hence rounding to x.00. Change this to decimal and the problem should be fixed. It is important that double value here may not work (may not show actually decimal numbers)!

Repro Steps

This problem actually started because the original SQL query was pulling Qty as integer which was later changed to double. After changing the field type, it needed to be updated in Stimulsoft report as well.

Here are some related links that I got some help from

Advertisements
This entry was posted in Tutorials/Tips and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s