Visual Studio 2022 reporting services designer hangs when "opening the file"

paulofj 55

Hi Folks!

My IDE (Visual Studio 2022) is hanging while try to open .rdl files. The extension Microsoft Reporting Services Projects 2022 was installed correctly but can't achieve to show the designer interface; the popup "Opening the file" remains forever. New files .rdl also fails to open.

Thanks in advance!

Ledbetter, Derek 15 Reputation points

2023-03-23T15:07:49.7733333+00:00

I've uninstalled many times. There is only one community edition and it appears it broke when the updates were made. I did have it working at one time. Unfortunately, I can't remember the version. I think it was 17.1. However, testing for my company, the other teammates had to load and it was a more recent edition.

I currently am reinstalling everything again.

3/23/2023 11:26 ET

Just finished reinstalling the latest version 17.5.3 and the Reporting services (found in marketplace). Opened the .sln and it shows "incompatible". right click, "load all projects" and they appear. Double click on one of the .rdl and it hangs still.
Ledbetter, Derek 15 Reputation points

2023-03-24T13:20:52.6333333+00:00

Update 3/24/2023.

Teammate updated to 17.5.3 using "installer". used the Marketplace (integration services and reporting services) - tried to open a .sln. Did a "rebuild solution" and tried to open a .rdl. It shows "opening the file" and hangs.
Aaron Cooper 5 Reputation points

2023-05-16T16:03:05.32+00:00

What worked for me was creating a new reporting project (in a new solution), created a new report. That initial report hit CPU hard for <1 minute and then it loaded. After that, closing/re-opening the report was quick, closing/re-opening Visual Studio 2022 and the rdl was quick. And opening my existing SSRS projects was quick.

Seems like there's something that has to be loaded the first time you open an RDL file.

Accepted answer

Anna Xiu-MSFT 30,021 Reputation points Microsoft Vendor

2023-03-17T03:08:09.2766667+00:00
Hi @paulofj,

Welcome to Microsoft Q&A!

Please try the following workarounds:

Update your Visual Studio 2022 to the latest version with Visual Studio Installer.

Reinstall the extension: Microsoft Reporting Services Projects 2022.

Disable or uninstall the installed third-party extensions under Extensions > Manage Extensions > Installed.

Create a new project and check if the designer can be opened normally.

Sincerely,

Anna

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.

4 people found this answer helpful.
paulofj 55 Reputation points

2023-03-17T14:01:13.0166667+00:00

Edited below...

paulofj 55 Reputation points

2023-03-17T14:47:15.6266667+00:00

Dear Anna,

Your suggestion worked fine: I created a new project and the report designer runs ok when I tried to create a new report. Thanks a lot, but...

Additionaly, I would like to utilize legacy projects (VS 2019) and its report files .rdl. Any tip?

paulofj 55 Reputation points

2023-03-17T19:03:43.2433333+00:00

This solved the problem:

Replace on xml file (.rdl): <Report MustUnderstand="df" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:df="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition/defaultfontfamily">

By: <Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition" xmlns:df="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition/defaultfontfamily" MustUnderstand="df">

Thans very much Anna.

Ledbetter, Derek 15 Reputation points

2023-03-24T13:27:37.5933333+00:00

Following the "Add new report" first, loads the toolbox. Then, it appears the existing ones will open.

Doug Clavell - UIDC - IT Database Admin/Developer 0 Reputation points

2023-06-13T22:30:19.7666667+00:00

Worked like a champ.

Thanx, Anna!

Doug
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Visual Studio 2022 reporting services designer hangs when "opening the file"

0 additional answers

Your answer