SQL Server Reporting Services 2019

Question

Hi,

Apologies if this issue has already been raised.
We are currently upgrading our instance of reporting services from 2016 to 2019.
An issue we have found is that we are unable to access report settings for paginated reports with an apostrophe in the name.
An error box appears which says - An Error has occurred - something went wrong. Please try again later
This doesn't look to have been an issue on the previous 2016 version and on the previous version we could save folders on the portal with these in place.
Is there anything we can do to overcome this without having to change lots of report names?

Many Thanks,

Dan

Answer 1

Hi @Dan Trayton

I think in SSRS 2019 report name with apostrophe is not allowed.
You can change the name by using below code to change the report name and path in the table (dbo.Catalog),I have tested it,it works fine.

use ReportServer  
update dbo.Catalog set Path = '/aa' , Name = 'aa' where ItemID ='94A4A074-82B3-4E3A-BFC0-54D3BD5CF566 '  
  
select * from dbo.Catalog  

Best Regards,
Isabella