I've been requested by some end users to figure out scheduled reporting for our on-premise CRM 2013 deployment. I've been able to schedule email delivery of Administrative Reports successfully, however when attempting to schedule delivery of a custom report, I get the following error on the My Subscriptions page on my SQL Server:
Failure sending mail: Failed to load expression host assembly. Details: Could not load file or assembly 'Microsoft.Crm.Reporting.RdlHelper, Version=184.108.40.206, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The located assembly's ma
(unfortunately the rest of the error doesn't display, I imagine it has something to do with the assembly's manifest)
My environment: Dynamics CRM application server with a separate SQL server (with SSRS). I scheduled the report in the Dynamics browser as an on-demand snapshot, then "subscribed" to the report in SSRS. I've seen suggestions on various forums to modify the report in VS, change the assembly references etc., but nothing seems to have worked.
Any suggestions would be greatly appreciated,
Check the error logs on the report server for the exact error detail
%programfiles%\Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles.