Call Us Today! 1-800-895-3254
[email protected]
Microsoft Training
Integent offers a comprehensive portfolio of training services, with an ideal fit for every organization. Ranging from general courses to custom solutions, we have you covered.
Learn About TrainingSee Full list of Courses
Microsoft Consulting
Integent provides consulting services for a variety of Microsoft applications including Microsoft Project, Project Online, Project for the Web, Dynamics 365, and Microsoft SharePoint.
Learn About Consulting
Microsoft Support
Microsoft technologies set the standard for project portfolio management, business applications, collaboration, and more. Integent has flexible solutions to support every customer.
Learn About Support
Microsoft Project
Integent has the knowledge and experience to help design and deploy a solution to help your organization manage projects and resources more effectively
Learn More About Microsoft Project
Microsoft Dynamics 365
Integent can help you nsure business continuity with a custom cloud solution that connects sales, service, finance, and operations teams to deliver results.
Learn More About Dynamics 365
Microsoft SharePoint
SharePoint is Microsoft’s collaboration platform that is a place where team members can communicate, exchange data, share files and much more.
Learn More About Microsoft SharePoint
Microsoft Power Platform
Consisting of Power BI, Power Apps, Power Automate and Power Virtual Agents, the Microsoft Power Platform helps streamline and improve business functions.
Learn More About The Power Platform
About Integent
Integent was founded in 2009 on the principles of building long-lasting relationships with customers, exceeding expectations, and providing outstanding customer service. 

We’re dedicated to providing a customized solution backed by our knowledgeable team of Microsoft experts.
Discover What Makes Us Different
GSA Schedule
Integent is GSA Schedule Contract holder. A GSA schedule helps simplify selling our services to government customers.
Read More Here
News
Stay informed on Integent’s latest company updates and other important industry information. Our passion is customer success.
Read The Latest News
Videos
Learning new software doesn’t have to be difficult with our library of dozens of free training videos. Our video training always has something new.
Browse Our Training Video Library
Blog
Our industry experts share best practices and common pitfalls to avoid, in order to get the most out of your technology solutions.
Discover More

December 5, 2011

SQL Reporting Services 2008 R2: Using URLs to call reports with single and Multi value parameters (HTML and Report Viewer applicable)

 

This is simply a brain dump from quite a bit of SSRS report development I was doing this past weekend.  Basically I have one SSRS report that I want to call another, however, I want it to open in a new window.  Yes, seems easy, however, it’s somewhat complex.  The first few URLs below are all using the HTML viewer with either one or multi value parameters being passed in it.  The second set of URLs use the Report Viewer webpart.  The biggest advantage of the Report Viewer webpart for me personally, was that you could control the height of the rows of the report and make it so they DO NOT increase.  The issue I was having with the HTML view was although I set the cells to NOT allow a height increase, the height was indeed increasing.  This was making my graphical indicators when using the Indicators tool look horrible.  fortunately the Report Viewer webpart does NOT exhibit this behavior.  Smile

This is a partial screenshot of the calling report.  The Summary line will pass two multi-value parameters to the destination report (selected departments and selected project status’).  The Department level rows below the summary level will pass the department for the selected row, and a multi-value parameter for project status.

image

 

HTML Viewer URLs

two mult-value parameters from current report passed

="javascript:void(window.open('http://mpntprj10f/reportserver?http://mpntprj10f/PWA/ProjectBICenter/Report%20Pack/Enterprise%20Projects.rdl&rs:Command=Render&Department=" + JOIN(Parameters!Department.Value, "&Department=") & "&ProjectStatus=" + JOIN(Parameters!ProjectStatus.Value, "&ProjectStatus=")+"'))"
="javascript:void(window.open('http://mpntprj10f/reportserver?http://mpntprj10f/PWA/ProjectBICenter/Report%20Pack/Enterprise%20Projects%20KPIs.rdl&rs:Command=Render&Department=" + JOIN(Parameters!Department.Value, "&Department=") & "&ProjectStatus=" + JOIN(Parameters!ProjectStatus.Value, "&ProjectStatus=")+"'))"

 

One single value parameter based on field value and one mult-value parameter, both based on current report

="javascript:void(window.open('http://mpntprj10f/reportserver?http://mpntprj10f/PWA/ProjectBICenter/Report%20Pack/Enterprise%20Projects.rdl&rs:Command=Render&Department=" +Fields!Project_Departments.Value+ "&ProjectStatus=" + JOIN(Parameters!ProjectStatus.Value, "&ProjectStatus=")+"'))"

 

Report Viewer WebPart URLs

No Parameters passed
="javascript:void(window.open('http://mpntprj10f/PWA/ProjectBICenter/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/PWA/ProjectBICenter/Report%20Pack/Enterprise%20Projects%20KPIs.rdl'))"

Single hardcoded parameter passed
="javascript:void(window.open('http://mpntprj10f/PWA/ProjectBICenter/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/PWA/ProjectBICenter/Report%20Pack/Enterprise%20Projects%20KPIs.rdl&rp:Department=IT'))"

Once hardcoded parameter and one multi-value parameter
="javascript:void(window.open('http://mpntprj10f/PWA/ProjectBICenter/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/PWA/ProjectBICenter/Report%20Pack/Enterprise%20Projects%20KPIs.rdl&rp:Department=IT" + "&rp:ProjectStatus=" + JOIN(Parameters!ProjectStatus.Value, "&rp:ProjectStatus=")+"'))"

One single value parameter based on field value and one mult-value parameter, both based on current report
="javascript:void(window.open('http://mpntprj10f/PWA/ProjectBICenter/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/PWA/ProjectBICenter/Report%20Pack/Enterprise%20Projects%20KPIs.rdl&rp:Department=" +Fields!Project_Departments.Value+ &

© Copyright 2023 | Integent.com | All Rights Reserved
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram