When using Data to Excel to export information from reports, the column sort order cannot be amended from the Report Designer. This causes an issue when adding a 5th ageing period to the age debtors, the export does not position the 5th ageing column adjacent to the 4th ageing column.
Product Variant | Sage 200 Professional |
I'm fairly sure that the variables are exported in the same sequence as they are shown in the Report Explorer in report designer - and that is in order of top then left position in each section. So just make sure that this is correct - Format / Alignment / Top is quite useful for doing that.