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

[Khaled Salman]

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 ?

[Todor]

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