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