export to excel from dynamic nav.

Dynamics 365 Business Central/NAV Developers Forum
1

8838.monir.jpg
8838.monir.jpg1280×1024 199 KB

I want to export this report

8838.monir.jpg
8838.monir.jpg1280×1024 199 KB

i want to design this report in excel also. how can i do this?

makeexcelinfo()

ExcelBuf.SetUseInfoSheed;
ExcelBuf.AddInfoColumn(FORMAT(Text010),FALSE,’’,TRUE,FALSE,FALSE,’’);
ExcelBuf.AddInfoColumn(COMPANYNAME,FALSE,’’,FALSE,FALSE,FALSE,’’);
ExcelBuf.NewRow;
ExcelBuf.AddInfoColumn(FORMAT(Text015),FALSE,’’,TRUE,FALSE,FALSE,’’);
ExcelBuf.AddInfoColumn(FORMAT(Text014),FALSE,’’,FALSE,FALSE,FALSE,’’);
ExcelBuf.NewRow;
ExcelBuf.AddInfoColumn(FORMAT(Text012),FALSE,’’,TRUE,FALSE,FALSE,’’);
ExcelBuf.AddInfoColumn(REPORT::“Available Items”,FALSE,’’,FALSE,FALSE,FALSE,’’);
ExcelBuf.NewRow;
ExcelBuf.AddInfoColumn(FORMAT(Text011),FALSE,’’,TRUE,FALSE,FALSE,’’);
ExcelBuf.AddInfoColumn(USERID,FALSE,’’,FALSE,FALSE,FALSE,’’);
ExcelBuf.NewRow;
ExcelBuf.AddInfoColumn(FORMAT(Text013),FALSE,’’,TRUE,FALSE,FALSE,’’);
ExcelBuf.AddInfoColumn(TODAY,FALSE,’’,FALSE,FALSE,FALSE,’’);
ExcelBuf.NewRow;
ExcelBuf.AddInfoColumn(FORMAT(Text014),FALSE,’’,TRUE,FALSE,FALSE,’’);
ExcelBuf.AddInfoColumn(Item.GETFILTERS,FALSE,’’,FALSE,FALSE,FALSE,’’);

ExcelBuf.ClearNewRow;
MakeExcelDataHeader;

MakeExcelDataHeader()

ExcelBuf.NewRow;
ExcelBuf.AddColumn(FORMAT( Text001),FALSE,’’,TRUE,FALSE,TRUE,’@’);
ExcelBuf.NewRow;
ExcelBuf.AddColumn(FORMAT(Text002),FALSE,’’,TRUE,FALSE,TRUE,’@’);
ExcelBuf.AddColumn(FORMAT(Text003),FALSE,’’,TRUE,FALSE,TRUE,’@’);
ExcelBuf.AddColumn(FORMAT(Text004),FALSE,’’,TRUE,FALSE,TRUE,’@’);
ExcelBuf.AddColumn(FORMAT(Text005),FALSE,’’,TRUE,FALSE,TRUE,’@’);
ExcelBuf.AddColumn(FORMAT(Text006),FALSE,’’,TRUE,FALSE,TRUE,’@’);
ExcelBuf.AddColumn(FORMAT(Text007),FALSE,’’,TRUE,FALSE,TRUE,’@’);
ExcelBuf.AddColumn(FORMAT(Text006),FALSE,’’,TRUE,FALSE,TRUE,’@’);
ExcelBuf.NewRow;
ExcelBuf.AddColumn(FORMAT(Text007),FALSE,’’,TRUE,FALSE,TRUE,’@’);
ExcelBuf.AddColumn(FORMAT(Text008),FALSE,’’,TRUE,FALSE,TRUE,’@’);
ExcelBuf.NewRow;
ExcelBuf.AddColumn(FORMAT(Text009),FALSE,’’,TRUE,FALSE,TRUE,’@’)

MakeExcelDataBody()

ExcelBuf.NewRow;
ExcelBuf.AddColumn(Item.“No.”,FALSE,’’,FALSE,FALSE,FALSE,’’);
ExcelBuf.NewRow;
ExcelBuf.AddColumn(Location.Code,FALSE,’’,FALSE,FALSE,FALSE,’’);
ExcelBuf.AddColumn(totalqty,FALSE,’’,FALSE,FALSE,FALSE,’’);
ExcelBuf.AddColumn(reserved,FALSE,’’,FALSE,FALSE,FALSE,’’);
ExcelBuf.AddColumn(totalavailable,FALSE,’’,FALSE,FALSE,FALSE,’’);
ExcelBuf.AddColumn(ImportDate,FALSE,’’,FALSE,FALSE,FALSE,’’);
ExcelBuf.AddColumn(OrderNo,FALSE,’’,FALSE,FALSE,FALSE,’’);

ExcelBuf.AddColumn(FinalQty,FALSE,’’,FALSE,FALSE,FALSE,’’);
ExcelBuf.AddColumn(FinalReserved,FALSE,’’,FALSE,FALSE,FALSE,’’);
ExcelBuf.AddColumn(FinalAvailable,FALSE,’’,FALSE,FALSE,FALSE,’’);

CreateExcelBook()

ExcelBuf.CreateBook;
ExcelBuf.CreateSheet(Text010,Text011,COMPANYNAME,USERID);
ExcelBuf.GiveUserControl;
ERROR(’’);

how can i make same outlook in excel?

2

With the lines and everything? You’ll need to start on MSDN and look through the Excel automations. You’ll have to add custom functions to the Excel Buffer table that utilize those automations.

3

I want this without line as like the following image. how can i make this outlook?

8154.barcode.jpg
8154.barcode.jpg1280×1024 222 KB

4

It looks like you are using different fonts, so again, the same answer applies. Go to MSDN, search for the topics on Excel, and go from there.