# How to Print My Report in Excel

**URL:** <https://www.dynamicsuser.net/t/how-to-print-my-report-in-excel/61067>\
**Category:** User Forum\
**Created:** [July 12, 2016, 8:19pm UTC](https://www.dynamicsuser.net/t/how-to-print-my-report-in-excel/61067 "2016-07-12T20:19:34Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![farrell.okello](https://avatars.discourse-cdn.com/v4/letter/f/9de0a6/32.png) [@farrell.okello](https://www.dynamicsuser.net/u/farrell.okello)\
**Post date:** [July 12, 2016, 8:19pm UTC](https://www.dynamicsuser.net/t/how-to-print-my-report-in-excel/61067/1 "2016-07-12T20:19:34Z")

</div>

Hello incredible Geeks

I need assistance with how I can print and preview my report in excel format thank you very much

---

<div class="post-metadata">

**Author:** ![RockWith](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/rockwith/32/7579_2.png) [@RockWith](https://www.dynamicsuser.net/u/RockWith)\
**Post date:** [July 13, 2016, 12:54am UTC](https://www.dynamicsuser.net/t/how-to-print-my-report-in-excel/61067/2 "2016-07-13T00:54:09Z")

</div>

Hey farrell,

NAV Version??

Till NAV 2009 if you want to Print a Report in Excel then you need to write a custom code in your Report to achieve this.

If you are talking about NAV 2013 and later then there’s an inbuilt feature to export your Report.

For writing custom reports you can take help of standard reports. Excel Buffer Table is the Key.

---

<div class="post-metadata">

**Author:** ![farrell.okello](https://avatars.discourse-cdn.com/v4/letter/f/9de0a6/32.png) [@farrell.okello](https://www.dynamicsuser.net/u/farrell.okello)\
**Post date:** [July 13, 2016, 5:45am UTC](https://www.dynamicsuser.net/t/how-to-print-my-report-in-excel/61067/3 "2016-07-13T05:45:21Z")

</div>

The Version is 2009

---

<div class="post-metadata">

**Author:** ![postsaurav](https://avatars.discourse-cdn.com/v4/letter/p/ba8739/32.png) [@postsaurav](https://www.dynamicsuser.net/u/postsaurav)\
**Post date:** [July 13, 2016, 7:13am UTC](https://www.dynamicsuser.net/t/how-to-print-my-report-in-excel/61067/4 "2016-07-13T07:13:32Z")

</div>

Hi,

In standard NAV 2009 R2 you have a option in Preview mode to save as excel. The option bring the output as previewed in excel.

The other way is to custom export to put data on excel as per your requirement. If you want to use that, refer here Standard Report 120 “Aged Accounts Receivable”.  
Microsoft have included feature to Print To Excel.

Let us know how it goes.

---

<div class="post-metadata">

**Author:** ![farrell.okello](https://avatars.discourse-cdn.com/v4/letter/f/9de0a6/32.png) [@farrell.okello](https://www.dynamicsuser.net/u/farrell.okello)\
**Post date:** [July 13, 2016, 8:02am UTC](https://www.dynamicsuser.net/t/how-to-print-my-report-in-excel/61067/5 "2016-07-13T08:02:20Z")

</div>

Hey  
I got this piece of code here // ----

CREATE(ExcelApp);  
ExcelApp.Visible(TRUE);  
Books:=ExcelApp.Workbooks.Add(-4167);  
Sheets:=Excelapp.ActiveSheet;  
//----

I cant not define variable ExcelApp of type automation i dont seem to see excel as on of the application when i lookup in the globals thankyyou

---

<div class="post-metadata">

**Author:** ![Raja123](https://avatars.discourse-cdn.com/v4/letter/r/278dde/32.png) [@Raja123](https://www.dynamicsuser.net/u/Raja123)\
**Post date:** [July 15, 2016, 8:11am UTC](https://www.dynamicsuser.net/t/how-to-print-my-report-in-excel/61067/6 "2016-07-15T08:11:06Z")

</div>

Are you saying You cant find this variable

 ![Screenshot (66).png](https://us1.discourse-cdn.com/flex023/uploads/dugusers/original/2X/4/49257be64bb96e5082d6853900f35abfc998073f.png)

 ![Screenshot (67).png](https://us1.discourse-cdn.com/flex023/uploads/dugusers/original/2X/1/12ef8203fa133ead5ab374b8bda1adbf9e20a02e.png)

 ![Screenshot (68).png](https://us1.discourse-cdn.com/flex023/uploads/dugusers/original/2X/6/656a703e936b09d9973a7f67213bc1c5966ab38c.png)

For preview Part Whatever said by

# Saurav Dhyani

was right .If You Got Now Follow This [Link](http://beginnersnav.blogspot.in/search/label/Automation) for export to Excel