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

[Austin]

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!

[Dimitar]

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