Stored procedures that have multiple results sets

[anishravindran]

Team,

Currently is there is way to handle the stored procedures with multiple result sets? By default it gives only the first result set when connected from designer.

Please can you let me know if this can be achieved without dividing the stored procedure into separate procedures.

Thanks

Anish

[Lech Kulikowski]

Hello,

Unfortunately, it is not possible to use stored procedures with multiple result sets directly in the designer.

Thank you.

[Edward]

Hi Anish,

Unfortunately, the stored procedure is transformed to the data source in the report in one to one fashion.

But please consider the following approach:

viewtopic.php?t=5084

Thank you,
Edward