88354

Visual Studio SSRS RDL Files creating a new file (backup) when opened

Question:

In VS I have a Solution file with SSRS Project. Within the project there are 8 RDL files. I am experiencing an issue when I open a file that it opens with an asterik (*) and upon closing the window it prompts that I save the file. Then I went to the folder in Windows Explorer, at which time I noticed that Visual Studio was creating new files every time I open the file-- <%FileName%>, <%FileName%- Backup>, <%FileName%- Backup (#)>, <....>.

This is wierd. Even wierder, the automatical file is created only for 4 of the RDL files in the Project (8 files in total). Four files are always creating new backup files; and four files are acting normal.

<blockquote>

Does anyone know what is causing the files to automatically create backups?

</blockquote>

I checked the <strong>VS File Properties</strong> (<em>there is not much to see: FileName and Location</em>). I also checked the <strong>File Explorer Properties</strong> (<em>it is not Read Only</em>). My Project Folder <strong>TargetServerVersion</strong> is SQL Server 2016 or later. The RDL files were downloaded from 2008 SSRS report server. I compared the tags for all the RPT files, after I found this SO thread (<a href="https://stackoverflow.com/questions/36071175/can-i-control-the-version-of-new-ssdt-reports-in-visual-studio" rel="nofollow">Can I control the version of new SSDT reports in Visual Studio?</a>).

Problem files... (all say 2010) * Daily Yum Products Daily Traffic Report.rdl <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> * Load Planning Worksheet.rdl <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> * Temporary Employees.rdl <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> * Weekly Yum Products Daily Traffic Report.rdl <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> Working files... (some 2008, some 2016) * BoJangles Data Export.rdl <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> * Load Comment Report.rdl <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> * OnBase Upload_AP Invoice Validation.rdl <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> * ScannedProduction.rdl <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> Problem files (BACKUP COPY CREATED)... * Daily Yum Products Daily Traffic Report.rdl <Report xmlns> all look the same as the original problem file

Other references:

I read this SO question but it's about a Project File not an RDL File: <a href="https://stackoverflow.com/questions/6514458/visual-studio-keeps-asking-to-save-project-file-as" rel="nofollow">visual studio keeps asking to save project file as</a>.

Here is a screenshot of File Explorer and the VS Project RDL.

<a href="https://i.stack.imgur.com/4Ebm3.png" rel="nofollow"><img alt="enter image description here" class="b-lazy" data-src="https://i.stack.imgur.com/4Ebm3.png" data-original="https://i.stack.imgur.com/4Ebm3.png" src="https://etrip.eimg.top/images/2019/05/07/timg.gif" /></a>

======================

<strong>UPDATE</strong>: I even tried deleting and re-adding the files. The problem persists for the same 4 files; The other 4 files still work correctly. The files are in version control, so I tried this... delete files/ commit/ re-add the files/ commit/ tested opening the file/ Backup file auto created (still).

Removing RDL file that keep asking me to save...

Move these files FROM HERE... C:\Users\myUser\Documents\Visual Studio 2015\Projects\SSRS\Project_ssrs2016\Decommissioned-2\ TO HERE... C:\Users\myUser\Downloads\Decommissioned-2 (backup)\ DELETED FILES FROM PROJECT * Daily Yum Products Daily Traffic Report.rdl * Load Planning Worksheet.rdl * Temporary Employees.rdl * Weekly Yum Products Daily Traffic Report.rdl

Re-Adding RDL file that keep asking me to save...

Move these files FROM HERE... C:\Users\myUser\Downloads\Decommissioned-2 (backup)\ TO HERE... C:\Users\myUser\Documents\Visual Studio 2015\Projects\SSRS\Project_ssrs2016\Decommissioned-2\ ADDED FILES TO PROJECT * Daily Yum Products Daily Traffic Report.rdl * Load Planning Worksheet.rdl * Temporary Employees.rdl * Weekly Yum Products Daily Traffic Report.rdl

===========================

Answer1:

This problem was finally solved by editing the RDL file tag for all the problems files from the 2010 to 2016 Report XML schema. I did as follows: (in VS) > right-click report > View Code > Paste the 2016 > Save.

1) Daily Yum Products Daily Traffic Report.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"> 2) Repeated for all problem files with 2010 schema 3) Repeated for all problem files with 2010 schema 4) Repeated for all problem files with 2010 schema * Auto Save issue is resolved.

I think what was causing the Backup Files to be created had something to do with a Visual Studio detecting a conflict in the Project TargetServerVersion and the RDL XML Schema. Not sure why 2008 file works and 2010 doesn't work; regardless I left the 2008 as they were.

These SO posts had some helpful answers.

<a href="https://stackoverflow.com/questions/36071175/can-i-control-the-version-of-new-ssdt-reports-in-visual-studio" rel="nofollow">Can I control the version of new SSDT reports in Visual Studio?</a>

<a href="https://stackoverflow.com/questions/1212100/back-up-file-rdls-creation-in-ssrs-2008-automatically" rel="nofollow">Back UP file RDLs Creation in SSRS 2008 Automatically</a>

Recommend

  • adding i2c client devices on x86_64
  • Getting error running SSIS package on non-SSIS Server [duplicate]
  • Custom templates for SSDT
  • How to Get Total Page Count for a Report Using CrystalReportViewer?
  • How to load space separate file into pandas dataframe?
  • how to replace string in SpEL expression?
  • What is the point of MESI on Intel 64 and IA-32
  • Building SSIS solution using visual studio online build definition… .dtproj is not supported by MSBu
  • Submitting a Hadoop job
  • How to merge two tables and transpose rows to columns
  • why isn't the natural height of a Frame updated immediately?
  • Adding new column to DataFrame with values dependent on index ref
  • Safari PHP form submission -file upload hangs
  • Extracting individual digits from a float
  • How to make SASS put relative paths in its output
  • MySQL multiple IN conditions to subquery with same table
  • Classic ASP URL Rewriting
  • AWS-SES: Handling Bounces for Invalid ISPs
  • Is it possible to get the word under the mouse cursor in a ``?
  • using html data-attributes as css-variable (i.e. text-shadow)
  • BeautifulSoup difference between findAll and findChildren
  • NHibernate manually control fetching
  • How to determine if there are bytes available to be read from boost:asio:serial_port
  • Unity3D & Android: Difference between “UnityMain” and “main” threads?
  • Nant, Vault & Windows Integrated Authentication
  • Spray.io: When (not) to use non-blocking route handling?
  • Is there a amazon webstore API for customers?
  • Bug in WPF DataGrid
  • Resize panoramic image to fixed size
  • Volusion's generic SQL folder, functionality
  • How to extract text from Word files using C#?
  • Deserializing XML into class C#
  • jQuery tmpl and DataLink beta
  • How can I estimate amount of memory left with calling System.gc()?
  • Hibernate gives error error as “Access to DialectResolutionInfo cannot be null when 'hibernate.
  • How to include full .NET prerequisite for Wix Burn installer
  • How do you join a server to an Active Directory (domain)?
  • coudnt use logback because of log4j
  • costura.fody for a dll that references another dll
  • jQuery Masonry / Isotope and fluid images: Momentary overlap on window resize