Excel Export of Report

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have a report that has 4 columns across an 8.5 x 11 sheet of paper. No
special graphics or anything to deal with. I'd like to export it to Excel in
the columnar fashion but when I export it coverts the data into ROWS rather
than COLUMNS - what do I need to do?
thanks!
 
I do not think there is a way to do this directly. One
option I see is to export the report to Word, convert it
to a table, and than take the table to excell.
Not a nice way to do it.
Fons
 
Why not export the query or table that the report is based on. It i
allot cleaner export. I export my data to a hidden sheet and the
reference the data on the main sheet. This keeps all my formatting
 
Back
Top