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
Stored procedures that have multiple results sets
-
- Posts: 22
- Joined: Fri Mar 23, 2018 5:53 am
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Stored procedures that have multiple results sets
Hello,
Unfortunately, it is not possible to use stored procedures with multiple result sets directly in the designer.
Thank you.
Unfortunately, it is not possible to use stored procedures with multiple result sets directly in the designer.
Thank you.
Re: Stored procedures that have multiple results sets
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
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