store procedure return multiple data sets how to access all data sets in telerik report designer

[zubair]

see my question also on stack overflow http://stackoverflow.com/questions/42758013/store-procedure-return-multiple-data-sets-how-to-access-all-data-sets-in-telerik

when i add SQL data source and add store procedure in it, Actually store procedure return multiple tables but in telerik report designer just got single table or single table parameters if anyone can't understand my question than visit above link

 

SQL store procedure result https://i.stack.imgur.com/ZL1hz.png

in telerik report designer https://i.stack.imgur.com/uoonR.png

 

 

[Stef]

Hi zubair,

The SqlDataSource component uses the .NET data provider, the associated ADO.NET classes and the connection string to create a connection and to execute the SQL command. The result is loaded in a DataSet from which you can use the first result set.

If you want to use all results sets, you can load the data in a custom business object  (Entity Framework or other data access layer) and switch to the Entity/OpenAccess/Object data source components. We recommend the data-binding approaches from How to Databind to Collection Properties and Use DataObject as a datasource for nested data items (Table, List, Crosstab, Graph).

Regards,
Stef
Telerik by Progress