Posted 15 March 2022, 9:20 am EST
I have a series of reports that are created for a 3rd party application that we use. This application has the option to convert reports to excel format. In some of the reports, field and columns can be moved around and renamed quite frequently, so this creates a problem when the report is exported to Excel, and I don’t see a way to force the field order.
For example, in one report, there are 11 fields in the Detail section. When it is exported to Excel, instead of showing the fields in order, it’s more like: 1, 4, 8, 3, 5, 6, 7, 9, 10, 11, 2. While it’s fine for the report, it displays out of order in excel. I’m not sure how the 3rd party application is converting it (I’m assuming just running through a list of controls), but I don’t see a way to re-order the controls other than swapping each field control and re-configuring each field one at a time.
