Bill have you tried printing to a CSV file then open it with Excel Buddy
Sent from my iPhone > On Aug 1, 2014, at 7:56 AM, "Bill Eyring" <[email protected]> wrote: > > 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 > >
