I have a similar requirement which was resolved here on the UT thanks to Cathy. I step through the source table and populate a 2nd table that is actually used to render the report. The 2nd table has a field for which detail band the records belong in (i.e. detail). This field is set to 1 if the records go in that detail band and 2 for the 2nd detail band, etc. In some cases information from the record must go in both detail bands so I add it to the 2nd table twice - with each record having the appropriate detail field value. On the report itself, the report is grouped by the values in this field for my purposes. To push the 2nd detail band to where I want it(half way down the page in my case), I put a field on the report just after my first detail section that prints carriage returns to push the 2nd detail band (actually grouping on my report) down the page:

IIF(33-(nlinesgroup+nlinesdetail+14)>0.and.tmpreceipt.detail=1,REPLICATE(CHR(13),33-(nlinesgroup+nlinesdetail+14)),"")

Someone may have a better idea, but this works for me.



to
>Hello -
>
>I'm am trying to create a report using the VFP report designer. How do I print multiple detail bands. The data is coming from a single table, and the report will only contain two pages. The thing is, I need all of the information from the first detail band (along with the page header band) to print on the first page only, and all information from the second detail band (along with the page footer band ) to print on the second page only.
>Can someone please point me in the right direction? Any help would be greatly appreciated.
>
>Thanks,
>Frank Milhofer