Forum Discussion
SQL Server Reporting Services - Visual Studio Compatibility
Let me preface this with some details. I wrote a report in SQL Server Reporting Services under and old version using the SSRS Design Manager some years ago. I am now running that report in SQL Serv...
JulianePadrao
Microsoft
MicrosoftHave you tried to use SQL Server Data Tools (SSDT) for SQL Server Reporting Services (SSRS) instead of using Visual Studio 2022 Community Edition with the Reporting Services Add-in? SSDT is specifically designed for SSRS development and provides better compatibility with the SSRS environment.
Also, it seems a compatibility issue, so ensure that the report is using the correct compatibility level for SQL Server 2019. You can check and set the compatibility level by opening the report in Visual Studio and navigating to the "Report" menu. Then go to "Report Properties" and check the "TargetServerVersion" and "TargetServerURL" properties.
If none of this work, check the error logs on the SSRS server for more detailed information about the deployment error. The error message you provided ("Error The definition of the report '\B_v_A_Custom.rdl' is invalid") is generic and may not provide sufficient information to pinpoint the exact issue.
Hope that helps!
Also, it seems a compatibility issue, so ensure that the report is using the correct compatibility level for SQL Server 2019. You can check and set the compatibility level by opening the report in Visual Studio and navigating to the "Report" menu. Then go to "Report Properties" and check the "TargetServerVersion" and "TargetServerURL" properties.
If none of this work, check the error logs on the SSRS server for more detailed information about the deployment error. The error message you provided ("Error The definition of the report '\B_v_A_Custom.rdl' is invalid") is generic and may not provide sufficient information to pinpoint the exact issue.
Hope that helps!
- It is SQL Server Data Tools that I'm using. As of SSRS 2019, the SSDT is a Visual Studio add-in and not a standalone application.
https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver16
As I mentioned, the odd thing is that I can deploy the old report unaltered. But once I try to make changes to it, then I get the error in Deployment. But I will check the compatibility issue in case there is something odd going on there.
