Call SQL Server Reporting Services from MS CRM workflow activity

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

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.

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

Is there any generic solution to this problem?

Can we integrate SSRS with Dynamics reporting?

Dynamics 365 SQL Server Reports With some basic knowledge, you can create custom SSRS reports for Dynamics 365 very quickly. Become your own Report Wizard! SSRS reports are created using SQL Server Data Tools, which is a version of Visual Studio specific for creating database related projects.

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