Page 1 of 1

NaN when number comes null

Posted: Fri Nov 22, 2019 12:39 pm
by csrt
Hello. I am using Stimulsoft.Reports.JS Version: 2019.4.1, and having the next problem:
when instead of a number comes null - the Report viewer displays NaN.

I have to mention that before I was using Version: 2019.1.1, Build date: 2018.12.17 - and there was no such problem. Even now, in the same report, when switching between versions - the newer version displays NaN, and the older - doesn't.

Re: NaN when number comes null

Posted: Mon Nov 25, 2019 5:01 pm
by csrt
Hello. I've upgraded to version 2019.4.2 - and the problem still persists. Could you suggest a solution, so I can apply it locally on my scripts? Or is there a more general way to avoid such behavior? Thank you

Re: NaN when number comes null

Posted: Thu Nov 28, 2019 11:24 am
by csrt
Hello. Could you suggest any ideas regarding the described problem? Thank you in advance.

Re: NaN when number comes null

Posted: Thu Nov 28, 2019 10:43 pm
by Lech Kulikowski
Hello,

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

Thank you.

Re: NaN when number comes null

Posted: Tue Dec 03, 2019 1:21 pm
by csrt
Hello, I'm attaching a report from demo. Please check out the field "Ship Via" - I modified it, so it would be type "decimal". If it has a number value - all works just fine. But if it has "null" value - the report displays NaN. In this same situation, older version of the library(Version: 2019.1.1), in this same situation, just did not displayed nothing. Any ideas how to fix it?

Re: NaN when number comes null

Posted: Tue Dec 03, 2019 1:31 pm
by csrt
I've attached another report that displays the same problem

Re: NaN when number comes null

Posted: Sun Dec 08, 2019 9:55 pm
by Lech Kulikowski
Hello,

Thank you for the sample.
We need some additional time to investigate the issue, we will let you know about the result.

Thank you.
#1363

Re: NaN when number comes null

Posted: Tue Dec 10, 2019 9:19 pm
by Lech Kulikowski
Hello,

The issue is fixed. The fix will be available in the next release build within several days.

Thank you.

Re: NaN when number comes null

Posted: Fri Oct 09, 2020 4:25 pm
by alex.coles
Alternatively use:

Code: Select all

{IIF(int.Parse(source.param), source.param, "-")}

Re: NaN when number comes null

Posted: Mon Oct 12, 2020 6:03 am
by Andrew
Hello,

Thank you for sharing your workaround.
Have a nice day!