Command line to save reports

(0) Share

Report

Posted on by Community Member

I am looking for an option to run reports overnight within batch file and save it to a folder; so users can look over next day. Even, I would like to archive these save report over month end.

With following command I can run the report but don't know to save in pdf or excel format: We are on Nav 2013R2

DynamicsNAV:////runreport?report=

Thanks for helping me.

*This post is locked for comments

All responses (9)

Answers (0)

Suggested answer

Maneesha 5,891 on at

Like (0)

Report

RE: Command line to save reports

MukeshDubey ,

I don't think every report can be scheduled (we don't know what is your report name is)

But if you have enough permission to access DB , You can do it easily with using SQL Server
Suggested answer

Suresh Kulla 47,789 on at

Like (0)

Report

RE: Command line to save reports

You can create one single codeunit and and schedule that in Job Queue to do the same instead of command line. I don't think there is a way to save the report to PDF using the command line. In my first reply I provided a link how to do that, you need to create that function and schedule the codeunit in job queue.
Community Member on at

Like (0)

Report

RE: Command line to save reports

We are on NAV 2013 R2 and looking to create schedule reports.
Community Member on at

Like (0)

Report

RE: Command line to save reports

Amol, Thanks for guidelines. I am thinking to write a batch file/script with command line parameters. In batch file, I would like to have multiple reports, which can be saved over network drive. This batch will run over night using Windows scheduler. So users can see these reports next day.
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

RE: Command line to save reports

You can use job queue for schedeuling the report

I think you are thinking of using windows schedular to run the report isnt it?
Suggested answer

Rajasekhar@MS 5,569 on at

Like (0)

Report

RE: Command line to save reports

Hi

NAV 2015 offers an easy way to run and schedule reports Scheduling Reports, you don't need to do any customizations needs configuration on NAV, refer the below on how to configure.

https://totovic.com/2014/09/17/report-scheduling-in-nav-2015/

http://clientsfirst-tx.com/schedule-reports-microsoft-dynamics-nav-2015/
Suggested answer

Suresh Kulla 47,789 on at

Like (0)

Report

RE: Command line to save reports

Do you want to run the above command from command line and want to save the report as PDF ?
Community Member on at

Like (0)

Report

RE: Command line to save reports

Hi Suresh, Thanks for the quick response. Can you provide an example/ command to save DynamicsNAV:////runreport?report= format.
Suggested answer

Suresh Kulla 47,789 on at

Like (0)

Report

RE: Command line to save reports

Check this post

saurav-nav.blogspot.com/.../save-navision-rtc-reports-into-pdf-word.html

Navision already have the function to save the report as PDF, if you want to execute outside NAV and then publish a codeunit with the function as webservice and consume it to execute the code.