not add domain!
SQL Reporting Services 2008 R2: Using URLs to call reports with single and Multi value parameters (HTML and Report Viewer applicable) - Integent
Call Us Today! 1.800.895.3254
sales@integent.com
Consulting & Advisory
Consulting / Advisory helps business and IT leaders make better decisions and turn strategy into execution-ready initiatives. Most engagements start with a Discovery Initiative to confirm outcomes, and build a roadmap.

Learn About Consulting
Data & AI
Data & AI delivers modern data platforms, analytics, and practical AI solutions—from assistants to agents—built on enterprise cloud tools. Integent helps you govern, deploy, and drive adoption so solutions stick and scale across your organization.
Learn About Data & AI
Support
Support keeps your solution stable, secure, and aligned with day-to-day operations. We combine functional and technical expertise with proactive monitoring, preventive maintenance, and 24/7 coverage for critical incidents.

Learn About Support
Microsoft Planner Premium
Leverage proven knowledge and experience to design and deploy Microsoft Planner Premium so your organization can manage projects, work, and resources more effectively across teams.
Learn More About Planner Premium
OnePlan
Integent can help you ensure continuity beyond Project Online by deploying OnePlan in the Microsoft Cloud—connecting portfolio governance, resources, and delivery execution for results.
Learn More About OnePlan
Microsoft Dynamics 365
Ensure business continuity with a custom cloud solution that connects your sales, service, finance, and operations teams to deliver measurable, predictable results.

Learn More About Dynamics 365
Microsoft Power Platform
Consisting of Power BI, Power Apps, Power Automate and Copilot Studio, the Microsoft Power Platform helps streamline and improve business functions.

Learn More About 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
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 2026 | Integent.com | All Rights Reserved
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram