all groups > sql server reporting services > march 2005 >
You're in the

sql server reporting services

group:

multiple resultset in the report


multiple resultset in the report ALI-R
3/9/2005 11:30:49 PM
sql server reporting services: I have a stored procedure which returns multiplr resultsets ,and I'd like to
show it in different tabls in my report.Is it doable???

Thanks for your help.

Ray

Re: multiple resultset in the report Chris McGuigan
3/10/2005 12:28:31 AM
Ray, No, seperate result sets cannot be accessed within one dataset.
RS will always use the first resultset. You will either have to merge
the results into one set or create a split version of the SP, one SP
producing one set another SP to produce the other and use them in
seperate datasets.

Chris


[quoted text, click to view]
AddThis Social Bookmark Button