I thought it was a matter of the "white space" between columns in your report. If there is a certain amount of blank space between columns, it decides that there is supposed to be a column in there and reserves space for it, and the only thing you can do it locate the columns very close to each other. Honestly, I'm impressed if that is the only issue you're having! I can't say I've had much luck getting reports to print to Excel without requiring alot more fix-up than that. You always get all the data, but it just sometimes doesn't appear in the column you think it should.
Karen -----Original Message----- From: Bill Eyring <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Fri, Aug 1, 2014 6:57 am Subject: [RBASE-L] - RE: Printing a Report to XLS File Gary, Thanks for your insight. I have been working on a solution to this problem and have tried many combinations to eliminate the stray insertion of columns in an 11 column report. I have tried different fonts, font sizes, margins etc. The best I have found so far inserts only 1 blank column into an 11 column report. Of course my customer wants NO blank columns, so I will continue my quest. Should I find a solution I will let you know. Many thanks for your help. Bill Eyring From: [email protected] [mailto:[email protected]] On Behalf Of Gary Wendike Sent: Monday, July 28, 2014 8:23 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Printing a Report to XLS File Bill, what I have found with printing to XLS file is RBase does interpret the printout and the spreadsheet in the same columnar layout format. There are many variables to the layout, but unless the report is laid out to have the same dimensions relationship as the columns in a spreadsheet, you will never get it work in printing directly to an EXCEL file. What I have had to do in the past is provide an additional print routine for those reports or use Gateway to provide the data. In creating a report that prints to EXCEL you have to play with the field locations in the design mode in order to eliminate the blank column or in some cases make sure all the columns are captured. The font size will be critical in making sure of the alignment. The report really is only good for EXCEL printouts as the layout is for the column location not the presentation. Hope this helps. Gary From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, July 23, 2014 9:31 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Printing a Report to XLS File Jason, Thanks for the reply. It's when I print a report. It seems it wants to put a blank column "I" between Columns "H" and "J" . there is no data for column "I". Column "I" should not be there. I need to use a report as there is a first column with line descriptions. Columns B through K should be contiguous, there are no blank data columns. It seems Excel is formatting the report and inserting column "I" for some reason. Maybe there is a formatting option that will eliminate the blank column when printing ? There is no problem with Gateway or CSV. Bill -------- Original Message -------- Subject: [RBASE-L] - RE: Printing a Report to XLS File From: "Kramer, Jason J" <[email protected]> Date: Wed, July 23, 2014 6:52 am To: [email protected] (RBASE-L Mailing List) Dear Bill, Do you have the same problem if you do a GATEWAY EXPORT instead of PRINT? Do you get a blank column if you use a CSV file instead of an Excel file? Is the terminal character in column 5 something that R:BASE in interpreting as a delimiter and making an extra column (is the last character being dropped from column 5)? Jason Jason Kramer University Archives and Records Management 002 Pearson Hall (302) 831 - 3127 (voice) (302) 831 - 6903 (fax) From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, July 23, 2014 9:34 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Printing a Report to XLS File I have a report which prints to an XLS file. Everything comes through to the XLS file with one exception; The report can have between 7 and 11 columns depending on the data. When the XLS file opens there is a blank column inserted between columns 5 and 6. Now I know I could just delete the column on edit, but I would rather see that inserted column gone with all columns being contiguous. Here is my code to print to an XLS file; print SalesGrid10 + OPTION XLS + |FILENAME .vFile + |SHOW_CANCEL_DIALOG OFF + |ALL_TEXT_IN_GENERAL_FORMAT OFF + |CELL_ATTR ON + |INCLUDE_IMAGES OFF + |INCLUDE_LINES OFF + |INCLUDE_RICH_TEXT ON + |RICHTEXT_ENCODING_TYPE IMAGE + |INCLUDE_SHAPES OFF + |LINE_SPACE 0 + |ONE_SHEET_PER_PAGE ON + |OPEN ON Any suggestions ? Thanks. Bill Eyring
