locked
Passing parameters to CRM Reports through URL RRS feed

  • Question

  • Hi all,

    My CRM is deployed through IFD.
    Im using Sql reports as Dashboards deployed to Sharepoint via Performancepoint Server.
    Now i want to use the drillthrough fucntionality in the Dashboard reports to open sub reports, as sql reports are not available through internet calling subreport(sql report service report) will not be helpful.
    i thought of calling CRM reports (as they are available over internet through IFD) by passing parameters through Url.
    Can anyone help me to resolve the problem.
    Or provide me any alternative.

    Regards

    Rakesh
    Thursday, February 18, 2010 6:07 AM

Answers

  • Hi rakesh,
    the links i gave u are for CRM
    the "<organization url>" means? is it the name of the MS CRM Business Unit?, the URL will start name of the server where the reports are hosted. did you went through the above links?

    for organization, you have to use as suggested by david
    Extra Parameters passed by CRM
    To support multi-tenancy and multi-language deployments, CRM 4.0 passes additional parameters on the query string when the 'pass record object-type...' option is set for the IFrame. These extra parameters are orgname, UserLCID and OrgLCID.

    For the report to work in reporting services you will have to add parameters with these names to your report. The orgname parameter has to be a string, the UserLCID and OrgLCID can be either strings or integers. As with the type and typename parameters, these new parameters don't have to be used in the report, they just need to exist for reporting services to accept values for them on the query string.

    http://mscrmuk.blogspot.com/2008/06/reports-in-iframes-updated-for-crm-40.html

    Accessing the report from a browser

    The syntax for rendering a report from a url takes the following form:

    http://server/reportserver?/Excitation+Test_MSCRM/Account+Opportunity+Summary&rs:Command=Render

    Where:

    http://server/reportserver is the url to the report server (not the Report Manager)

    /Excitation+Test_MSCRM/Account+Opportunity+Summary is the path to the report, which you can find via Report Manager.

    Using the above url will render the report, but with extraneous information. The following additional parameters will remove the toolbar and parameter list:

    &rc:Toolbar=false&rs:ClearSession=true

    The first of these removes the toolbar and parameter list, and the second ensures that the report is run with new data each time it is accessed

    Thursday, February 18, 2010 10:14 AM
  • I am not sure, but I think there is no harm in using SRS Reprts on IFD environemnt.
    Also you can integerated with sharepoint for dashboard.
    check this link, it may be helpful.
    http://jianwang.blogspot.com/2008/11/code-crm-40-dashboard-intergate-with.html

    Thursday, February 18, 2010 12:33 PM

All replies