CRM 2011 Embed Report in IFrame and Pass Parameters from the Form

In CRM you can insert SubGrid and Chart. However this functionality is limited in a way that it can only grab the related entities that have direct relationship to that entity. If we want to get the other related entities from the related entity, it's not possible using the OOTB Subgrid and Chart.

In my case I want to display a chart in an Engagement Plan entity. This Engagement Plan is associated with an Account (N:1). The Account has 1:N relationships with Production History and Contract History entities that have information about commodity and tonnes produced. I want that chart to be shown on the Engagement Plan form. The parameters for this chart will be the Account Id and the Season Id located on the form.



The Steps:
  1. Create a custom SSRS Report to display this chart, taking @CRM_AccountId and @CRM_SeasonId as parameters.
  2. Insert an IFRAME on the form and give dummy Url. Also uncheck 'Restrict Cross Site Scripting' to allow cross scripting between servers.
  3. Create a javascript that is triggered in Form_OnLoad, Account_OnChange, and Season_OnChange:



The method for the form OnLoad is 'Form_onload'
The method for the field Onchange is 'loadChart'

Hope this helps,
Andreas

Comments

  1. AnonymousMarch 27, 2012 at 1:38 PM

    Thanks for this post it helped me to load an ssrs report into an iframe on a form.

    ReplyDelete
  2. AnonymousOctober 25, 2012 at 5:08 AM

    Andreas,

    In sample above, you are building the url for the report. The id= value is a specific guid. What is guid? Wouldn't it need to be dynamically set?

    var url = serverUrl + "/crmreports/viewer/viewer.aspx?action=filter&helpID=CommodityTonnes.rdl&id=%7bB135D3F7-65C1-E011-A653-005056A10003%7d";

    Todd

    ReplyDelete
    Replies
    1. AndreasNovember 6, 2012 at 10:46 AM

      Hi Todd,

      The guid is the Id of the report. You can find the id by opening the report record and hit F11 (then look in the address bar).

      P.S:
      You can also create a function to retrieve the id if you want (maybe by report name) using fetchXml. It's up to you :)

      Regards,
      Andreas

      Delete
  3. AnonymousMay 29, 2014 at 10:02 PM

    I have done all that but am using the filtered views and the reprot is asking for the user name and password. How do I get around that?

    ReplyDelete
    Replies
    1. AnonymousMay 30, 2014 at 4:15 PM

      Sorry I could not sign in for the post above but i have now subscribed to your blog so when you get a chance to answer this I will be notified. Many thanks Julie

      Delete
    2. AndreasJune 3, 2014 at 7:18 AM

      Hi Julie,

      using filtered views in the report should be fine and is the normal way of creating reports. The issue must be related to a different cause.

      Are you able to open the report by going to the crm reportviewer url itself? i.e. "/crmreports/viewer/viewer.aspx?action=filter&helpID=..."

      Delete
  4. AnonymousAugust 14, 2014 at 5:28 AM

    I noticed you used "p:[parameter]=[value]" in your url to pass a parameter into your report via url. I am looking for other commands to hide the toolbar and parameter pane.

    Where did you find out about "p:" and do you know where I can find the commands to hide the toolbar and parameter pane via URL?

    Thanks!

    ReplyDelete
    Replies
    1. AndreasAugust 14, 2014 at 4:47 PM

      Hey,

      Pretty sure I've read about the "p:" on the web as many people have been using this.

      Unfortunately the viewer.aspx doesn't support parameter to hide the toolbar. You might have to create custom aspx page for this one:

      http://social.microsoft.com/Forums/en-US/7bae9d87-f011-4d43-93db-980e2dca5caf/crmreportsviewervieweraspx-url-parameter-to-hide-toolbar-2011?forum=crmdevelopment

      Delete

Post a Comment

Popular posts from this blog

SharePoint 2013 anonymous access add attachments to list item

Image
Hi, Sometimes you want to enable anonymous access to be able to add a list item but at the same time attaching some documents. After good few hours playing around trying to make this work, turns out that we can achieve this functionality. The trick is to use RunWithElevatedPrivileges method for the file upload. We also want the file upload functionality to be available on the NewForm.aspx as it wouldn't make sense to put it in other forms as any user would be able to upload files to other records. The result will be something like this: When it is saved, the user is redirected to the display form: The close button then will take the user back to the homepage (or any page you desire) The steps: 1. Create an ascx control to host your file upload control in your project.  Put the below script in the ascx as well (credit to this post ): The code behind: 2. Create custom form template. You have to put the ascx in the CONTROLTEMPLATES folder of the
Read more

Sitecore custom publish agent from specific node and at a specific time

Hi all, As you all know, scheduled publishing will not run automatically unless you enable PublishAgent task in Sitecore config. By default, all items that are in publish queue will get published when this task triggers. This includes all items in the final workflow state and all items that don't have workflows. Sometimes this is not what you want. Maybe you don't enable workflow on media items and you don't want the items to go live when they are not ready. The workaround is to create your own PublishAgent task. Looking at the one provided, we can easily extend the code to insert the RootItem to the PublishOptions (this only works with Full or Smart publish mode however): You will notice that on the Run method I check whether the server time is around the time I set in the parameter (thanks to this post for the code). This will enable us to run the task near the specific time we set (e.g. midnight). In the config patch, just add this to enable the custom agent
Read more

CRM Plugin - Parent and Child Pipeline

This concept tends to confuse people often - and I was no exception. I came across this problem when trying to create custom auto-numbering for one of my projects. Creating auto-number for Opportunity is easy. This is because the user creates opportunity straight from the home screen - thus the plugin runs on parent pipeline. However, it's a different story if you are dealing with Quote entity. Quote can be created in 2 ways, through the home screen OR the opportunity screen. If you create it from the latter, it will run on the child pipeline and you will find that your plugin will not work. Registering it as a child pipeline is easy, but CRM makes it harder since you can't use ICRMService. Instead, you have to create CRMService manually by using this piece of code: Not only that, with the child plugin you can't use Query expression to fetch other entities in your code unless you register it as ASYNCHRONOUS plugin. Mark Kovalcson in his blog found out that: A C
Read more