Skip to Main Content
Sage 200 UKI Ideas Portal
Status Review Required
Categories Send To Excel
Created by Tim Critchley
Created on Nov 1, 2024

Data To Excel column sort order

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
  • Geoff Turner
    Reply
    |
    Nov 4, 2024

    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.