Solved

SSRS Report error in deployment

Posted on 2016-07-21
5
207 Views
Last Modified: 2016-07-25
Hello,

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
0
Comment
Question by:angel7170
  • 2
  • 2
5 Comments
 

Author Comment

by:angel7170
ID: 41723280
I am attaching screenshots of the configuration and the error message
Capture.PNG
error.PNG
0
 
LVL 16

Accepted Solution

by:
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

Mike
0
 
LVL 6

Assisted Solution

by:Manju
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!

or

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

Expert Comment

by:DcpKing
ID: 41725464
On every report the Angel ever creates, Manju? Wow! What a pain!
0
 
LVL 6

Expert Comment

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

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

828 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