How do I prevent the automatic rounding of numbers in the Stimulsoft report?-CodePudding

I'm using the last version of Stimulsoft and C#. I have a report that gets data from SQL Server database and shows it.

My problem is that it rounds up without me adjusting it, like this :

123,456,789 => 123,456,792

My column in SQL Server:

enter image description here

in Stimulsoft:

enter image description here

What have I tried:

{IIF(Floor(MyTable.Price)==MyTable.Price,Floor(MyTable.Price),MyTable.Price)}

None of them worked ...

Please help

CodePudding user response：

Inside Stimulsoft change type of Price column from float to decimal type. then if you want set format use this format type: #,#0.#,#,#,#,#