Monday, February 20, 2012

multiple resultset in the report

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.
RayRay, 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
ALI-R wrote:
> 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

No comments:

Post a Comment