Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

How to Pass Input Parameters via URL for an SSRS Report which is hosted in MS CRM Online

Posted on by Microsoft Employee

Hi Everyone

Can anyone advise on how to pass input parameters to an ssrs report in ms crm online.

Basically i want to trigger a email and send it to users with a link to the report (with dynamic parameter values) and the report should auto run on click of the link.

 I have implemented the same in an on-premise version but not sure how to concatenate the URL in online version.

Any help would be appreciated.

*This post is locked for comments

  • DataMan Profile Picture
    DataMan on at
    RE: How to Pass Input Parameters via URL for an SSRS Report which is hosted in MS CRM Online

    Thanks Tamanna,

    I don't have time to try your solution currently, but I'll stash it away for later.

    We've decided to go down the Data Export Service path for this project.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to Pass Input Parameters via URL for an SSRS Report which is hosted in MS CRM Online

    In my case, the report was supposed to run on selecting a record from the view and clicking a button. Using "&p:ParameterName" you can pass the parameter value. This is one way to create a URL.

    var clientUrl = Xrm.Page.context.getClientUrl();
    var reportId = "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx";
    var url = clientUrl + "/crmreports/viewer/viewer.aspx?action=run&helpID=State%20Report.rdl&id=%7b" + reportId + "%7d" + "&p:State=" + State + "&p:FROMDATE=" + fromDate + "&p:TODATE=" + toDate;
    window.open(url, "reportwindow", "resizable=1,width=950,height=700");

    Hope this helps! :)

  • DataMan Profile Picture
    DataMan on at
    RE: How to Pass Input Parameters via URL for an SSRS Report which is hosted in MS CRM Online

    So can I confirm its not possible to pass Report Parameters to reports published in Dynamics Online?

    eg. Where ReportDate is a report Parameter?

    xxx.crm6.dynamics.com/.../viewer.aspx;helpID=Listing.rdl&id=%GUID%7d&ReportDate=01/06/2017

  • Drew Poggemann Profile Picture
    Drew Poggemann 9,079 on at
    RE: How to Pass Input Parameters via URL for an SSRS Report which is hosted in MS CRM Online

    Sorry Mac_012 I do not.

    Please mark verified if this helped.

    Hopefully the other approach helps.

    Thanks,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to Pass Input Parameters via URL for an SSRS Report which is hosted in MS CRM Online

    Thanks drew for ur time and effort. It seems we could only pass the entity id and entity type  as input parameter via report url

    Do u happen to know any Microsoft material which talks about this restriction?

  • Suggested answer
    Drew Poggemann Profile Picture
    Drew Poggemann 9,079 on at
    RE: How to Pass Input Parameters via URL for an SSRS Report which is hosted in MS CRM Online

    After research it does not look to be possible to do with URL for on premises environments.

    community.dynamics.com/.../201665

    Jason identifies an alternate approach in the following article

    community.dynamics.com/.../running-a-report-from-a-ribbon-button

    Hopefully this will work for you.  If someone has a way to accomplish that is great but does not look possible.

    Thanks,

  • Drew Poggemann Profile Picture
    Drew Poggemann 9,079 on at
    RE: How to Pass Input Parameters via URL for an SSRS Report which is hosted in MS CRM Online

    Shoot, that is a form not a report :(  I will keep looking, sorry.

  • Suggested answer
    Drew Poggemann Profile Picture
    Drew Poggemann 9,079 on at
    RE: How to Pass Input Parameters via URL for an SSRS Report which is hosted in MS CRM Online

    Hi Mac_012,

    The following technical article addresses the issue from what I see and it gives examples as well.

    msdn.microsoft.com/.../gg334375.aspx

    Hopefully this answers your question.

    Thanks much,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to Pass Input Parameters via URL for an SSRS Report which is hosted in MS CRM Online

    Thanks for ur inputs drew, but the link doesn't  seem  to address my issue about passing a parameter via URL.

  • Suggested answer
    Drew Poggemann Profile Picture
    Drew Poggemann 9,079 on at
    RE: How to Pass Input Parameters via URL for an SSRS Report which is hosted in MS CRM Online

    Hi Mac_012,

    The following article technet.microsoft.com/.../dn531165.aspx discusses passing parameters to a report and it is valid for online as well as on premises.  The interesting paragraph is:

    Hidden parameters

    The Report Designer in Microsoft Visual Studio has built-in support for hidden parameters. In addition, you can hide parameters by adding a CRM_ prefix to the parameter name in a Microsoft Dynamics 365 report. By default, the parameters with a CRM_ prefix are hidden when the report is published through Microsoft Dynamics 365. When you run the report, you aren’t prompted to enter parameter values for the hidden parameters.

    I am hoping this is what you are trying to do and that this helps.

    Thanks much,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans