Skip to main content

NAV 2013 R2 - Multiple Sheets in Excel Using Excel Buffer.

Hi all,

In this article we will see the possibility of having Multiple Excel Sheets Using Excel Buffer Export.

The Article is based on request of Mr. Anand gupta, so all thanks to him for the query.

Most of us know how to export data using excel buffer, but it only contain a single sheet. Now let's consider a scenario where i want to export my customers, vendors and Items from Navision in excel.

So its pretty obvious that i want then in different sheets.


I have made some changes in Excel Buffer table to achieve it, let's go through them first and then we will see how to use them in report.

We have a standard function in Excel Buffer table i.e CreateBookAndOpenExcel. What i did is Created two function from the code that was written in this function. Below are the Two Functions.

  1. Only Create Book
  2. Only Open Excel


Now My Sheet can be create in WriteSheet function of Excel Buffer so i added a piece of Code in WriteSheet Function also as shown below.


Below are some Global Variables added in Excel Buffer.


That it. Lets create a report having three data items customer, Item and vendors.Set Report properties to ProcessingOnly to True.
And Below is the code in Every Data Item Trigger.


Above is the Function To Print all sheets Excel header.

Below is the Function To Print Body for all the masters.



Let's run the Report and See Output.


So we have achieved what we were trying to do - Having Multiple Sheet in Excel using Excel Buffer.

You can download the Objects from my SkyDrive OR Mibuso.

File Name - NAV 2013 R2 - Multiple Sheets in Excel.rar

Hope you like the post, Your comments are much awaited.

Regards,
Saurav Dhyani
www.sauravdhyani.com

Comments

  1. Hi Saurav above drive link is not working could you please reactive it again thank you in advance.

    ReplyDelete
    Replies
    1. Please check now.
      Let me know if any issues.
      Thanks for the comment.

      Delete

Post a Comment

Popular posts from this blog

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------

NAV 2013 R2 - Cumulative update 12 Released.

Hi all, Please find below the details of  Cumulative Update 12 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 Build No. - 38053 Release Date - October, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

Error After Restore SQL Backup of NAV 2013 Database

Hi all, we are facing a conman issue during restoring a SQL Database backup restored for NAV 2013. While Trying to run object from Object Designer we get below listed error (even the service is configured properly) - --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- There are no NAV Server instances available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity. --------------------------- OK    ---------------------------