Discussion:
FRX and window envelopes
Richard Kaye
2018-10-11 13:22:27 UTC
Permalink
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
---

_______________________________________________
Post Messages to: ***@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/***@BN6PR10MB1299.namprd10.prod.outlook.com
** 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.
Jürgen Wondzinski
2018-10-11 13:30:13 UTC
Permalink
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-***@leafe.com> Im Auftrag von Richard Kaye
Gesendet: Donnerstag, 11. Oktober 2018 15:22
An: ***@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]

_______________________________________________
Post Messages to: ***@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/02ac01d46166$8a7997d0$9f6cc770$@wondzinski.de
** 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.
Dave Crozier
2018-10-11 14:27:56 UTC
Permalink
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 ***@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-***@leafe.com> On Behalf Of Jürgen Wondzinski
Sent: 11 October 2018 14:30
To: 'ProFox Email List' <***@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-***@leafe.com> Im Auftrag von Richard Kaye
Gesendet: Donnerstag, 11. Oktober 2018 15:22
An: ***@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]

_______________________________________________
Post Messages to: ***@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/***@CWLP265MB0852.GBRP265.PROD.OUTLOOK.COM
** 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 thos
Peter Cushing
2018-10-11 14:45:06 UTC
Permalink
Post by Jürgen Wondzinski
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




_______________________________________________
Post Messages to: ***@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/87e5fce1-5339-920a-59b1-***@whisperingsmith.com
** 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
John Weller
2018-10-11 14:50:22 UTC
Permalink
He said Report Header.

John Weller
Post by Jürgen Wondzinski
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: ***@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$@johnweller.co.uk
** 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.
Richard Kaye
2018-10-11 15:15:35 UTC
Permalink
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-***@leafe.com> On Behalf Of John Weller
Sent: Thursday, October 11, 2018 10:50 AM
To: ***@leafe.com
Subject: RE: AW: FRX and window envelopes

He said Report Header.

John Weller
Post by Jürgen Wondzinski
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: ***@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$@johnweller.co.uk
** 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.uk

_______________________________________________
Post Messages to: ***@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/***@BN6PR10MB1299.namprd10.prod.outlook.com
** 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 tho
Loading...