CODEWITHSUNDEEP
reporting-services
Shubham Jain
Shubham Jain

Reputation: 61

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

Upvotes: 6

Views: 4870

Answers (4)

SherlockSpreadsheets
SherlockSpreadsheets

Reputation: 2370

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.

Upvotes: 3

Siva Karthikeyan
Siva Karthikeyan

Reputation: 554

This is happening whenever there is a change in the namespace of the RDL File. Refer to the URL: http://msdn.microsoft.com/en-us/library/ms143674%28v=sql.105%29.aspx. This is being done to safeguard the interest of the developer unfortunately unable to figure out specific options to stop this in BIDS.

Upvotes: 1

Mansi
Mansi

Reputation: 49

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.

Upvotes: 4

DForck42
DForck42

Reputation: 20367

try takign the physical file and move it out of the folder, delete the copies, then add the file back into the project by going to "Add existing item".

Upvotes: 0

Related Questions