Thursday, February 12, 2015

ssrs report on crm dashboard

experienced some issues showing a ssrs report on a CRM 2011 dashboard.
the  standard criteria filters for the view settings were insufficient for the requested query so hence the need to put a rs report up and link to it in a crm dashboard. using a linked report or just a standard iframe both resulted in error city. A work around is possible by writing a html iframe, loading it into crm as a web resource, and then calling the web resource from the dashboard...
heres the sample code


<html><head><meta><meta><meta><meta></head><body style="word-wrap: break-word;"><iframe id="IFRAME_madeUPname" name="IFRAME_madeUPname" class="ms-crm-Custom" tabindex="0" url="http://yourRSURL&amp;rs:Command=Render" scrolling="auto" preload="0" src="http://yourRSURL&amp;rs:Command=Render" frameborder="0" height="100%" width="100%"></iframe></body></html>

Tuesday, February 10, 2015

crm 2011 workflow email issue

experienced and issue with a crm 2011 workflow failing to send and email, and remaining stuck in the status reason 'waiting for resource'. it seems the cause was from changing the cc, and bcc fields. there are other workflows that send emails with no issue.. so it it likely not the email router message Cannot create the given type without the required parameters. Plugin Trace: [Microsoft.Crm.Workflow: Microsoft.Crm.Workflow.Activities.EvaluateExpression] [EvaluateExpression] Error Message: the work around i found here proved insufficient https://rule30.wordpress.com/2014/04/10/fix-microsoft-crm-crmexception-cannot-create-the-given-type-without-the-required-parameters/ and ultimately ended up recreating the workflow