Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Unanswered

Excel-layouts lost data connection after version update!

(0) ShareShare
ReportReport
Posted on by 144

Hi,

we have created over 50 Excel layout reports under BC 20.x OnPrem, which all worked fine. After the update to BC 21.6 OnPrem, we noticed that the reports were not updated when they were called. There was no error message, but the data table is empty (more precisely, the data table only contains the data that was contained in the last Excel layout save) and i found no Data-Connection.

After some experimenting we found a workaround:

  1. In Page 9660 we clicked on "Edit Info" in the reports. Here comes the message: It is not possible to modify the layout ... because it is provided by an extension ... Do you want to edit a copy of the layout instead?"
  2. Here we clicked on "Yes" and thus created a copy of the layout.
    If I now click on "Run Report" here, the Excel file is downloaded and the data has been updated as desired.
  3. So I downloaded the copy via "Export Layout".
  4. I then used the copy to overwrite the old Excel layout in the APP and then republished the APP. After that, the original report was updated again when it was run.
  5. Then I deleted the copies on page 9660 again.

This looks like a BUG to me!?
Even if I found a workaround for myself here, I naturally ask myself whether this will happen again with the next update and whether it is a BUG or whether something in our environment is not OK?

Can any of you reproduce this?

greeting
Ralf

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,622 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans