>I'm writing a report for our accounting dept which has to be used in filling in a wages earned report for the state. The code that generates the data for the report creates a temporary cursor which holds all the detail records. The online report we'll need to fill in needs the data broken down and subtotaled every 23 records though. How can I 1) Get the vfp report engine to force a new page every 23 records, and 2) calculate and include a page subtotal field at the bottom of the page's records instead of at the bottom of the page. Example, last page of report may only have 5 records, but my subtotal calculation shows up at the footer instead of right beneath the last record.
>
(1) If you are not using an index (ie, you create your report based on the result of a SELECT) you can create a grouping based on INT((RECNO()-1)/23), and tell it to start each new group on a new page.
(2) Put the subtotal in the group footer rather than the page footer.