Report Builder - Refreshing Report dialogue hung up

[Jeremy_Brugger]

Issue: Report Builder - Refreshing Report dialogue box stays open after reports are properly refreshed which leads to end-user confusion.

Scenario:

• Running the following vba code:

• The macro finishes and the data is clearly updated as expected... however the dialogue box (below) persists

                   

Is there something I can add to the vba to force quit this upon success?

Thanks in advance

[Gigazelle]

Does this error occur when you're working on a fresh workbook? Just trying to nail down the scope of this issue.

[Jeremy_Brugger]

There are some unrelated ODBC connections and a couple tabs. Nothing that should directly impact this macro functionality, though.

[Gigazelle]

Does it specifically work in a fresh workbook though? Determining if it's workbook-specific, macro-specific or machine-specific will provide a lot of headway into determining what the root cause of the issue is.

[Jeremy_Brugger]

Refresh works if I manually use the button in the ribbon and/or right-click within the data set to refresh. It's just when the above vba code is called via Macro that it hangs.

[Gigazelle · Accepted solution]

That's basically a copy/paste of the code from our VBA KB article, so if the dialogue isn't going away and you're on the latest version of Report Builder, I'd recommend creating a ticket with customer care with exact steps to reproduce so the agent can clearly see the issue on their machine. Once that happens, we can get it to our engineering team for a fix. Thanks!