Text format 'number' not working in Stimulsoft reports

shilpa · Post by **shilpa** » Tue Aug 23, 2011 2:55 am

Hi,

In my report I have a column where the numbers are in decimals.

But, in stimulsoft report, when I select "text format" as "Number" and give decimal digits to 2 ,the numbers are rounded off & after the rounded off number .00 is appended.

For eg : 317.70 in database is seen as 318.00

Kindly suggest some solution for this.

Than you.

Post by **Ivan** » Wed Aug 24, 2011 12:39 am

Hello,

Can you please send us a sample report template with data or a simple test project, which reproduces the issue?

Thank you.

shilpa · Post by **shilpa** » Tue Aug 30, 2011 2:38 am

Hi,

Sorry for the late reply.

I am sending you the mrt file for the report that I am using.In that chk the column data naming "{QAAccuracySummary.Deficit}" .In that suppose if the data in that column is 317.75 , the data it is displaying is 318 .If I am using the number format of stimulsoft to take 2 decimal places , it is showing the data as 318.00 and not 317.75.

Waiting for your reply.

Thank you,

Post by **Alex K.** » Wed Aug 31, 2011 1:44 am

Hello,

You have described in the dictionary the field QAAccuracySummary.Deficit as the long type, so the value of the field is rounded. Specify the type as decimal or double.

Thank you.

shilpa · Post by **shilpa** » Wed Aug 31, 2011 6:10 am

Hi,

I updated the type of QAAccuracySummary.Deficit to decimal.Now, I can see the values in decimals without rounding off.

Thanks a ton. :biggrin:

Cheers !!

Post by **Alex K.** » Thu Sep 01, 2011 7:32 am

Hello,

We are always glad to help you!
Let us know if you need any additional help.

Thank you.

hrl60 · Post by **hrl60** » Sun Oct 04, 2015 6:07 am

I have same problem and my field type is decimal.... please help me

Post by **Alex K.** » Mon Oct 05, 2015 5:39 am

Hello,

Can you please send us a sample report template with data or a simple test project, which reproduces the issue?

Thank you.