Weekly Dynamic: Portable Excel Reports, the Best of Both Worlds Part 2

Reporting & BI Tips & Hidden Features Excel & Office

Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.

Last week we looked at how to create a refreshable Excel report using ODBC connections to Dynamics GP. This week we will look at how to make it portable.

Open the Excel file from last week.
Pick Data | Properties | Definition
Click Export Connection File and save the file.

Now the Excel file and the connection file can be sent together to provide a portable Excel file with built in parameters.

Original article: https://www.packtpub.com/application-development/microsoft-dynamics-gp-2010-cookbook