[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

SSRS Report error in deployment

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
angel7170
Asked:
angel7170
  • 2
  • 2
2 Solutions
 
angel7170Author Commented:
I am attaching screenshots of the configuration and the error message
Capture.PNG
error.PNG
0
 
DcpKingCommented:
"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
 
ManjuIT - Project ManagerCommented:
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
 
DcpKingCommented:
On every report the Angel ever creates, Manju? Wow! What a pain!
0
 
ManjuIT - Project ManagerCommented:
Try one report and deploy. You'll know for sure. Let me know if it works
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now