Telerik Report Builder Question - Unable to view null/blank values

1 Answer 230 Views
Report Designer Report Viewer Web Report Designer
Austin
Top achievements
Rank 2
Iron
Iron
Iron
Austin asked on 14 Dec 2022, 04:55 PM

Good Morning Telerik Community,

 

How can I show blank data in a table using the Telerik Report Builder?

 

The current code I am using is not displaying blank(empty) cells. and, when I coalesce nothing appears as well. When I run my query on the server(oracle server) I get back all my table values I am requesting even if the value is blank. However, running it out of Telerik it seems if its blank in one table value but has data in another on the same row it just skips the entire row even with the ones with data instead of just displaying blank, null or nothing.

 

in example, I have 5 tables I am querying. 

 

Accession | Patient Name | DOB | Exam Name | Radiologist (How it should display)

000001231 | Doe, Jane | 01/01/1800 | Bilateral Mammo W/Wo Contrast | Dr. Sheldon Cooper

000001236 | Doe, John | 10/06/1929| Bilateral Hip With Contrast | 

000001234 | Doe, Jamie | 07/14/1915 | Chest Angio W Contrast | Dr. Sheldon Cooper

Total Rows: (3)

 

Accession | Patient Name | DOB | Exam Name | Radiologist (How it currently displays incorrectly)

000001231 | Doe, Jane | 01/01/1800 | Bilateral Mammo W/Wo Contrast | Dr. Sheldon Cooper

000001234 | Doe, Jamie | 07/14/1915 | Chest Angio W Contrast | Dr. Sheldon Cooper

Total Rows: (2)

 

 

Is there something within Telerik report builder I am doing incorrectly or, I do not understand?

 

Any help would be appreciated!

1 Answer, 1 is accepted

Sort by
0
Dimitar
Telerik team
answered on 19 Dec 2022, 09:53 AM

Hello Austin,

By default, the table will display an empty cell when a value is missing for a given column, I have attached a sample report to demonstrate that.

Do you perhaps apply any bindings on the Visible property of those cells or do you use conditional formatting on them where the visibility is hidden conditionally?

In any case, you can try to return an empty string when the value is null by doing a null check on the Value property of the textbox in the table that displays this dynamic data, for example:

= Fields.Radiologist Is Null ? "Default Value" : Fields.Radiologist 

I hope this will help, in case you would need further assistance, please send me the problematic report and sample data so that I can test it locally.

Regards,
Dimitar
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
Report Designer Report Viewer Web Report Designer
Asked by
Austin
Top achievements
Rank 2
Iron
Iron
Iron
Answers by
Dimitar
Telerik team
Share this question
or