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

(0) Share

Report

Posted on by Community Member 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

All responses (10)

Answers (0)

DataMan on at

Like (1)

Report

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 Microsoft Employee on at

Like (2)

Report

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 on at

Like (0)

Report

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 9,079 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 9,079 on at

Like (0)

Report

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 9,079 on at

Like (0)

Report

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 9,079 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 9,079 on at

Like (0)

Report

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,