Back UP RDLs Files Creation in SSRS 2008 Automatically when we save it. Can we resolve this ?
Like if there is report which name is AssetAmount.rdl
so when we updated it and save it then there is an autogenerated Rdl created as
AssetAmount-BackUP.rdl AssetAmount-.rdl so there are two rdls files in a same folder
rdl files are stored in the Content column of ReportServer. dbo. Catalog.
Report Definition Language (RDL) is an XML representation of a SQL Server Reporting Services report definition. A report definition contains data retrieval and layout information for a report. RDL is composed of XML elements that match an XML grammar created for Reporting Services.
By Uploading RDL file in Report Server.Open SSRS Server from webportal URL. There, you will see the upload button. Click the upload option and browse the rdl file of the report from the location. It uploads your report to the report server.
If the rdl version was in previous version say SSRS 2005 and now the rdl is accessed into SSRS 2008, the back up file is created while the report is upgraded. once the report is upgraded, delete the backup files and then onwards no backup files would be created.
It took a while for me to notice that it was an issue for only the 2010 XML schema reports in my project. Changing the <Report xmlns>
tag to 2016 fixed the automatic backup file duplication. And the report seemed to work just fine afterward too.
My post on this topic: Visual Studio SSRS RDL Files creating a new file (backup) when opened
VS open > right-click report > View Code > modify [Report xmlns] node > Save file...
- FileThatKeepsDuplicating.rdl
ORIGINAL:
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
NEW:
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
- Repeat for all problem files with 2010 schema
You can open your files normally agian. File backup duplication is resolved.
I am not sure why this fixes it. If anyone has anymore information, that would be great.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With