Page 1 of 2
Adding huge numbers as general text shows as numbers
Posted: Fri Dec 29, 2017 10:38 pm
by 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
Re: Adding huge numbers as general text shows as numbers
Posted: Sun Dec 31, 2017 9:52 am
by Edward
Hi Angelcalvasp,
Please try to add that big number using quotes "0112201701179128754100120010110051994582523037018"
Please check the attached report.
What is the version of Stimulsoft Reports.Web you are using?
Merry Christmas & Happy New Year!
Thank you,
Edward
Re: Adding huge numbers as general text shows as numbers
Posted: Tue Jan 02, 2018 5:04 am
by 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
Re: Adding huge numbers as general text shows as numbers
Posted: Wed Jan 03, 2018 1:05 pm
by 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.
Re: Adding huge numbers as general text shows as numbers
Posted: Wed Jul 04, 2018 2:15 am
by alireza_s_84
i wrap big number by quotes in json but report show as Exponential format in version 2018.1.8.
Re: Adding huge numbers as general text shows as numbers
Posted: Tue Jul 10, 2018 6:32 am
by Lech Kulikowski
Hello,
We couldn't reproduce the issue. Please try to check the last release build.
Thank you.
Re: Adding huge numbers as general text shows as numbers
Posted: Thu Aug 02, 2018 9:15 pm
by angelcalvasp
Tried with latest 2018.2.3
this number
0112201701179128754100120010110051994582523037018
I want it as plain text
- Error.png (16.23 KiB) Viewed 4648 times
same thing happens with the barcode
Re: Adding huge numbers as general text shows as numbers
Posted: Thu Aug 02, 2018 9:23 pm
by angelcalvasp
HighAley wrote: ↑Wed Jan 03, 2018 1:05 pm
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
Re: Adding huge numbers as general text shows as numbers
Posted: Sun Aug 05, 2018 10:02 am
by Lech Kulikowski
Hello,
Please send us a sample report with test data which reproduces the issue for analysis.
Thank you.
Re: Adding huge numbers as general text shows as numbers
Posted: Fri Aug 17, 2018 9:08 pm
by angelcalvasp
I have attached the sample data and the report