We have started exploring Telerik report. at present we are using SSRS. in Telerik report we notice when using progress Telerik report designer i.e teleri standalone report designer app when we pass stored procedure as data source and that stored procedure returning more then one data set only Top 1 data set result will be visible in Telerik report designing app.

I am attaching screen short below :

1. from SP 

2. from Telerik Report Design app 

   1. 

   As can be seen from both above screen short Telerik Report design app shows only one dataset under Datasource1 whereas SP send two dataset.

   How can i get both dataset in Telerik report design ??  

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!