multiple results sets from one sp

[Crowley16]

I've got one sproc which returns multiple resultsets.

Is it possible to access these multiple results sets from a report?

when I create a dataset based on the sproc, only the first resultset is returned.

Thanks

--------------------
Procrastinate Now!

 

[xlbo]

Hi Crowley - In 2000 at least, you can only return one dataset per SP to the report. This is an essential part of the report structure as each control is bound to a single data set which must have a unique name

Maybe you could adda a parameter to your SP which controls whch recordset to return. You could then call the same SP with different parameters from the report and get your different data sets...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Crowley16]

Hi xlbo,

I'm using 2005 at the moment.

from what I've found so far, it seems like it's not supported in 05 either, but will be in 08...

--------------------
Procrastinate Now!