You deserve all the credit you can get for all the work you have done with the VFP community and helping ALL of us understand and better utilize the VFP reporting tools.

Thanks for the grouping tip, I will give it a try. I guess I was making things too difficult and also wanted to explore the multi detail without just cause.

Thanks

Glenn

>First .. thanks for the praise on the articles.
>
>So if I understand this correctly ... you really only have one table, but you are fudging a second table with one record for each record in the first table just to get a 2nd page. If that's the case .. multiple detail bands are not necessary.
>
>Just use the one table. Create a data group on RECNO() and then create a second data group using RECNO() again. You can mark each to start on a new page. Put all the Page 1 info in the first data group header band and put the Page 2 info in the second data group header band. Just ignore the detail band and all the footer bands. That should solve it for you.
>
>The typical scenario for using multiple detail bands is when you have THREE tables. The first table is a parent table. The other two tables are each child tables of the parent, but necessarily related to each other. The parent is the driving table, the 1st child is the table for detail 1, and the 2nd child is the table for detail 2. You would typically create a data group and the parent information would go into the data group header band. Then the two detail bands are used for the two different child tables.
>
>I hope this helps clarify.
>
>Cathy
>
>
>
>>Terrific articles Cathy,
>>
>>I read them both and found them to be VERY clear and informative, but I am still a little stuck.
>>
>>I have a report designed with two detail bands. Each band starts on a new page (2 page duplex report) Each band has an assigned target alias. The cursors are generated in the Dataenvironment BeforeOpenTables event. The code which generates the cursors resides in DataObjects. The code which invokes the data generation looks like the following:
>>

>>LOCAL lox as cDriver OF Dataclasslib
>>IF NOT USED('DrivingCursor')
>>	CLOSE TABLES all
>>	SET CLASSLIB TO libraries\DataclassLib additive
>>	lox = CREATEOBJECT('cDriver')
>>	lox.lautoclosecursors = .f.
>>	lox.listopenDrivers()
>>ENDIF
>>SELECT RECNO() as rec FROM DrivingCursor INTO CURSOR page2cursor
>>SELECT DrivingCursor
>>SET RELATION TO RECNO() INTO page2cursor
>>SELECT DrivingCursor
>>locate
>>SET FILTER TO DrivingCursor.ready = .t.
>>

>>I have detail1 assigned to Drivingcursor and Detail2 assigned to page2Cursor since page2 is only boilerplate and no data elements.
>>
>>When I preview/Print the rpeort I get butkus! Do I need another driving cursor?
>>
>>Thanks
>>Glenn
>>
>>>>I am now faced with printing a duplex two detail report. I have not yet done any printing with multi details and am unclear how to set this up. How would you proceed with VFP9 and multi page details?
>>>>
>>>>Thanks
>>>>
>>>>Glenn
>>>
>>>Start by reading these two articles. They each have a section on MultiDetail reports.
>>>
>>>http://msdn2.microsoft.com/en-us/library/ms965279.aspx
>>>http://msdn2.microsoft.com/en-us/library/ms965281.aspx