Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Page eject from report's group footer band
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00186647
Message ID:
00186992
Views:
19
Well, theres still two other ways to do this:

1) Use a summary band for the T&C, and issue REPORT FORM command for each PO, in a FOR..ENDFOR loop, or similar. This will print the summary for each PO. Depending on your app, this may not be desirable, as it sends multiple print jobs.

2) Add another group in the report, outside the existing one, put the T&C in that groups' footer. You may have to make the group break on a different value than the first group.

Mark

>Unfortunately not. I need a T & C for each PO and they may print or fax them in a batch mode.
>
>>Mark,
>>Can't you use a summary band for the Terms and Conditions page?
>>
>>>From the coworker at a customer's site in LA ...
>>>
>>>I want to add a terms and conditions page to each purchase order. The group is on purchase order and we already start the group on a new page.
>>>
>>>PO #1 Header
>>>PO #1 Detail
>>>PO #1 Footer
>>>** EJECT **
>>>Terms and Conditions
>>>** new page **
>>>PO #2 Header
>>>PO #2 Detail
>>>PO #2 Footer
>>>** EJECT **
>>>Terms and Conditions
>>>
>>>and so on.
>>>
>>>How can I do this with the report writer?
>>>
>>>I've put two groups one on PO # and one on the PO surrogoate key and tried putting EJECT as the On Exit expression of the group footer. I tried a CHR(12) as the expression. I tried putting a UDF as the expression with the one line "EJECT".
>>>
>>>Any suggestions welcome. Thanks.
>>>
>>>
>>>
>>>>Melanie,
>>>>At the bottom of the "Data grouping" box, there is a "Start each group on a new page" option.
>>>>
>>>>HTH!
>>>>Mark
>>>>
>>>>>A coworker wants to force a page eject from the group footer band in the VFP report writer. Any ideas?
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform