Export to excel

sbolton1855

Why does it seem that Microsoft made it so difficult to exports in to excel from NAV? I have been using SSRS reports for a long time now and really enjoy exporting to many formats on the fly.
I have a report that i am re coding to excel because i an not able to find a good excel tutorial with NAV.
The C/AL Symbol Menu was used for two fields in the report <Item. "Job Qty Remaining"> and <"Qty. on Planning Lines"> can anyone tell me what tables/fields these are in NAV. Or point me to a good step by step walk thru for excel exporting
thanks in advance

Savatage

Some demo's here:
http://dynamicsuser.net/forums/p/25998/140880.aspx

sbolton1855

](*,) ](*,) ](*,) ](*,) ](*,) ](*,) ](*,) ](*,)

Savatage

did you follow the post ?
http://savatage99.googlepages.com/Excel ... ummies.doc

there are also export & import stuff in the download section of mibuso

sbolton1855

Yes this looks like the step by step that my brain needs to understand with the comments!! I somehow did not see that post on the forum the first run thru..... :idea:

Savatage

yes, revisit that first post - if you scroll thru "the entire" post you will also see other links to other examples

Savatage

when you run your report you can file->export to HTML then open the html file in excel too.

if you need data from tables there are many "export to excel" options in the download section of mibuso

if you don't want to use the excel buffer.

David_Singleton

sbolton1855 wrote:

Why does it seem that Microsoft made it so difficult to exports in to excel from NAV? I have been using SSRS reports for a long time now and really enjoy exporting to many formats on the fly.
I have a report that i am re coding to excel because i an not able to find a good excel tutorial with NAV.

rohan16 wrote:

Why does it seem that Microsoft prefabricated it so stubborn to exports in to excel from NAV? I tally been using SSRS reports for a long case now and truly like commercialism to numerous formats on the fly.
I possess a interrogatory that i am re coding to surpass because i an not healthy to maturate a intellectual surpass tutorial with NAV.

This is interesting.

Obviously it wont work here, since people are actively reading posts, but as it matures this will develop into a pretty smart way to spam. They can use the thesaurus to make each spam post slightly different and thus avoid the pattern recognition sites.