Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Command line to save reports

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    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 Profile Picture
    Suresh Kulla 43,749 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    RE: Command line to save reports

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Amol Salvi 18,694 on at
    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 Profile Picture
    Rajasekhar@MS 5,567 on at
    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 Profile Picture
    Suresh Kulla 43,749 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Suresh Kulla 43,749 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans