Hi Jim,
If you really need this behavior and can't move to a label, then what you may want to consider is setting up the report cursor programmatically and creating a new field. Something like SELECT *,groupflag AS SPACE(2) INTO....whatever, and then SCAN and use a REPLACE command to assign a sequential group ID. Then, in the report, use your grouping options. Make sense?
>Thanks for the reply. What has happened is the company I am writing this program as custom forms. I have the ticket set up to print on their custom size. But sometimes they need to have the items spill over on a second ticket. We have figured out that it takes 11 detail lines to complete this task. What I have run in to is how to tell it to spill to a second ticket when the number of items are greater than 11. I have looked at Page eject, on page and some other commands for forms. I have not figured out which one I need to use or if I have to write a function that will count line items and then do a page eject.
>
>Thanks Jim.
>
>>Hi Jim,
>>
>>Are only 11 detail lines printing because of the physical size of the ticket? You might want to consider the ADDLABEL app and the Label Wizard. The ADDLABEL APP can be found in the Visual FoxPro Tools\Addlabel directory. There you can define this form size. Then use the Label Wizard to set up the label just like you would a report. You can then use MODIFY LABEL to play around with whatever other changes you need.
>>
>>>I have a report that is a special size ticket. 8.5 x 7" The detail lines is only allowing for 11 items. I need the report to reprint the header information when the line items reaches past 11 items. I know eject page will do something like this but I ame not sure where to place it. I need a little help on this item.
>>>
>>>Thanks Jim
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05