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
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,
#1
André Arnaud de Cal...
292,489
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
