Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Back UP file RDLs Creation in SSRS 2008 Automatically

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

like image 545
Shubham Jain Avatar asked Jul 31 '09 11:07

Shubham Jain


People also ask

Where are RDL files stored?

rdl files are stored in the Content column of ReportServer. dbo. Catalog.

What is RDL file in SSRS?

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.

How do I import an RDL file into SSRS?

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.


2 Answers

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.

like image 92
Mansi Avatar answered Sep 19 '22 06:09

Mansi


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...

  1. 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">

  1. 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.

like image 27
SherlockSpreadsheets Avatar answered Sep 20 '22 06:09

SherlockSpreadsheets