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




_______________________________________________
Post Messages to: [email protected]
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/[email protected]
** 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.

Reply via email to