Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Big page report
Message
From
23/08/2001 12:13:14
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Miscellaneous
Thread ID:
00546091
Message ID:
00548088
Views:
18
>>Could I have a Detail Band that is more that one page, and could potentially expand?
>>
>>Kev
>
>
>I see later in the thread that you've already tackled this problem with HTML instead of the Report Writer. But just to answer your question .. "Can a detail band span across more than one page" ... technically, No. But with a few tricks you can do it.
>
>If your detail needs to cover two pages, here's what you do. Create a cursor that has two records for every record in your source table. The cursor should have an additional field called RECTYPE. When you add the two records to the cursor, make the RECTYPE field "1" for the first one and "2" for the second one. You should also index the cursor on your desired sort order + RECTYPE. For example, "ClientCode + RecType"
>
>To create the report, you need to add all the fields you want to appear on the first page into the detail band. Change the Print When logic of all those fields to RECTYPE = "1". Then add all the fields you want to appear on the second page into the detail band (right on top of the first set). Change the Print When logic of all those fields to RECTYPE = "2". I find it easiest to create the first set of fields for page one ... then start a new report and create the second set of fields for page two ... then copy the second set into the first report.
>
>As you can see, spanning a detail band across multiple pages CAN be done ... but it's tricky and a PITA to do.
>
>Cathy

Cathy

Thanks for the lowdown, it definitly is a PITA, and I thought it would be, that's why I chose to change to HTML - and although there's more code to write, it's still a lot easier than trying to do it in the RW.

Thanks again
Kev
Previous
Reply
Map
View

Click here to load this message in the networking platform