Dynamics Community Forum Thread Details

How to save the file in shared Network folder

Hi Team,

I have written a codeunit which will run through JOB QUEUE and save the report in an predefined local folder.

However when i want to save the same file to a shared network folder, I am getting error. How do I achieve this?

I am using ON-PREMISE BC and I am using ExcelReport.SaveAsExcel(FileNameAndPath); to save the report in local folder which is working properly.

trigger OnRun()
var
FileNameAndPath: Text[250];
LoanRec: Record xxx;
ExcelReport: Report /xxx Excel Report/;
Startdate: Date;
Enddate: Date;
begin
Startdate := 20210101D; //Requirement: Start Date 1/1/2021
Enddate := Today;
LoanRec.SetCurrentKey(/Creation Date/);
LoanRec.SetRange(/Creation Date/, Startdate, Enddate);
ExcelReport.SetTableView(LoanRec);
FileNameAndPath := '////xxx//xxx//xx//xx//xx//xxx Excel Report.xlsx';
ExcelReport.SaveAsExcel(FileNameAndPath);
end;

I have the full access to the network folder and when I run the job queue I am getting below error

‘Either the caller does not have the required permission or the specified path is read-only.’

Please provide a solution or alternate way to save the file in network folder.

Thanks in advance.
Rajaneesh H

Categories:

Dynamics 365 Business Central

Quick Links