SSRS Report error in deployment

Posted on 2016-07-21
Last Modified: 2016-07-25

I installed SQL Server Express Advanced services 2014 version and SSDT 2015 tools.

I built a report using Visual Studio project and tried to publish in SSRS link. I changed the "TargetServerVersion" from SQL Server 2016 or later to SQL Server 2008 R2, 2012 or 2014 but still it gives me an error "The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content that is not well-formed or not valid based on Reporting Services schemas. Details: There are multiple root elements. Line 2, position 16638. (rsInvalidReportDefinition) Get Online Help".

Can someone please help
Question by:angel7170
  • 2
  • 2

Author Comment

ID: 41723280
I am attaching screenshots of the configuration and the error message
LVL 16

Accepted Solution

DcpKing earned 250 total points
ID: 41724517
"SQL Server Express Advanced services 2014 version and SSDT 2015 tools"

You're creating the report in 2015 and running it using SS 2014 ... very possibly SSDT is producing something that your SQL Server didn't know about when it was created.

Try upgrading your SQL Server to 2016. See here for info.

hope this helps


Assisted Solution

Manju earned 250 total points
ID: 41724858
You have to check the end of report definition (eg. using notepad) and look for space character – deleting this “blank” characters solves problem!


change the ASCII character in rdl to UTF-8
LVL 16

Expert Comment

ID: 41725464
On every report the Angel ever creates, Manju? Wow! What a pain!

Expert Comment

ID: 41725560
Try one report and deploy. You'll know for sure. Let me know if it works

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now