export report to Excel results in 2 rows of column headers

  • Thread starter Thread starter cm
  • Start date Start date
C

cm

Here's my issue. I have to export data to excel for uploading to a vendor's
system. The vendor required that several of the columns have IDENTICAL
headings (don't ask - i know that is stupid), and one of the column headings
has to contain a % symbol at the end (also stupid).

I can't do this with exporting a query, so I tried using a report. If I make
text boxes for the desired duplicate column headings, it works just fine. The
problem is that on row 2 of the exported data, the actual column headings
from the query are also exported. Can this be avoided?

Sample of exported data:
Ded % DedAmt DedAmt
Ded DedAmt DedAmt2
3 34.5 56.7
 
Have you considered puting a couple of phony records that will sort for the
two with the necessary information?
 
This shouldn't be as difficult as it turns out to be! I would probably export
the query to an Excel file with sensible column names and then use Automation
code to open the Excel file and change the column names to whatever your
client wants.
 
Perhaps I need to clarify some. In the 'sample' below, the row not wanted is
row 2, which are headers from the query underlying the report. The first row
are headings I made with text boxes in the report header (desired output) and
the third row is sample field values.

I dont' want the headers from the query - can't see a way to keep it from
exporting these.
 
Back
Top