{"id":1031,"date":"2014-10-07T07:17:47","date_gmt":"2014-10-07T07:17:47","guid":{"rendered":"https:\/\/poiseddevelopers.com\/reality-tech\/?p=1031"},"modified":"2024-04-26T12:34:24","modified_gmt":"2024-04-26T12:34:24","slug":"using-url-parameters-for-an-ssrs-report-in-sharepoint-integrated-mode","status":"publish","type":"post","link":"https:\/\/poiseddevelopers.com\/reality-tech\/using-url-parameters-for-an-ssrs-report-in-sharepoint-integrated-mode\/","title":{"rendered":"Using URL Parameters for an SSRS Report in SharePoint Integrated Mode"},"content":{"rendered":"<p>SSRS running in SharePoint integrated mode provides a great experience, but how can one pass in parameters to such a report (rdl) published to SharePoint?<\/p>\n<p>here\u2019s a URL that works for what you intended:<br role=\"presentation\" data-uw-rm-sr=\"\" \/>http:\/\/WebAppName\/sites\/SiteName\/WebName\/_vti_bin\/reportserver?http:\/\/WebAppName\/sites\/SiteName\/WebName\/LibName\/ReportName.rdl&amp;rc:Parameters=Collapsed<\/p>\n<p>Here\u2019s how to construct the URL:<br role=\"presentation\" data-uw-rm-sr=\"\" \/>1. Get the SPWeb; this is the lowest site for the RDL report. In this case it is http:\/\/WebAppName\/sites\/SiteName\/WebName which is in the SPWeb below the site collection.<br role=\"presentation\" data-uw-rm-sr=\"\" \/>2. Add on \u201c\/_vti_bin\/reportserver?\u201d<br role=\"presentation\" data-uw-rm-sr=\"\" \/>3. Add on the full URL of the RDL; you can get that by going to the All Files view, and clicking the ellipses (\u201c\u2026\u201d) and clicking on the full URL and copy. Or right click on the RDL link and copy URL.<br role=\"presentation\" data-uw-rm-sr=\"\" \/>4. Add on your &amp;parameters<\/p>\n<p>Parameter examples include:<\/p>\n<p>Collapsing parameter pane:\u00a0&amp;rc:Parameters=Collapsed<\/p>\n<p>Zooming to whole page or page width: &amp;rc:Zoom=Page Width<\/p>\n<p>Jump to report section: &amp;rc:Section=4<\/p>\n<p>Happy reporting!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SSRS running in SharePoint integrated mode provides a great experience, but how can one pass in parameters to such a report (rdl) published to SharePoint? here\u2019s a URL that works for what you intended:http:\/\/WebAppName\/sites\/SiteName\/WebName\/_vti_bin\/reportserver?http:\/\/WebAppName\/sites\/SiteName\/WebName\/LibName\/ReportName.rdl&amp;rc:Parameters=Collapsed Here\u2019s how to construct the URL:1. Get the SPWeb; this is the lowest site for the RDL report. In this case [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":1033,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[27],"tags":[],"class_list":["post-1031","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ssrs"],"acf":[],"_links":{"self":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1031","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/comments?post=1031"}],"version-history":[{"count":2,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1031\/revisions"}],"predecessor-version":[{"id":1036,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1031\/revisions\/1036"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media\/1033"}],"wp:attachment":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media?parent=1031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/categories?post=1031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/tags?post=1031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}