web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Pass SSRS Report parameter in URL CRM 2016

(0) ShareShare
ReportReport
Posted on by

Hi All,

I have a custom SSRS reports in my Dynamics 2016 environment that contains child reports. The child reports uses a parameter from its parent to render. All works fine when a user click on the link to the child report it renders in the same window. What id like to do is have the child reports open in a new window instead.

I did some research and noticed it is possible to do so with the use of JavaScript on a Go to URL action as follows;

="javascript:void(window.open('http://<report-serverFQDN>/ReportServer/Pages/ReportViewer.aspx?%2f<OrgFolder>%2fCustomReports%2f%7b-GUID-7%7d&rs:Command=Render&Param=" & Fields!Param.value & "','_blank'))"


The issue with using the report server link to the child report or any report in CRM for that matter is  users cannot access these reports when accessing CRM externally via IFD.

I tried using a link to the report you'd get when a report is ran from the report section in CRM and add the parameter in the URL as shown below but that does not seem to work. Based on the testing it seems like you cant add parameters to a CRM report URL.

https://ORG/crmreports/viewer/viewer.aspx?&helpID=reportrdl.rdl&id=%7b-reportGUID-7%7d&rs:Command=Render&Param=

Please note that the parameter needed for the child report is not stored in CRM. The value needed for the child report parameter is displayed in the parent report after its rendered.

Any assistance will be truly appreciated.

*This post is locked for comments

I have the same question (0)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans