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
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.
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! :)
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
Sorry Mac_012 I do not.
Please mark verified if this helped.
Hopefully the other approach helps.
Thanks,
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?
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,
Shoot, that is a form not a report :( I will keep looking, sorry.
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,
Thanks for ur inputs drew, but the link doesn't seem to address my issue about passing a parameter via URL.
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,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,993 Most Valuable Professional
nmaenpaa 101,156