Adding huge numbers as general text shows as numbers
-
- Posts: 25
- Joined: Fri Nov 10, 2017 9:48 pm
Adding huge numbers as general text shows as numbers
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
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
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
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
-
- Posts: 25
- Joined: Fri Nov 10, 2017 9:48 pm
Re: Adding huge numbers as general text shows as numbers
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
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.
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.
-
- Posts: 18
- Joined: Fri Jan 27, 2017 4:43 am
Re: Adding huge numbers as general text shows as numbers
i wrap big number by quotes in json but report show as Exponential format in version 2018.1.8.
- Attachments
-
- InputLatter.json
- (230 Bytes) Downloaded 160 times
-
- InputLatter.mrt
- (22.68 KiB) Downloaded 168 times
-
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Re: Adding huge numbers as general text shows as numbers
Hello,
We couldn't reproduce the issue. Please try to check the last release build.
Thank you.
We couldn't reproduce the issue. Please try to check the last release build.
Thank you.
- Attachments
-
- Capture.PNG (41.51 KiB) Viewed 3619 times
-
- Posts: 25
- Joined: Fri Nov 10, 2017 9:48 pm
Re: Adding huge numbers as general text shows as numbers
Tried with latest 2018.2.3
this number
0112201701179128754100120010110051994582523037018
I want it as plain text
same thing happens with the barcode
this number
0112201701179128754100120010110051994582523037018
I want it as plain text
same thing happens with the barcode
-
- Posts: 25
- Joined: Fri Nov 10, 2017 9:48 pm
Re: Adding huge numbers as general text shows as numbers
what column? this isnt a column its just a plain ol textbox
-
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Re: Adding huge numbers as general text shows as numbers
Hello,
Please send us a sample report with test data which reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data which reproduces the issue for analysis.
Thank you.
-
- Posts: 25
- Joined: Fri Nov 10, 2017 9:48 pm
Re: Adding huge numbers as general text shows as numbers
I have attached the sample data and the report
- Attachments
-
- Huge Numbers problem.rar
- (169.11 KiB) Downloaded 166 times