To close the loop on this one... I stripped my production report to two columns in a detail band and no headers or footers and it still failed. Razzak was kind enough to look at the report and he was able to resolve the issue. The "fix" was to increase the height of the objects in the detail band slightly (Aerial 10 font). That got rid of the error and the miss-alignment of data. Unfortunately, I have not yet resolved the problem with the original production report. I tried increasing the height of the objects in the detail band but I still get errors and miss-alignment. When I get time, I will keep adjusting the positions and sizes of the report objects to see if I can get it to work. I am thinking that I may have to adjust the title and page headers and footers also or take the title etc. off the report. For now, I am exporting the data to a CSV file so that my client can send the data to his client. John -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of John Engwer Sent: Saturday, March 07, 2009 1:50 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Print to XLS -- continued ...
Gunner and Razzak... Thank you I had the "print to XLS" working a while back and one of my clients called earlier this week and said it doesn't work anymore. I have no idea what changed or exactly when it stopped working. It is part of a mailing routine that is not run very often. The reason I chose to use "print to XLS" was so that I could add titles and other customized header data. It looks nice when it works. Razzak, I will send you a copy of a test DB that I constructed that consists of one table with two columns (250 rows), one form and one report. The report that generates the XLS contains just data; no headers or footers. It fails every time with the error. John -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Saturday, March 07, 2009 11:28 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Print to XLS -- continued ... continued ... John, In addition to my earlier suggestions ... When PRINTing a report as XLS, the setup within the Report Designer must be defined very meticulously in regards to fixed width fonts and spacing between fields and report bands. Only through testing back and forth to see how your result display can one confirm what spacing works with what exact data you're trying to display. Very Best R:egards, Razzak.
