Skip to main content

Save Navision RTC Reports into PDF, Word & Excel..

Hi all,

If you would have noticed with the introdcution of RTC Client in 2009 i.e NAV 2009, in C/AL Symbol Menu Report have some new options.



1. Save as PDF.
2. Save as Excel.



And after release of NAV 2013 There is one more addition to the list.

3. Save as Word.



Let's discuss what is required to use these options as then try to use them.

Requirement -

1) The Report that you are planning to save as PDF/Excel/Word should have RTC Layout Created. (Before NAV 2013)

So let's try this with a standard report Report 206 "Sales - Invoice" with NAV 2013.

I am adding options to Save AS in the Action of The Posted Sales Invoice Page as shown below.



Now i will add code in the all the actions as shown below.



So lets try to use these buttons from RTC.

I opened the Posted Sales invoice page in RTC, and as shown below i see three icons for save as PDF. save as word & save as excel.



As soon as i clicked on all these icons below is the output on my D Drive.



Here is how the output looks.



* Remember these functions will overwrite the file with same name in same location if any.

Future Customization (What i can think, you might add to this) -

a) Path can be setup based.
b) File name can be document Number.
c) Report No. can also be setup based.
d) This can be in one single button to save in all three formats.
e) You can automate it Via NAS.

I hope you will use these post for customization like sending reports to client in PDF/Word/Excel Format.

If Required download modified Page for NAV 2013 IN Version from my skydrive.

Regards,
Saurav Dhyani
saurav-nav.blogspot.in

Comments

  1. Replies
    1. @Vicky,
      Do you want to specify the file name during Save as Option is clicked by user?

      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    ---------------------------