Dynamics Community Forum Thread Details

How to Run the CRM Report through SDK

We do this exact thing with a custom workflow plugin Code below:

using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Workflow;
using System;
using System.Activities;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Text;
using System.Threading.Tasks;
using System.IO;
using System.Collections;
using Microsoft.Crm.Sdk.Messages;
using System.Web;

namespace Plugins
{
    public class AttachAndSendReportServerPDF : CodeActivity
    {
        [RequiredArgument]
        [Input("Source Email")]
        [ReferenceTarget("email")]
        public InArgument<EntityReference> SourceEmail { get; set; }

        [RequiredArgument]
        [Input("Send Email When Complete?")]
        [Default("True")]
        public InArgument<bool> SendOnComplete { get; set; }

        [RequiredArgument]
        [Input("Report Server")]
        [Default("https://URL.ServerLocation.Com")]
        public InArgument<string> ReportServer { get; set; }

        [RequiredArgument]
        [Input("Report Directory")]
        [Default("")]
        public InArgument<string> ReportDirectory { get; set; }

        [Input("Parameter Name")]
        [Default("Id of Entity")]
        public InArgument<string> ParameterName { get; set; }
        
        [Input("Parameter is Entity Reference? (Current Record Guid)")]
        [Default("True")]
        public InArgument<bool> ParameterType { get; set; }

        [Input("Parameter Value (String - If Above Is False)")]
        [Default("")]
        public InArgument<string> ParameterStringValue { get; set; }
        
        protected override void Execute(CodeActivityContext _context)
        {
            string RSLink = "";
            try
            {
                IOrganizationServiceFactory factory = _context.GetExtension<IOrganizationServiceFactory>();
                IWorkflowContext _wfContext = _context.GetExtension<IWorkflowContext>();
                IOrganizationService _service = factory.CreateOrganizationService(_wfContext.UserId);

                RSLink = GenerateRSLink(_context, _wfContext);
                string Base64 = GetLinkContents(RSLink);
                CreateEmailAttachment(Base64, _service, _context);
                if (_context.GetValue(SendOnComplete))
                    SendEmail(_service, _context);
            }
            catch (Exception ex)
            {
                throw new InvalidPluginExecutionException(ex.Message + " : " + RSLink);
            }
        }

        protected void SendEmail(IOrganizationService _service, CodeActivityContext _context)
        {
            EntityReference Email = _context.GetValue(SourceEmail);

            SendEmailRequest req = new SendEmailRequest();
            req.EmailId = Email.Id;
            req.TrackingToken = "";
            req.IssueSend = true;
            SendEmailResponse res = (SendEmailResponse)_service.Execute(req);
        }

        protected void CreateEmailAttachment(string Base64, IOrganizationService _service, CodeActivityContext _context)
        {
            Entity pdf = new Entity("activitymimeattachment");
            pdf["subject"] = "SSRS - Report";
            pdf["filename"] = "ssrsReport.pdf";
            pdf["body"] = Base64;
            pdf["mimetype"] = "application/pdf";
            pdf["objectid"] = _context.GetValue(SourceEmail);
            pdf["objecttypecode"] = "email";

            _service.Create(pdf);
        }

        protected string GetLinkContents(string URL)
        {
            WebClient client = new WebClient();
            client.UseDefaultCredentials = true;
			//You may or maynot need to do this. Depends on your requirements
            //client.Credentials = new NetworkCredential([Username], [Password], [Domain]);

            byte[] bytes = client.DownloadData(URL);
            client.Dispose();

            return Convert.ToBase64String(bytes);
        }

        protected string GenerateRSLink(CodeActivityContext _context, IWorkflowContext _wfContext)
        {
            string FullReportPath = string.Format("{0}/ReportServer?{1}&rs:Command=Render&rs:Format=PDF", _context.GetValue(ReportServer), Uri.EscapeUriString(_context.GetValue(ReportDirectory)));
            string Param_Name = _context.GetValue(ParameterName);
            if (Param_Name != null && Param_Name.Length > 0)
            {
                if (_context.GetValue(ParameterType))
                {
                    Guid Param_Id = _wfContext.PrimaryEntityId;
                    FullReportPath += string.Format("&{0}={1}", Param_Name, Param_Id.ToString());
                }
                else
                {
                    string Param_String = _context.GetValue(ParameterStringValue);
                    FullReportPath += string.Format("&{0}={1}", Param_Name, Param_String);
                }
            }
            return FullReportPath;
        }
    }
}

Quick Links

Leaderboard