Microsoft CRM Report Export to Excel Pivot Tables

Posted on 2009-12-16
Last Modified: 2013-12-11
I've created a Custom Report in MS CRM 4.0 using the Report Wizard. I had to export this report in Excel and make a pivot table. So far so good. It was easy.

My goal is to create a pivot table that would update itself everytime data is changed in CRM. The CRM to Excel update functionality won't work. What would the best option? Recored a macro? VB code? Any other options?

Please note that pivot table data is not coming direct from CRM. Its first being printed in a report and then exported to excel.
Question by:CRM_Guru
    LVL 10

    Accepted Solution

    Do you have to generate the data in a Report?  Could you use Advanced Find to get at the data instead?  If so, then Advanced Find has the ability to export to a dynamic excel sheet that updates automatically.  You can then create your pivot table from there.

    Another option if you are comfortable with DSNs and sql is to create an sql script that assembles the data for you and then use the External Data/MS Query type functionality in Excel to pull the data in.  You can even do this as the source for your pivot table without going to tabular data first.

    Author Closing Comment

    Advanced Find works for me, Thanks!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
    If you need to import sales transactions from another system into Microsoft Dynamics GP as Sales Order Invoices, you may need to store some additional data related to the customer, the transaction, or the line items.  Even if your company is manuall…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now