Hi everyone,
I'm new with dynamics NAV and I'm currently working on an Excel export using ExcelBuffer. I would like to know if it's possible to sort data in ExcelBuffer based on a specific column. My problem is that I need to process data from several sources and have calculated data on which I have to sort. So I can't sort on my datasource directly.
My code is something like this :
excelbuffer.createbook(...);
if myRecord.findset then begin
repeat
entercell(data from myRecord);
calculate myDate which is based on data from myRecord and another data source
entercell(myDate);
until myRecord.next = 0;
end;
//need to sort excelbuffer on myDate
excelbuffer.writesheet(...);
excelbuffer.closebook;
excelbuffer.openexcel;
excelbuffer.giveusercontrol;
We are working with NAV2018 and VS Code
Thank you
Aurore
