Passing multiple recordsets?

[mjbosko]

I'm using CR85 passing SQL7 stored procedures via VB (ttx file)

I need to build a customer statement, that includes not only the separate customer invoices and payments, but also an aging section.

The stored procedure sql code is already getting huge with just selecting the separate invoices and payments. Was wondering if passing two recordsets to a single report were possible? I'd almost rather build two separate procedures to get the different information.

If I sound as confused as I think I do... its becuase I am .. and probably jumping the gun on this post (but really want to get all my ducks in a row before diving in too deep on the sql code).

Thanks,

Mike

 

[synapsevampire]

No, I fear just one recordset at a time.

However you can use a subreport for a second recordset
OR
Temp table all of the data into a single rowset, and then just select from the temp table within your SP.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com