Solved

SSRS Report error in deployment

Posted on 2016-07-21
5
165 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Replication question 9 41
SSRS 2016 KPI 2 14
Need help how to find where my error is in UFD 6 26
TSQL query to generate xml 4 31
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

806 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