Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Generate Pivot Chart in NAV 2013 R2 for the Report.

Posted on by 300

Hi

I created an Export to Excel Report in which I have to generate Pivot Chart simultaneously.

Please suggest how can i do it?

Thanks

Shivendra

*This post is locked for comments

  • Verified answer
    Saurabh Shah Profile Picture
    Saurabh Shah 4,560 on at
    RE: Generate Pivot Chart in NAV 2013 R2 for the Report.

    As i understood correctly, you have created the report which gives you output of your data in excel and you have some pivot created based on it. now the problem is every time your report generates new file so you need to create the pivot based on it or need to copy the data from the report the Pivot excel file.

    simplest solution is too copy the data from your generated report to pivot excel table and refresh the excel sheet.

    another one which is quite complex: when you export the data make provision in report to ask the file name to generate or amend existing so you can give the file name and location and also sheet name so report will overwrite the data into excel.

    you can refer the Account schedule screen

    If you want to create the data input from scratch then you can use ODATA web service and can also follow the suggestion of archer.

    -Saurabh Shah

  • Verified answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Generate Pivot Chart in NAV 2013 R2 for the Report.

    hi,

    use PowerPivot.

    msdn.microsoft.com/.../hh165316(v=nav.71).aspx

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans