Extracting the SSRS Report in PDF programmatically using Plugin or Wokflow in mscrm 2011

Extracting the Report in PDF programmatically.

http://a33ik.blogspot.com/2012/11/general-approaches-to-generation-of.html

Code snippet:

ReportGenerator rg = new ReportGenerator("http://crm/Reportserver/ReportExecution2005.asmx",

                new NetworkCredential("administrator", "Password", "contoso"));

            ParameterValue[] parameters = new ParameterValue[1];

            parameters[0] = new ParameterValue();

            parameters[0].Name = "P1";

            parameters[0].Value = string.Format("Select * From FilteredQuote Where QuoteId = '{0}'",

                context.PrimaryEntityId);

            byte[] reportresult = rg.Render("/contoso_mscrm/quote", FormatType.PDF, parameters);

            Entity attachment = new Entity("activitymimeattachment");

            attachment["objectid"] = Email.Get<EntityReference>(executionContext);

            attachment["objecttypecode"] = "email";

            attachment["filename"] =

            attachment["subject"] = "Quote.pdf";

            attachment["body"] = System.Convert.ToBase64String(reportresult);

Ref Links:

http://blogs.inetium.com/blogs/jmiley/archive/2008/10/06/programmatically-rendering-a-sql-server-reporting-services-ssrs-report-from-microsoft-crm-4-0-and-capturing-output-in-a-file.aspx

http://mileyja.blogspot.com/2008/10/programmatically-rendering-sql-server.html

http://andreaswijayablog.blogspot.com/2011/09/crm-2011-custom-workflow-activity-send.html

http://www.dowawado.com/2012/10/19/crm-2011-render-ssrs-report-from-plugin/

http://icircusmonkey.wordpress.com/2012/12/24/rendering-crm-2011-report-programmatically/

http://sandeep-aparajit.blogspot.com/2010/02/how-to-execute-and-save-ssrs-report.html

http://blogs.inetium.com/blogs/jmiley/archive/2008/10/06/programmatically-rendering-a-sql-server-reporting-services-ssrs-report-from-microsoft-crm-4-0-and-capturing-output-in-a-file.aspx

http://social.msdn.microsoft.com/Forums/en-US/68792a05-8706-4f87-90fe-c625552dc404/programatically-render-ssrs-report-from-crm-40

http://a33ik.blogspot.com/2012/11/general-approaches-to-generation-of.html

http://geekswithblogs.net/stun/archive/2010/02/26/executing-reporting-services-web-service-from-asp-net-mvc-using-wcf-add-service-reference.aspx