Two recordsets

Hi all,

I'm using VB6, ADO, Access Database and Data Report Designer for reporting. I'm generating my recordsets at runtime and using them to populate the reports. I have this problem:

In a particular report, I need to display data from two recordsets. The data from the first recordset has to be displayed fully, then below it, the data from the second recordset has to be displayed.

I tried connecting two rptTextBoxes to each recordset, but that causes data from the two recordsets to intermingle.

Help me please.. :confused: I'm not up to speed with the Data Report thing.

I think you need a subreport but sadly DataReport does not have such...

If this is a typical Master-Detail report then you will need to use a Hierarchical recordset. Search for Data Shaping.

This might get you started..

http://www.vbforums.com/showthread.php?t=346079