While I start my own research, I thought I should call on the wisdom of the collective. Here's the goal. I have a number of client facing reports with address blocks. They may be one page. They may be many pages. I want to be able to fold the report to fit in a standard windowed envelope and not have any of the detail appear in the window. This requires a fixed location for the detail to start on the first page. I would like to reclaim some portion of that space for additional pages as the address block will not print on page 2 and after. What are some tricks to get a fixed height header on page 1 but not on subsequent pages?
TIA
--
rk
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
Hi Richard,
That's why there's a Report header, which only prints once. You would use that for your first page.
Then, you print a report for each record separately
SELECT YourAdressTable SCAN FOR YourCondition REPORT NEXT 1 FORM MyList.frx TO PRINTER NOCO ENDSCAN
You could also add some code into that loop to watch for some abort keypress etc
wOOdy
"*´¨) ¸.·´¸.·*´¨) ¸.·*¨) (¸.·´. (¸.·` * .·`.Visual FoxPro: It's magic ! (¸.·``··*
-----Ursprüngliche Nachricht----- Von: ProFox profox-bounces@leafe.com Im Auftrag von Richard Kaye Gesendet: Donnerstag, 11. Oktober 2018 15:22 An: profox@leafe.com Betreff: FRX and window envelopes
While I start my own research, I thought I should call on the wisdom of the collective. Here's the goal. I have a number of client facing reports with address blocks. They may be one page. They may be many pages. I want to be able to fold the report to fit in a standard windowed envelope and not have any of the detail appear in the window. This requires a fixed location for the detail to start on the first page. I would like to reclaim some portion of that space for additional pages as the address block will not print on page 2 and after. What are some tricks to get a fixed height header on page 1 but not on subsequent pages?
TIA
--
rk
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]
As for folding the letter so that it always shows the address in the window I have found that putting horizontal Dashes on the left and right of the page siginifying where to fold is the best way to ensure conformity.
Dave Crozier Software Development Manager Flexipol Packaging Ltd.
﴾⚆ᨎ⚆﴿
Flexipol® Packaging Ltd T 01706 222 792 E DCrozier@flexipol.co.uk W https://www.flexipol.co.uk/ Follow us: Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 5HH
This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received.
It is the responsibility of the recipient to ensure that they have adequate virus protection.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Terms & Conditions: Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time -----Original Message----- From: ProFox profox-bounces@leafe.com On Behalf Of Jürgen Wondzinski Sent: 11 October 2018 14:30 To: 'ProFox Email List' profox@leafe.com Subject: AW: FRX and window envelopes
Hi Richard,
That's why there's a Report header, which only prints once. You would use that for your first page.
Then, you print a report for each record separately
SELECT YourAdressTable SCAN FOR YourCondition REPORT NEXT 1 FORM MyList.frx TO PRINTER NOCO ENDSCAN
You could also add some code into that loop to watch for some abort keypress etc
wOOdy
"*´¨) ¸.·´¸.·*´¨) ¸.·*¨) (¸.·´. (¸.·` * .·`.Visual FoxPro: It's magic ! (¸.·``··*
-----Ursprüngliche Nachricht----- Von: ProFox profox-bounces@leafe.com Im Auftrag von Richard Kaye Gesendet: Donnerstag, 11. Oktober 2018 15:22 An: profox@leafe.com Betreff: FRX and window envelopes
While I start my own research, I thought I should call on the wisdom of the collective. Here's the goal. I have a number of client facing reports with address blocks. They may be one page. They may be many pages. I want to be able to fold the report to fit in a standard windowed envelope and not have any of the detail appear in the window. This requires a fixed location for the detail to start on the first page. I would like to reclaim some portion of that space for additional pages as the address block will not print on page 2 and after. What are some tricks to get a fixed height header on page 1 but not on subsequent pages?
TIA
--
rk
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]
On 11/10/2018 14:30, Jürgen Wondzinski wrote:
Hi Richard,
That's why there's a Report header, which only prints once. You would use that for your first page.
Then, you print a report for each record separately
SELECT YourAdressTable SCAN FOR YourCondition REPORT NEXT 1 FORM MyList.frx TO PRINTER NOCO ENDSCAN
I think the best place for the address is in a group header as you don't want the address on page 2, 3 etc, which would happen if you put the address in the page header. Make the group match the account code you are printing for and the address will only appear on the first page.
If you got all your data into one cursor you could print the whole lot in one go by setting the group to start on "new page number 1"
Peter
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299 7960
He said Report Header.
John Weller
That's why there's a Report header, which only prints once. You would use that for your first page.
Then, you print a report for each record separately
SELECT YourAdressTable SCAN FOR YourCondition REPORT NEXT 1 FORM MyList.frx TO PRINTER NOCO ENDSCAN
I think the best place for the address is in a group header as you don't want the address on page 2, 3 etc, which would happen if you put the address in the page header. Make the group match the account code you are printing for and the address will only appear on the first page.
Thanks to all that have chimed in. As usual, the devil lies in the details. And I left out a few. 😊
Some reports have the address block in the page header; some have the block in a group header. (Some have multiple groups.) Some may reprint the group header. There are also some objects with stretchable text so the height of the various header bands might vary when there is more or less text. Woody, I think you are recommending using the Header band for the letterhead and address block as that will only print at the beginning of each REPORT FORM call.
All good food for thought. Thanks again.
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of John Weller Sent: Thursday, October 11, 2018 10:50 AM To: profoxtech@leafe.com Subject: RE: AW: FRX and window envelopes
He said Report Header.
John Weller
That's why there's a Report header, which only prints once. You would use that for your first page.
Then, you print a report for each record separately
SELECT YourAdressTable SCAN FOR YourCondition REPORT NEXT 1 FORM MyList.frx TO PRINTER NOCO ENDSCAN
I think the best place for the address is in a group header as you don't want the address on page 2, 3 etc, which would happen if you put the address in the page header. Make the group match the account code you are printing for and the address will only appear on the first page.
_______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/00d201d46171$bdc39fe0$394adfa0$@johnw... ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Report [OT] Abuse: http://leafe.com/reportAbuse/00d201d46171$bdc39fe0$394adfa0$@johnweller.co.u...