We recently upgraded our CRM environment from 2011 to 2016 and are having issues with certain reports. At first it was noticed that sub reports were not working. Where the report should be displayed "Error: Subreport could not be shown." was found instead.
I looked at the report error log and noticed the following message: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: One or more parameters required to run the report have not been specified.
The only parameter to the subreports is the GUID to a case. I exported the report and ran it from Visual Studio and it ran just fine. I added the case GUID to the output of the report and it printed as expected when running from Visual Studio. However, after publishing the new report to CRM the GUID field is empty! All other fields are populated and have values as expected.
What is even more odd is that the GUID only appears to be missing when using the default MSCRM_DataSource with a data source type of "Mircosoft Dynamics CRM SQL". If I create my own Microsoft SQL Server data source and run the report the GUID is printed in the report as expected.
Has anyone experienced this behavior? Any ideas as to the cause or a solution?
*This post is locked for comments