Sunday, July 31, 2016

Report Scheduler - Server Side Report Processing

Hello Friends,

NAV use the RDLC reports and it was taken more time when there was usage amount of data.
Reason is that - 
it is client side reporting tool and system has download all the data on client machine (RAM).

Some time it was giving "Out of memory" exception because client computer doesn't have enough RAM space to store data for report.

Customer are always complaining us that system is taking so much time to generate reports output. (some time taking more than 3-4 hours)

IN NAV 2015/2016 version we can use the Report Schedule functionality to generate any report on server side using scheduler.
It was working very fast compare to old method and doesn't give "out of memory exception"


Steps to generate report using Scheduler:

1) Run the Report & Select the applicable value on Request Page






































2) Goto “Print” & “Schedule” 







































3) Select the Report Output & Earlier Start Time




















4) System will automatic create one temporary job queue entry and start it as per define schedule time
















5) Once the report process completed – system will create new notification entry on role center page – New entry created in your Report Inbox
























6) You can open the report output by click on “Show” button



















7) Report Output on your screen























I hope this value help you in future.
Thank you for reading

Keep Sharing...Keep Growing...

1 comment:

  1. Hello,

    thanks for the Infos.

    Sadly, this seems to work only when the user has SUPER-Permissions.
    The Users cant use this functionality with normal permissions, even if given explicit permission to run the report.

    Or maybe I am missing some crucial permissions, but there's no information on the web about that...

    ReplyDelete