Dynamics Community Forum Thread Details

Excel-layouts lost data connection after version update!

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:

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?"
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.
So I downloaded the copy via "Export Layout".
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.
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

Quick Links

Leaderboard