Exporting Item list to excel with a report in NAV 2018

AitorEGAitorEG Posts: 240Member
Hi everyone,

As i've wrote in the tittle, I need to export a item list to excel in NAV 2018. In 2013, I was doing it with a report, defined as shown below:

CodeUnit code calling to the report:

:
ServerDestination := 'C:\Users\Public\Documents\insizeStock\';
Tofile := STRSUBSTNO('InsizeEUR.xlsx');
REPORT.SAVEASEXCEL(50070,ServerDestination + Tofile);

Report:

hbsy80c7u3rl.png

"Item" dataitem properties:

ro1qttwp8cfo.png

Report properties:

dlic1zkz4nqs.png


When I run the method from the Codeunit, The excel is created, but it is empty. Is it possible to create a escel with a report in NAV2018, or should I create it with an XMLPort??

Thank you very much
Sign In or Register to comment.