Export Report in Excel Format

arnavchander

Hi.
How to create report...when i click on preview it should view and export the report in excel format.
I am using..NAV4.0.
??

rsfairbanks

have you tried this?

search.php

arnavchander

Thanks..I've searched bt i am not able to find out the step by step instruction as I am a begninger... :-k

rsfairbanks

I presume you are an end user.
Try following report 29.

Start with the excel buffer table (as temporary table)
Populate the table with the function entercell
use function openbook or createbook
Use function createsheet
use function GiveUseControl

There are numerous examples in the search. After you understand this you can learn how the functions operate.