** We are self-hosted **
Can anyone help me troubleshoot why I am getting this error on a report I am building in Visual Studio?
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
Would need more information, typically you can get it from the Output window.
Oh my! May be I need to go delete some parameters?
The output window is actually the next one over, that was the error and warning list. In this case though the warning about VS 2014 is probably at the root of your problem. You will want to upgrade to 2019 as there were significant changes made in 2015 that would cause some reports created in a more recent version not to work correctly when opened in an older versions of VS. You can still leave VS 2014 installed if you need it, for example I have 3 different versions of it installed on my laptop to handle some legacy stuff.
Okay so ... I am on VS2017 but our SQL Server Version is 2014. It think that might be my problem but I am still not sure how to solve it.
Google is failing me here, so I hope someone has some insight. Maybe I should put VS 2014 on my machine and see what happens...??
Thanks,
Ashley
You need to upgrade SQL Server to a minimum of 2016 since there were significant changes in reporting services made between 2014 and 2016. This specific update is what is most likely at the root of your issue:
**SOLVED*
I stumbled on a solution to this while working on something else. It probably coincides with what someone posted in reply to me here, but I didn't understand it at the time.
What needed to be done is in this Stack Overflow link here: https://stackoverflow.com/questions/36272514/the-report-definition-has-an-invalid-target-namespace-rsinvalidreportdefinition
At the time I posted this request for help, I had never edited a report in code view - only design view. Take note of the fact that the person answering in that Stack Overflow link says "The minute you change any fields {in design view} it will revert to the 2016 schema."
Hope this helps someone in the future!