question

DanTrayton-9059 avatar image
0 Votes"
DanTrayton-9059 asked IsabellaZhangMSFT-7746 edited

SQL Server Reporting Services 2019

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

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

IsabellaZhangMSFT-7746 avatar image
0 Votes"
IsabellaZhangMSFT-7746 answered IsabellaZhangMSFT-7746 edited

Hi @DanTrayton-9059

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

198068-image.png
198111-image.png


Best Regards,
Isabella



image.png (7.1 KiB)
image.png (17.7 KiB)
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.