OK. Here's my conundrum of the day.
I've got an invoice report. There are multiple group bands and multiple potential multi-line objects, and periodically I get just the right combination of text that I appear to get a 2 page report that should fit on one page. In the process of trying to figure out why this is happening, I've tried every trick I can think of including Cathy Putney's stretching of bands with dummy objects at the bottom of the bands, etc. No joy. I keep getting 2 pages. Then I dropped in the _pageno object in the header and my 2 pages are both appearing as page number 1... This has to be a clue but I figure it is time to call on the wisdom of the ProFox crowd as this one is driving me nuts.
--
rk
Trying this again.
From: Richard Kaye Sent: Thursday, April 19, 2018 12:10 PM To: 'profox@leafe.com' profox@leafe.com Subject: Fun (not) with the report writer
OK. Here's my conundrum of the day.
I've got an invoice report. There are multiple group bands and multiple potential multi-line objects, and periodically I get just the right combination of text that I appear to get a 2 page report that should fit on one page. In the process of trying to figure out why this is happening, I've tried every trick I can think of including Cathy Putney's stretching of bands with dummy objects at the bottom of the bands, etc. No joy. I keep getting 2 pages. Then I dropped in the _pageno object in the header and my 2 pages are both appearing as page number 1... This has to be a clue but I figure it is time to call on the wisdom of the ProFox crowd as this one is driving me nuts.
--
rk
A possible explanation for page 1 on both pages: do you have a grouping set to restart the page number when the group breaks?
Frank.
Frank Cazabon
On 19/04/2018 12:09 PM, Richard Kaye wrote:
OK. Here's my conundrum of the day.
I've got an invoice report. There are multiple group bands and multiple potential multi-line objects, and periodically I get just the right combination of text that I appear to get a 2 page report that should fit on one page. In the process of trying to figure out why this is happening, I've tried every trick I can think of including Cathy Putney's stretching of bands with dummy objects at the bottom of the bands, etc. No joy. I keep getting 2 pages. Then I dropped in the _pageno object in the header and my 2 pages are both appearing as page number 1... This has to be a clue but I figure it is time to call on the wisdom of the ProFox crowd as this one is driving me nuts.
--
rk
[excessive quoting removed by server]
Certainly a possibility, Frank. I will check that. The odd part is there are no more detail rows at the point where I was getting the extra page. I eventually got this to a point where the extra page was suppressed, and the page number incremented properly, which was the object of the exercise. I still see the group header on a new page even after the last detail row prints but I need to let it sit for a bit before seeing if I can improve it more. Hours spent with the report writer can be a draining experience... 😊
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Frank Cazabon Sent: Friday, April 20, 2018 8:28 AM To: profoxtech@leafe.com Subject: Re: Fun (not) with the report writer
A possible explanation for page 1 on both pages: do you have a grouping set to restart the page number when the group breaks?
Frank.
Frank Cazabon
On 19/04/2018 12:09 PM, Richard Kaye wrote:
OK. Here's my conundrum of the day.
I've got an invoice report. There are multiple group bands and multiple potential multi-line objects, and periodically I get just the right combination of text that I appear to get a 2 page report that should fit on one page. In the process of trying to figure out why this is happening, I've tried every trick I can think of including Cathy Putney's stretching of bands with dummy objects at the bottom of the bands, etc. No joy. I keep getting 2 pages. Then I dropped in the _pageno object in the header and my 2 pages are both appearing as page number 1... This has to be a clue but I figure it is time to call on the wisdom of the ProFox crowd as this one is driving me nuts.
--
rk
Frank, You say dropping the _Pageno results in both pages as page 1.... how do you know they are page 1 without printing _pageno?
Just an observation as I have also spent many, many happy hours (not) battling with the report writer... 😊
Dave Crozier Software Development Manager Flexipol Packaging Ltd.
--------------------------------------------------------------- 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.
Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH
Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk ---------------------------------------------------------------
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 Richard Kaye Sent: 20 April 2018 13:40 To: profox@leafe.com Subject: RE: Fun (not) with the report writer
Certainly a possibility, Frank. I will check that. The odd part is there are no more detail rows at the point where I was getting the extra page. I eventually got this to a point where the extra page was suppressed, and the page number incremented properly, which was the object of the exercise. I still see the group header on a new page even after the last detail row prints but I need to let it sit for a bit before seeing if I can improve it more. Hours spent with the report writer can be a draining experience... 😊
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Frank Cazabon Sent: Friday, April 20, 2018 8:28 AM To: profoxtech@leafe.com Subject: Re: Fun (not) with the report writer
A possible explanation for page 1 on both pages: do you have a grouping set to restart the page number when the group breaks?
Frank.
Frank Cazabon
On 19/04/2018 12:09 PM, Richard Kaye wrote:
OK. Here's my conundrum of the day.
I've got an invoice report. There are multiple group bands and multiple potential multi-line objects, and periodically I get just the right combination of text that I appear to get a 2 page report that should fit on one page. In the process of trying to figure out why this is happening, I've tried every trick I can think of including Cathy Putney's stretching of bands with dummy objects at the bottom of the bands, etc. No joy. I keep getting 2 pages. Then I dropped in the _pageno object in the header and my 2 pages are both appearing as page number 1... This has to be a clue but I figure it is time to call on the wisdom of the ProFox crowd as this one is driving me nuts.
--
rk
_______________________________________________ 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/DM5PR10MB12447597594B239A6781AB5CD2B4... ** 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.
I think he was asking do I have any of the page number reset options set at the group level. I actually added the _pageno as a diagnostic tool whilst attempting to wrestle this beast into submission.
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Dave Crozier Sent: Friday, April 20, 2018 8:43 AM To: profoxtech@leafe.com Subject: RE: Fun (not) with the report writer
Frank, You say dropping the _Pageno results in both pages as page 1.... how do you know they are page 1 without printing _pageno?
Just an observation as I have also spent many, many happy hours (not) battling with the report writer... 😊
Dave Crozier Software Development Manager Flexipol Packaging Ltd.
-----Original Message----- From: ProFox profox-bounces@leafe.com On Behalf Of Richard Kaye Sent: 20 April 2018 13:40 To: profox@leafe.com Subject: RE: Fun (not) with the report writer
Certainly a possibility, Frank. I will check that. The odd part is there are no more detail rows at the point where I was getting the extra page. I eventually got this to a point where the extra page was suppressed, and the page number incremented properly, which was the object of the exercise. I still see the group header on a new page even after the last detail row prints but I need to let it sit for a bit before seeing if I can improve it more. Hours spent with the report writer can be a draining experience... 😊
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Frank Cazabon Sent: Friday, April 20, 2018 8:28 AM To: profoxtech@leafe.com Subject: Re: Fun (not) with the report writer
A possible explanation for page 1 on both pages: do you have a grouping set to restart the page number when the group breaks?
Frank.
Frank Cazabon
On 19/04/2018 12:09 PM, Richard Kaye wrote:
OK. Here's my conundrum of the day.
I've got an invoice report. There are multiple group bands and multiple potential multi-line objects, and periodically I get just the right combination of text that I appear to get a 2 page report that should fit on one page. In the process of trying to figure out why this is happening, I've tried every trick I can think of including Cathy Putney's stretching of bands with dummy objects at the bottom of the bands, etc. No joy. I keep getting 2 pages. Then I dropped in the _pageno object in the header and my 2 pages are both appearing as page number 1... This has to be a clue but I figure it is time to call on the wisdom of the ProFox crowd as this one is driving me nuts.
Dave,
I don't have the problem, Richard does. I think you may have misinterpreted what he said:
Then I dropped*in* the _pageno object in the header and my 2 pages are both appearing as page number 1...
Frank.
Frank Cazabon
On 20/04/2018 08:43 AM, Dave Crozier wrote:
Frank, You say dropping the _Pageno results in both pages as page 1.... how do you know they are page 1 without printing _pageno?
Just an observation as I have also spent many, many happy hours (not) battling with the report writer... 😊
Dave Crozier Software Development Manager Flexipol Packaging Ltd.
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.
Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH
Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk
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 Richard Kaye Sent: 20 April 2018 13:40 To: profox@leafe.com Subject: RE: Fun (not) with the report writer
Certainly a possibility, Frank. I will check that. The odd part is there are no more detail rows at the point where I was getting the extra page. I eventually got this to a point where the extra page was suppressed, and the page number incremented properly, which was the object of the exercise. I still see the group header on a new page even after the last detail row prints but I need to let it sit for a bit before seeing if I can improve it more. Hours spent with the report writer can be a draining experience... 😊
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Frank Cazabon Sent: Friday, April 20, 2018 8:28 AM To: profoxtech@leafe.com Subject: Re: Fun (not) with the report writer
A possible explanation for page 1 on both pages: do you have a grouping set to restart the page number when the group breaks?
Frank.
Frank Cazabon
On 19/04/2018 12:09 PM, Richard Kaye wrote:
OK. Here's my conundrum of the day.
I've got an invoice report. There are multiple group bands and multiple potential multi-line objects, and periodically I get just the right combination of text that I appear to get a 2 page report that should fit on one page. In the process of trying to figure out why this is happening, I've tried every trick I can think of including Cathy Putney's stretching of bands with dummy objects at the bottom of the bands, etc. No joy. I keep getting 2 pages. Then I dropped in the _pageno object in the header and my 2 pages are both appearing as page number 1... This has to be a clue but I figure it is time to call on the wisdom of the ProFox crowd as this one is driving me nuts.
--
rk
[excessive quoting removed by server]
... old age reply from me!! lol
Dave Crozier Software Development Manager Flexipol Packaging Ltd.
--------------------------------------------------------------- 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.
Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH
Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk ---------------------------------------------------------------
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 Frank Cazabon Sent: 20 April 2018 13:46 To: profox@leafe.com Subject: Re: Fun (not) with the report writer
Dave,
I don't have the problem, Richard does. I think you may have misinterpreted what he said:
Then I dropped*in* the _pageno object in the header and my 2 pages are both appearing as page number 1...
Frank.
Frank Cazabon
On 20/04/2018 08:43 AM, Dave Crozier wrote:
Frank, You say dropping the _Pageno results in both pages as page 1.... how do you know they are page 1 without printing _pageno?
Just an observation as I have also spent many, many happy hours (not) battling with the report writer... 😊
Dave Crozier Software Development Manager Flexipol Packaging Ltd.
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.
Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH
Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk
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 Richard Kaye Sent: 20 April 2018 13:40 To: profox@leafe.com Subject: RE: Fun (not) with the report writer
Certainly a possibility, Frank. I will check that. The odd part is there are no more detail rows at the point where I was getting the extra page. I eventually got this to a point where the extra page was suppressed, and the page number incremented properly, which was the object of the exercise. I still see the group header on a new page even after the last detail row prints but I need to let it sit for a bit before seeing if I can improve it more. Hours spent with the report writer can be a draining experience... 😊
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Frank Cazabon Sent: Friday, April 20, 2018 8:28 AM To: profoxtech@leafe.com Subject: Re: Fun (not) with the report writer
A possible explanation for page 1 on both pages: do you have a grouping set to restart the page number when the group breaks?
Frank.
Frank Cazabon
On 19/04/2018 12:09 PM, Richard Kaye wrote:
OK. Here's my conundrum of the day.
I've got an invoice report. There are multiple group bands and multiple potential multi-line objects, and periodically I get just the right combination of text that I appear to get a 2 page report that should fit on one page. In the process of trying to figure out why this is happening, I've tried every trick I can think of including Cathy Putney's stretching of bands with dummy objects at the bottom of the bands, etc. No joy. I keep getting 2 pages. Then I dropped in the _pageno object in the header and my 2 pages are both appearing as page number 1... This has to be a clue but I figure it is time to call on the wisdom of the ProFox crowd as this one is driving me nuts.
--
rk
[excessive quoting removed by server]
_______________________________________________ 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/07cd7c55-a92c-deed-4c85-93d1d30cf011@... ** 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.
I like Frank's interpretation better. 😉
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Dave Crozier Sent: Friday, April 20, 2018 8:47 AM To: profoxtech@leafe.com Subject: RE: Fun (not) with the report writer
... old age reply from me!! lol
Dave Crozier -----Original Message----- From: ProFox profox-bounces@leafe.com On Behalf Of Frank Cazabon Sent: 20 April 2018 13:46 To: profox@leafe.com Subject: Re: Fun (not) with the report writer
Dave,
I don't have the problem, Richard does. I think you may have misinterpreted what he said:
Then I dropped*in* the _pageno object in the header and my 2 pages are both appearing as page number 1...
Frank.
Frank Cazabon
On 20/04/2018 08:43 AM, Dave Crozier wrote:
Frank, You say dropping the _Pageno results in both pages as page 1.... how do you know they are page 1 without printing _pageno?
Just an observation as I have also spent many, many happy hours (not) battling with the report writer... 😊
Dave Crozier Software Development Manager Flexipol Packaging Ltd.
On 19/04/2018 17:09, Richard Kaye wrote:
OK. Here's my conundrum of the day.
I've got an invoice report. There are multiple group bands and multiple potential multi-line objects, and periodically I get just the right combination of text that I appear to get a 2 page report that should fit on one page. In the process of trying to figure out why this is happening, I've tried every trick I can think of including Cathy Putney's stretching of bands with dummy objects at the bottom of the bands, etc. No joy. I keep getting 2 pages. Then I dropped in the _pageno object in the header and my 2 pages are both appearing as page number 1... This has to be a clue but I figure it is time to call on the wisdom of the ProFox crowd as this one is driving me nuts.
For problems like this I sometimes get my report program to write out my final cursor contents to disk. When you find one to stretches to 2 pages you can open this table in fox, then open your report and do a preview and see if it goes to 2 pages. For invoices you could just write it out using the invoice number E.g. 123456.dbf possibly to a new subfolder. You can then clean them up easily.
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
Hi Richard,
you may want to test with the 32Bit version of VFPA ("A" as the hex representation of "10") There are some Reportwriter-related problems fixed: http://baiyujia.com/vfpdocuments/default.asp
See http://baiyujia.com/vfpadvanced/f_vfpa_about.asp for infos and download (you want to download the "VFP extended 32 bit" version)
For installation you need a valid VFP9 version installed, which the installer then copies to a new VFPA directory and patches the EXE and DLLs to the VFPA level. You need to do a "Recompile All" with your project, and then copy the runtime file (now only one!) plus your new exe to your customers directory. That's it.
wOOdy
[excessive quoting removed by server]
-
Dave Crozier -
Frank Cazabon -
Jürgen Wondzinski -
Peter Cushing -
Richard Kaye