Page 2 of 2

Re: Adding huge numbers as general text shows as numbers

Posted: Mon Aug 20, 2018 7:01 pm
by angelcalvasp
Sorry previous json data was wrong here is the files for assessment

Re: Adding huge numbers as general text shows as numbers

Posted: Mon Aug 20, 2018 8:36 pm
by angelcalvasp
If anybody reads this, until I get a response here, a workaround was to use Mid
{Mid(root.documento_numero_autorizacion,1,49)}

and had to add a non numeric character at the beginning of the string value from the json

worked for both the normal text and the barcode

Re: Adding huge numbers as general text shows as numbers

Posted: Tue Aug 21, 2018 2:54 pm
by HighAley
Hello.

Thank you for sharing the solution to the problem.

Re: Adding huge numbers as general text shows as numbers

Posted: Tue Aug 21, 2018 2:58 pm
by angelcalvasp
Still needs to be checked tho shouldnt need to do workarounds :D

Re: Adding huge numbers as general text shows as numbers

Posted: Mon Aug 27, 2018 8:58 am
by Lech Kulikowski
Hello,

We have added some improvements in the data parser. Will be available in the next release.

Thank you.

Re: Adding huge numbers as general text shows as numbers

Posted: Thu Jun 11, 2020 2:25 pm
by speter@techgroup.ch
Hello,

If anyone reads this, we just had the same problem with version Stimulsoft.Reports.Engine 2020.2.2 and Stimulsoft.Reports.Engine.NetCore 2020.2.3.

We used a similar workaround as described by the opener. The problem lies actually within the Library in the class StiJsonToDataSetConverter.cs which is from your NuGet package.

There is a function "private static Type ParseString(string str)" which tries to evaluate the column-type from the value. So if you have "914829300005910214860" as a value, it will be converted into a "double" type which ends up as "9.148293000059102E+20" in the report.

So the problem is not in the .mrt file, it is in the NuGet library in our case. In my opinion, the column-type should not be evaluated from the value, but from the data type of the property.

Re: Adding huge numbers as general text shows as numbers

Posted: Mon Jun 15, 2020 6:39 am
by Lech Kulikowski
Hello,

Please try to use StiJsonToDataSetConverterV2

Thank you.