This is going to be fun. GP 2015 New Feature – Creating refreshable Excel reports based on SmartList Designer queries. Still no Excel based parameters yet. I was promised those in GP 2010.
GP 2015 New Feature – Creating refreshable Excel reports based on SmartList Designer queries. – Microsoft Dynamics GP Community
Reporting & BIGP 2015GP 2010
Archived post from 2014. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.