Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Excel Report Builder y...
Microsoft Dynamics GP (Archived)

Excel Report Builder yields NO data

(0) ShareShare
ReportReport
Posted on by BC 640

I build a report in Excel Report Builder. Publish to Report Library (or a file for that matter). i launch the report from the GP>Admin>other reports. the workshhet opens with a message at the top of the worksheet: Security Warning - Data Connections have been disabled. I click on the option and enable the connection, but still no data. the only change to the sheet is that the headings change to the actual table heading name but no data. i suspect i have an issue with excel security settings but cant figuer out where.Any Ideas?

thanks

BC

*This post is locked for comments

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Re: Re: Excel Report Builder yields NO data

    Check the restrictions, or the data tables and their links.  Try a simple report first (one table, a few fields, no restrictions) and make that work.  Then add pieces one by one until data stops flowing.

  • BC Profile Picture
    BC 640 on at
    Re: Re: Excel Report Builder yields NO data

    Hello Richard,

    I did follow your instructions above, however you are correct in your suspicion that there may be something else keeping the data off the report. Any idea what I can go to troubleshoot from this point forward?

    BC

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Excel Report Builder yields NO data

    Yes, there is a security problem that is easy to fix but I suspect you have something else keeping data off your report.  Once you enable the data connections for this run, the data should appear.

    To fix the security problem permanently...

    Open Excel. Click on the Office Button to open the Office Menu.

    Click Excel Options at the bottom of the menu to open the Excel Options window.

    Select Trust Center in the left panel to show Trust Center options. Click on the Trust Center Settings button in the bottom right of the window.

    In the Trust Center window, click on External Content in the left pane. In the right pane, click the Enable All Data Connections option in the Security Settings for Data Connections area.

    Click OK to close the window. Click OK again to close the Excel Options window. The setting is retained and the warning message will not be displayed.

     

    This is from our soon to be released book, Customizing GP with The Builders that covers SmartList Builder, Excel Report Builder, and the Navigation List Builder.  Watch for it on our web site mid January.

    As for the data, once the security is fixed, check your restrictions and table relationships.  Post back what you find and we will try to help more.

     

    Merry Christmas to all.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans