Home » Listing Details
Top Websites
  1. Dynamics GP Help
    Over 6300 resources listed.
  2. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  3. Rose Business Solutions Blog New
    Over 2200 resources listed.
  4. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 1100 resources listed.
  5. Mariano Gomez at The Dynamics GP Blogster
    Over 1000 resources listed.
  6. Microsoft Dynamics Partner Community Blog
    Over 900 resources listed.
  7. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 700 resources listed.
  8. Mohammad Daoud's Dynamics GP Blog
    Over 600 resources listed.
  9. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 500 resources listed.
  10. Inside Microsoft Dynamics GP Official Blog
    Over 500 resources listed.
  11. eOne Business Solutions Blog
    Over 400 resources listed.
  12. About Dynamics, Development and Life
    Over 300 resources listed.
  13. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  14. Dynamics CPM
    Over 300 resources listed.
  15. BKD Dynamics GP Insights Blog
    Over 200 resources listed.
  16. Leslie Vail at Dynamics Confessor Blogspot
    Over 200 resources listed.
  17. Victoria Yudin's Dynamics GP Website
    Over 200 resources listed.
    Victoria Yudin
  18. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  19. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  20. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.

Title:Weekly Dynamic:Excel Reports in Dynamics GP 10
Description:The new Excel reports in Dynamics GP 10 are really pretty cool and you don't need MOSS 2007 to play with them. You can use a network share to let your organization do a little Excel reporting.

To setup the default reports you need to do 2 things, deploy the connector and deploy the reports. Here's how:

In GP 10 pick Microsoft Dynamics GP-Tools-Setup-System-Reporting Tools Setup. Enter the system password if required.

Pick the Data Connections Tab

In the System Level Data connections box enter a shared network location to deploy the connectors to.

Do the same thing for the User Level Data connections. This can be a local directory.

Check Enable Data Connection Deployment. Check Deploy Data Connections for all existing companies if you want to run Excel reports off all your companies. Otherwise, when you deploy, you'll have to pick a company.

Click Run Deployment

Print or Cancel any reports and move to the Reports Library Tab.

Fill out the same type of information, Network location to deploy shared reports, local location for user reports, check the enable box and if you want to deploy for all companies, check the Deploy box.

Click the Run Deployment button. Print or cancel any reports.

You're done, now what?

You can navigate to the shared location from the Reports Library Tab and open one of the Excel reports. Even better from within Dynamics GP, go to the Navigation Pane on the lower left and pick Administration or the Administration tab. Click on Other Reports and wait for them to load.

Pick a report and double click it. The report opens nicely (and quickly in Excel). You may need to enable data connections. If a box pops up, enable data connections and go on.

In Excel 2007 the report shades every other row and provides filter handles on each column.
That's enough to let you play with it a little. I'll have more on GP 10's Excel reports and the cool things you can do with the connectors later.
Category:OFFICE INTEGRATION: Excel with GP
Link Owner:
Date Added:June 21, 2010 06:11:17 PM
Number Hits:93
RatingsAverage rating: (0 votes)

No Reviews Yet.


Thank you for your support for GPWindow. It helps us cover part of the hosting costs for GPWindow.