I am resurrecting some RS dashboards I created in 2006 using VS 2005, SQL Server 2005, and Dundas charts.
In 2006 I was convinced MSFT would make it BIG with RS. But by 2010, with the purchase of Dundas widgets, and the slow uptake of RS, we decided to put those old reports in mothballs. There was no automated way to upgrade from the Dundas charts to the MSFT charts and it all just seemed like too much trouble in 2010.
But here we are in 2021. Now SQL server is MUCH faster and it is a viable competitor for real DWs.
Also, RS is MUCH better. So we think it's time to dust off these old reports and upgrade them. We will likely do new dashboards in Power BI some time soon too. But we have 70+ reports we can just dust off and convert so that's a good starting point.
I am using VS2017 SSDT but I am getting the same result on VS2013. There is something amiss with the upgrade process of the RDL.
I have seen a LOT of posts about this problem. I have tried all those things like upload the report from bin and download it again and put it back in to the project. All to no avail.
Currently I am able to load the report into RS on SQL server 2016 developer edition and it runs ok. So SQL Server can read and process the RDL. But VS2017 and VS 2013 can't.
The message in VS for the deploy is: "Error pvInvalidDefinition : The definition of the report '\ACPA0100 - Campaign Revenue Variance Summary.rdl' is invalid."
When I try preview I get "An error occurred during local report processing. The size necessary to buffer the XML content exceeded the buffer quota".
I was quite expert on RS in 2006 but I have to admit I am rusty.
If any of you "young guns" know what is the exact problem with the RDL XML and can tell me how to fix it?
I would be very grateful.
I have put the report and components in my drop box here if you need to look at it to know exactly what is wrong. What a great idea for being able to share code with problems in it!
Thank you in advance!