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

 

[adisankar]

you can design your report using a sub report, and you can pass one record set to main report and another to sub report.

cheers