[RBASE-L] - SV: Printing Reports to Excel Questions

[Gunnar Ekblad]

Bill
I will only answer on 3:rd questiob: Use the wizard

Gunnar Ekblad
Kontema IT AB
Hästholmsvägen 32
131 30 Nacka
Sweden


-----Ursprungligt meddelande-----
Från: rbase-l@rbase.com [mailto:rbas...@rbase.com] För Bill Eyring
Skickat: den 3 februari 2009 02:09
Till: RBASE-L Mailing List
Ämne: [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