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

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

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Drew Poggemann 4 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,

Was this reply helpful? Yes No
Community Member 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.

Was this reply helpful? Yes No
Suggested answer

Drew Poggemann 4 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,

Was this reply helpful? Yes No
Drew Poggemann 4 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.

Was this reply helpful? Yes No
Suggested answer

Drew Poggemann 4 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,

Was this reply helpful? Yes No
Community Member 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?

Was this reply helpful? Yes No
Drew Poggemann 4 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,

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No
Community Member on at

Like (3)

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! :)

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No