12 Jul’19

Dynamics NAVHow to Run Reports when report processing takes long to cause Session Time-out

Introduction:
I’ve observed that when NAV is used for a very long time, the report which needs heavy processing takes long enough to cause Session Time-out. So, fetching reports becomes tedious by manually querying the table.


Pre-requisites:
Microsoft Dynamics NAV
Microsoft Dynamics Business Central


Solution:
The solution is simple, export the Report as an Excel or PDF depending on the data and send Email to the User as an attachment after the processing is complete.Code:
1. Create the Report in Excel Using Excel Buffer.

2. Export the Excel Buffer contents to an XLSX file.

3. Email the Exported Files to appropriate User. In this case, I have hard coded the user email to my email.

Output:

Exporting Progress of Excel Worksheet

 

Exported Intermediate file to be emailed
Email received after the report is completely exported.

Conclusion:
Thus adding a piece of code to send email to the User, can save a lot of hassle. In Business Central, however, it is not possible to modify an existing report. So, you need to export the existing report and merge it in AL using Text-To-Al.

Written by

Olister Rumao

Software Engineer

Leave a Reply

Your email address will not be published. Required fields are marked *

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • POS Receipts printing, Device connectivity issues in Microsoft D365 For Retail

    16 September’ 2019

    Activating/installing POS on a new system is a straight forward process. However what I have noticed on several occasion...

    Read more
  • Using For Each Loop in SSIS for Invoice Integration from SQL Server to Microsoft D365 Sales Using KingswaySoft Connector for CRM: Part 1

    12 September’ 2019

    Part 1/4: Using FOR EACH Loop with KingswaySoft Connector for CRM Invoice Integration. Introduction: The SSIS ForEach Lo...

    Read more
  • Using For Each Loop in SSIS for Invoice Integration from SQL Server to Microsoft D365 Sales Using KingswaySoft Connector for CRM: Part 2

    12 September’ 2019

    Phase 2/4: SSIS Integration Map for Invoice Header from SQL Server to Microsoft CRM: The Map after Completion will look ...

    Read more
  • Using For Each Loop in SSIS for Invoice Integration from SQL Server to Microsoft D365 Sales Using KingswaySoft Connector for CRM: Part 3

    12 September’ 2019

    Part 3/4 SSIS Integration Map for Invoice Details from SQL Server to Microsoft CRM Step 1: Add a DFT to Integrate the In...

    Read more
  • Using For Each Loop in SSIS for Invoice Integration from SQL Server to Microsoft D365 Sales Using KingswaySoft Connector for CRM: Part 4

    12 September’ 2019

    Part 4/4 Delete Logic for Invoice in case of Incomplete Integration of Invoice details Logic Introduction: To handle the...

    Read more
  • We respect your privacy.
  • This field is for validation purposes and should be left unchanged.