Home > CRM 2011, JScript > Pass parameters to the report hosted in IFrame or Web Page

Pass parameters to the report hosted in IFrame or Web Page

Hi,

Assume you have to display related ‘contacts’ of an ‘Account’ in the report hosted in an IFrame.

You can prepare a dataset using below query in the report

SELECT * FROM FilteredContact C

WHERE

C.accountid=@CRM_AccountId

To set parameter @CRM_AccountId‘, you can pass parameter in the URL in this format "&p:CRM_AccountId="={Account GUID}"

Sample URL

var url = Xrm.Page.context.getServerUrl() +  “/crmreports/viewer/viewer.aspx?action=run&context=records&helpID=Internal%20Call%20Report.rdl&id=%7bcd80109a-dc7c-e111-a040-00155dc87c64%7d&records=%7b245DB4C3-927C-E111-9FA1-00155DC87C64%7d&recordstype=1+ “&p: CRM_AccountId=” + accountId;

Below is the useful article explained in detail

Link

Hope it helps 🙂

Advertisement
  1. April 15, 2012 at 7:04 PM

    Hello ,

    I am trying to call the email attachment iframe in email entity from another entity .

    I would like to show all the attachments of related emails of a opportunity in a different section .

    Do you know how to get the URL of any Out of Box iframe to call from another IFRAME ?

    Thanks,
    Prasun

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: