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

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Rajasekhar@MS 5,569 on at

Like (0)

Report

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/

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

You can use job queue for schedeuling the report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

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

Was this reply helpful? Yes No