Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to create multi-page report
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00581891
Message ID:
01190627
Views:
29
Eureeka! It works like a million.

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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform