Adding huge numbers as general text shows as numbers

[angelcalvasp]

I have a larger number

0112201701179128754100120010110051994582523037018

which shouldn't be treated as a number notice the 0 at the beginning, I am presenting it in a text with text format as general and it is being show as follows
1.12201701200101E+35

Now I should mention if I put 0112201701179128754100120010110051994582523037018 directly as the expression it shows up as a text, but when It is coming from a json object data source it comes as 1.12201701200101E+35, the datasource has the column as string and even if I concat a string or even use to Upper to try to make the report understand that its a string (PANIC BUTTON ({Trim(ToUpperCase(root.documento_numero_autorizacion))+""})), it doesn't work

any help with this issue would be greatly appreciated

[Edward]

Hi Angelcalvasp,

Please try to add that big number using quotes "0112201701179128754100120010110051994582523037018"

Please check the attached report.

NumberInStringColumnProblem.mrt

(7.08 KiB) Downloaded 343 times

What is the version of Stimulsoft Reports.Web you are using?

Merry Christmas & Happy New Year!

Thank you,
Edward

[angelcalvasp]

I am using the latest version 2018.1.4, I'm guessing I wasnt clear about the problem I have no problem if I put the string 0112201701179128754100120010110051994582523037018 it is shown correctly the problem happens when the value isnt directly set but comes from a datasource in this instance a json datasource which is bringing the same value 0112201701179128754100120010110051994582523037018

[HighAley]

Hello.

Please, check the type of this column.
If you want to see it as a string then the column should be a string type.

If you still need our help, please, send us your report template with sample data.

Thank you.

[alireza_s_84]

i wrap big number by quotes in json but report show as Exponential format in version 2018.1.8.

[Lech Kulikowski]

Hello,

We couldn't reproduce the issue. Please try to check the last release build.

Thank you.

[angelcalvasp]

Tried with latest 2018.2.3

this number
0112201701179128754100120010110051994582523037018
I want it as plain text

Error.png (16.23 KiB) Viewed 3541 times

same thing happens with the barcode

[angelcalvasp]

Hello.

Please, check the type of this column.
If you want to see it as a string then the column should be a string type.

If you still need our help, please, send us your report template with sample data.

Thank you.

what column? this isnt a column its just a plain ol textbox

[Lech Kulikowski]

Hello,

Please send us a sample report with test data which reproduces the issue for analysis.

Thank you.

[angelcalvasp]

I have attached the sample data and the report