从MS CRM工作流活动调用SQL Server报告服务

时间:2022-07-01 00:37:40

My task is to generate printable report within MS CRM 2011 interface.

我的任务是在MS CRM 2011接口中生成可打印的报告。

Is there any recommended way to access SQL Server Reporting Service within CRM hosted code? I don't want to connect directly, since it requires passing correct credentials to correct URL — and this information differs from installation to installation.

在CRM托管代码中有什么访问SQL Server报告服务的推荐方法吗?我不想直接连接,因为它需要传递正确的凭据来纠正URL——这个信息不同于安装。

So I either need to create setup table to save all connection information, or I should hard-code it and recompile.

所以我需要创建setup table来保存所有的连接信息,或者我应该硬编码并重新编译它。

Is there any generic solution to this problem?

这个问题有通用的解决方案吗?

1 个解决方案

#1


1  

Unfortunately the only way I found is to use Reporting Services endpoint and credentials to access it. I wrote article about it - http://a33ik.blogspot.com/2012/11/general-approaches-to-generation-of.html

不幸的是,我发现的惟一方法是使用报表服务端点和凭据来访问它。我写了一篇关于它的文章——http://a33ik.blogspot.com/2012/11/general-approaches-to- generationof.html

#1


1  

Unfortunately the only way I found is to use Reporting Services endpoint and credentials to access it. I wrote article about it - http://a33ik.blogspot.com/2012/11/general-approaches-to-generation-of.html

不幸的是,我发现的惟一方法是使用报表服务端点和凭据来访问它。我写了一篇关于它的文章——http://a33ik.blogspot.com/2012/11/general-approaches-to- generationof.html