Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wackoyacky
Starting Member
25 Posts |
 Posted - 2007-09-17 : 11:25:43
|
| Hi guys,I've been doing some LOCAL reports on my current application until recently there's has been a case that I really need to do SERVER reports.Usually when I design my local reports, I create a XSD file, so I usually have one dataset with multiple tables in it. I just pass the dataset to report with a single procedure call that returns multiple result sets or data table.From what I understood server reports are binded to database objects only, like stored procedures. Now I used the same stored procedure that I used in my local report to my server report. But the thing is only the first result set in the stored procedure is recognized. Are there anyway that I can bind the server report to a single stored procedure that return multiple result sets?Thanks. |
|
|
|
|
|
StoredProc with multiple result In Server Report