The best way to create automated NAVreport with excel export

Comments

• postsaurav Member Posts: 708

  2015-08-11

  Hi,
  
  There are two things that you need to do -
  
  1. Setup NAS for Automatic execution of the Report. You can refer some article under section - NAS AND JOB QUEUE in below link.
  http://saurav-nav.blogspot.in/2013/10/table-of-index-for-articles-nas-email.html
  
  Once the NAS is setup and Job Queue Start Running you need to work on second part.
  
  2. Export to Excel Reports have pop up for showing the progress of Export. These Pop up comes from Table 370 Excel Buffer. You Should block these pop ups based on some condition. Any Pop up windows are not supported by NAS like - Message, Error, Window..
  
  Hope you understand what I meant. Let me know if still any doubts.

  ---

  Thanks & Regards,
  Saurav Dhyani
  
  Do you Know this About NAV?
  
  
  Connect - Twitter | Facebook | Google + | YouTube
  
  Follow - Blog | Facebook Page | Google + Page
  

  0
• Bili_Piton Member Posts: 1

  2015-08-12

  Hello !
  
  Report logic should be transfered in SQL View. EXCEL can be directly connected to SQL database (View) and started via scheduler.
  But in my opinion it would be better and easier to use various bi tools for Dynamics NAV. There are a lot of good products in the market i personally use BIView solutions i found it easy to use and SME affordable. \:D/

  0