Report Designer exporting Data to excel query

Question

Hi 
 When I export a bespoke report to 'Data to excel' the data columns are not in the correct order: 
 IE. 
 Column G - PaymentAnalysis.Desc2 
 Column H - PaymentAnalysis.Desc4 
 Column I - PaymentAnalysis.Desc6 
 Column J - PaymentAnalysis.Desc10 
 Column k - PaymentAnalysis.Desc1 
 Column L - PaymentAnalysis.Desc8 
 So not in order of description 
 
 Then Totals columns are not in the same order or any particular order 
 
 Why would the info not export in order?

Robert N · Accepted Answer

Hi, 
 The order in which the columns are exported appears to be based on the "Order" of the elements from Back to Front. 
 The easiest way to get them in the correct order is to select the item you want in the first column, then: 
 Right-Click on it (to bring up the context menu), select "Order", and choose "Bring to the Front". 
 Then select the item for the next column and repeat the above right-click sequence; and so on until you have the columns in the order you want in the spreadsheet.

John Howells · Answer

Hi Jo, 
 Thanks for using Sage City 
 I notice this query has slipped through without a community response, sorry for the late reply but I thought I&rsquo;d pop something back to you. 
 As this query involves the Report Designer we'll need to direct it towards our reporting specialists. If this is something we can still help with, please log a case using our online case management system . 
 If this has answered your question please click More > Verify Answer. 
 Regards, John Howells Sage UKI

Sage 50 Payroll

Report Designer exporting Data to excel query

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING