Detail section in a detail section

[Gensor]

With VB6 DataReport, is it possible to insert another Detail section in a detail section like it's possible to do in Microsoft Access ?

I want to show the content of 2 recordsets in 1 data report. I want to show a list of recipes and in the second detail section, show their ingredients.

Is it possible or not ?

[Gensor]

Actually I want to add a subreport to a data report in Visual Basic 6, is it possible?

[brucevde]

You cannot have two detail sections, two recordsets or use Sub-Reports.

The datareport is pretty limited. Basically it only supports showing a list of records from a single recordset or Master/Detail type data in a hierarchical recordset.

I think the only way to do what you want would be to create an in-memory recordset. The recordset would have a single field which you would populate with the report line you want to print. Then just dump the recordset to the datareport - but you could do that with the Printer object just as easily...

[mabbas110]

You can do one thing , this is the only solution without sub report for ur sceanrio.

When u pass the record set to the report , u passs like this for first record set

select '1' RptFlag,............... from table 1

and for second u passs like this

select '2' RptFlag,............... from table 2

now pass these two record set into report and also make group fo field "RptFlag".

But this way it would seems that there are two separate sections.