Back

Publish To Reports Library not available for Excel Report Publishing

Published: Oct 30, 2024
Post Author Written by Pat Roth

If you’d rather watch a video explaining this, click here.

Our company uses Excel Report Builder heavily but after updating Microsoft Dynamics GP to a newer version, we find that when publishing a new Excel Report Builder report – the “Reports Library” is no longer an option, only “SharePoint” and “File”. Is that not a feature in this version of Microsoft Dynamics GP and SmartList BUilder?

ERB Reports Library 1

There shouldn’t be any differences in this functionality between versions of SmartList Builder and this option isn’t a “Setup Option” in Excel Report Builder – instead the options comes from a Dynamics GP Setup window.

To setup the Reports Libary option, navigate to the Reporting Tools Setup window by using Tools | Setup | System | Reporting Tools Setup menu.

ERB Reports Library 2

Select the Excel tab and set the Location dropdown to be “Network Location” and enter the Reports Directory to the network location where the Reports Library is located.

Once this path is set up, going back to the Publish Reports window, the “Reports Library” will again be an option.

ERB Reports Library 3

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.