Gunnar,Gary Thanks for your help. I am also exploring using the Excel specification file and I'm getting the hang of it and the spreadsheets look good. Is there a way in the specification file to selectively sum columns ? Are there other settings that I don't see that can be included in the specification file ? Thanks, Bill Eyring
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Gary Wendike Sent: Tuesday, February 03, 2009 8:02 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Printing Reports to Excel Questions Bill, the only way I know to print to an Excel file and have everything line up properly is create a report that specifically is for printing to Excel. That said, you will have to play with the report and align each of the columns so they print correctly into Excel. There is no exact science to this process. Because of the way the information is produced by RBase and read by Excel, you have to fudge the alignment. This is a somewhat tedious process, however the results can be rewarding. BTW do not use lines in the report, they never seem to transfer properly. Gary _____ From: Bill Eyring <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, February 2, 2009 7:09:27 PM Subject: [RBASE-L] - Printing Reports to Excel Questions I have several questions regarding printing reports to an Excel file. 1. When I print a report to the screen or a printer the column headings and data are aligned. When I print to an excel file the data columns become offset to the column headings. How do I align the column headings with the corresponding data columns ? 2. I use the following command to print a report to an Excel file; SET V VFILE='AgencyActivity.xls' print CLIsum + option XLS + |FILENAME .vfile + |all_text_in_general_format off + |cell_attr on + |include_images off + |include lines off + |line_space actual + |one_sheet_per_page off + |open on everything prints as specified to the Excel file. However if I use; print CLIsum + option XLS + open on the Print Dialog appears the file type is set to PDF. How come and how do I fix it ? 3. How do I create a specification file(Filename.RGW) for Gateway Export ? Many thanks. Any and all answers welcome. Bill Eyring
