
Hello,
One of my customer needs all the results of report on a same page.
In my report, I am using table with grouping, that gives me records one after another as shown in below image
I have like 10 records in my system and all of them commimg one after another in report preview.
how we can show all the 10 records on one single page?
Please help me with this.
Thank You.
hello,
Stored Procedures that return multiple result sets do not play nice with SSRS. You need to build a result set in report builder for each result set that you need to represent in the report.
You can't use a single SSRS result set to call a proc that returns multiple result sets and access it as a collection of result sets the way you can in .net.
Once you have your multiple result sets created, you can create multiple tablix on your report, and designate in each one which result set it uses for its data.
Thanks,
Soumen