SSRS 2014 report deploy issue

by

I am on a phone right now so can’t double check exact syntax 😕 Ran in to this recently. You are probably used to deploying .rdls right out of your source folder. With the new version vs 2015 running against an older server version you will need to follow a few simple steps.

  1. Make sure your target environment is set correctly in project properties. It probably is since the upgrade should recognize it.
  2. Build your project. The source files will still be in the new format but .rdls (and other files) will be created in the target version in your bin sub-folder. These can be deployed without problem.

It looks like starting with Report Server 2016 there is a new file structure and the xmlns in the rdl file changes. Vs 2015 with the updated SSDT-BI will upgrade every report you open automatically to the new format and use that as the new source file. But building to the target environment will create rdls using the old xmlns and file format.

EDIT
Just adding some additional information I put in a different answer.

Under project properties you can have up to 3 options for TargetServerVersion depending on VS version and SSDT-BI version installed:

  • SQL 2008
  • SQL 2008 R2, SQL 2012, SQL 2014
  • SQL 2016+ (new in VS 2015 with latest SSDT-BI)

Each of these uses a different xmlns in the report XML code. As you open each report your source report .rdl file will be upgraded to the latest xmlns – like it or not.

However when you deploy or build, the .rdl files in your bin folder will be compiled to match the target. As long as you use the bin folder versions (automatic with VS deploy) you can successfully deploy these to your server.

More Related Contents:

  1. hide/remove header and footer
  2. Add alternating row color to SQL Server Reporting services report
  3. Tablix: Repeat header rows on each page not working – Report Builder 3.0
  4. SSRS report definition is newer than Server
  5. Need help in calculation using two Datasets using Expression SSRS
  6. Max Nbr of Months W/ No Activity in Past 12 Months
  7. SQL server query to output the data shown below
  8. How to use a variable for the database name in T-SQL?
  9. Create a view with ORDER BY clause
  10. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  11. INSERT INTO vs SELECT INTO
  12. Possible to store value of one select column and use it for the next one?
  13. How to view transaction logs in SQL Server 2008 [closed]
  14. Why does select SCOPE_IDENTITY() return a decimal instead of an integer?
  15. How to remove accents and all chars a..z in sql-server?
  16. How to connect to SQL Server with windows authentication from Node.JS using mssql module
  17. Calling an API from SQL Server stored procedure
  18. Escape Character in SQL Server
  19. Retrieve data from stored procedure which has multiple result sets
  20. How can I get the sum of multiple datetime values?
  21. Running an SSIS Package using dtexec
  22. Use of Begin / End Blocks and the Go keyword in SQL Server?
  23. Last executed queries for a specific database
  24. How do you set autocommit in an SQL Server session?
  25. How do you determine what SQL Tables have an identity column programmatically
  26. Ampersand (&) operator in a SQL Server WHERE Clause
  27. how to write number to word function in sql server [closed]
  28. Milliseconds wrong when converting from XML to SQL Server datetime
  29. Using GROUP BY with FIRST_VALUE and LAST_VALUE
  30. To run a SSIS package outside of SQL Server Data Tools you must install Move File to Archive of Integration Services or higher

Leave a Comment