Completed
Last Updated: 04 Oct 2019 10:14 by ADMIN
Raed
Created on: 29 May 2019 13:20
Type: Bug Report
11
JsonDataSource evaluates NULL values incorrectly
The data coming from a JsonDataSource component has null values for a date field. Using the (IsNull, ??, IIf) to check for null does not seem to work. For example: =IIF(Fields.actualWorkHrs Is NULL, "T", "F") always returns false even when there are null values in the actualWorkHrs field.
9 comments
ADMIN
Todor
Posted on: 03 Oct 2019 11:08

Hello all,

The problem has been fixed and should be available in the Internal Build we are targeting to release tomorrow. You would be able to download it from your Telerik accounts - check how to do it in the Latest Internal Builds KB article.

Regards,
Todor
Progress Telerik

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Glenn
Posted on: 26 Sep 2019 12:42
It would seem like this is an easy fix with a minimal impact on your capacity (Of course I don't know).  It is a fairly critical item for us (and I would think anyone that uses REST services in reports).  I support not creating new functionality like "?." syntax, however, I am concerned about the idea of not fixing critical bugs for many months. 
ADMIN
Todor
Posted on: 26 Sep 2019 11:40

Hi,

We are currently investing most of our development resources in the Web Report Designer. For this reason, we may postpone the fix for this issue.

Regards,
Todor
Progress Telerik

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tursunhuja
Posted on: 25 Sep 2019 04:07

@Admin,

I thought that it is fixed in R3. Do you expect to fix it in R4?

Glenn
Posted on: 24 Sep 2019 20:41
I was hoping for a Q3 release also. This is a big problem and the work around is ugly. We are planning to create more reports. Later we will need to come through and refactor those reports.
Casper
Posted on: 19 Sep 2019 14:24
@Admin

Will this be fixed in R4?
I really hoped it would be fixed in R3, but I see that it is not
ADMIN
Silviya
Posted on: 14 Jun 2019 13:40
Hello Glenn,

This is an additional thing that we consider as valid feature request. I opened a new Feature Request item on your behalf. Please check it here: https://feedback.telerik.com/reporting/1413358-check-with-in-the-expression-for-null-values. In future versions of our product we consider for implementation the most demanded features, so if it has more votes, we'll move it up in our implementation list.

And hello Tursunhuja,
Thank you for the input! We will check the Web Service Data Source too.

Best Regards,
Silviya
Progress Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tursunhuja
Posted on: 12 Jun 2019 10:47

That is also a problem in the web data source. I was trying to use "IsNull, ??, IIf" to check for null, but it doesn't work.

Glenn
Posted on: 11 Jun 2019 13:28
I would like to be able to do this syntax: Fields.Address?.State.  If address is null, then it is the same as state being null.  Instead of displaying an error, it would just show blank.