Wrong headings in excel file

[deepucec9]

Instead of column heading, table field names are displayed in the excel file.
Created a report and its works fine when it is saved in a pdf format. When saving it in an excel format files shows field names as column headings.


Please find the attached screenshots..
TIA

[ranman256]

Excel column names ARE field names. Same thing.

[ssanfu]

Not sure I understand correctly, maybe give this a try.

The report should be based on a query, not a table.
In the query design view, you can alias the field names:

first query column = Case id: caseid_out
second query column = Pallet: pallet_out
third query column = PO Number: ponumber_out
etc......

SQL view would look like:

SELECT caseid_out as [Case id], pallet_out as Pallet, ponumber_out as [PO Number], .....

[deepucec9]

Thank you ssanfu.