Bind one of the result set from stored procedure that returns multiple data sets

1 Answer 31 Views
Report Designer (standalone)
Khaled Salman
Top achievements
Rank 1
Khaled Salman asked on 17 Feb 2022, 11:03 AM

How can I bind one of the result set from stored procedure that returns multiple data sets in telerik report designer?

I need to bind first result set to a table and second result set to a list, how can I do this ?

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 22 Feb 2022, 09:52 AM

Hi Khaled,

Generally, the SqlDataSource can return only a single DataTable.

As a workaround, you may use the approach suggested in the KB article How to Use a Single SQL DataSet in Master-Detail scenario.

The other approach would be to fetch the data with custom code and then use a dedicated ObjectDataSource component that provides the corresponding data set to each of your lists.

Regards,
Todor
Progress Telerik

Brand new Telerik Reporting course in Virtual Classroom - the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products. Check it out at https://learn.telerik.com/.
Tags
Report Designer (standalone)
Asked by
Khaled Salman
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or