we are planning to update SQL server 2014 + Reporting Services to SQL server 2019 + reporting services. Both products will be updated.
I've been browsing the articles on the matter here in Q&A, but I still have a few questions.
We're using Visual Studio 2012 Report Editor to author the reports running on current RS 2014. Can I keep using the Visual studio 2012 to author the reports for RS 2019 as well or should I upgrade to Visual Studio 2019, for example?
Is it possible to skip the automatic Report upgrade or force all reports to be processed by RS 2014 Report Processor, for example?
Our reports contain many subreports. I read from from the article linked below, that there might be a case where either the main report or the subreport cannot be upgraded to the new version and this would cause them to be processed by different Report Processors with the Reporting Services, causing the report processing to fail ("Error: Subreport could not be processed").