Dynamics 2009 SSRS 2008报告邮件订阅

Question

关于为AX报告创建邮件订阅，我有一些问题。

我在报告中输入了集成凭据，但订阅仍然返回异常：

报表处理过程中发生了错误。

报表在浏览器中使用报表参数的值。我从日志文件中提取了错误：

e ERROR: An exception has occurred in data source 'AutoGen___Query'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Failed to close connection for data source 'AutoGen___Query'. ---> System.TypeInitializationException: The type initializer for 'Container' threw an exception. ---> System.Security.SecurityException: Request failed.
processing!WindowsService_0!f48!11/15/2012-03:35:04:: i INFO: Some other thread has already aborted processing.
processing!WindowsService_0!f48!11/15/2012-03:35:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'BankAccountParam'. ---> System.TypeInitializationException: The type initializer for 'Container' threw an exception. ---> System.Security.SecurityException: Request failed.
--- End of inner exception stack trace ---;

​

有人能帮我解决这个问题吗？

Answer 1

不幸的是，在2009年，您将不得不重写报告，以避免使用数据源'AutoGen___Query‘-业务逻辑、AX查询等。

或者创建一个批处理作业，将报告发送出去。