[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Display in the header what items where selected for a parameter.

Posted on 2012-09-11
Medium Priority
Last Modified: 2012-09-11
I have a parameter on my report where the user selects more than one item for a particular parameter. I want to display in my header everything
that the user selected. How would i do so?
Question by:vbnetcoder
  • 3
  • 2

Author Comment

ID: 38388908
I have know problem doing it when i have one item but not sure what to do when the user selects more then one.
LVL 11

Accepted Solution

Simone B earned 2000 total points
ID: 38388927
Here is a sample expression that I use in my report headers for the same purpose. In this example, it will list every branch selected in the BranchBranchName parameter.

="Branch Selected :" &Join(Parameters!BranchBranchName.Label,", ")
LVL 11

Expert Comment

by:Simone B
ID: 38388941
That was for a report whose data source is a cube. Similarly, you can use the same idea for a report whose data source is an SQL database, as in the example below. It just depends on whether you are displaying the labels or values. Sometimes there may be no difference in the two.

="Branch Selected: " & join(Parameters!BranchSelect.Value,", ")

Author Comment

ID: 38389197
Cool that worked. I am using a cube ....

What now is getting displayed is an id .... that the user had selected. Would it be possible to also display the description field that is related to the id.....

So for example it would display: 1 Apple, 2 Orange, 3 Pear.  Right now it is only displaying 1, 2, 3.

I will ask this question again under a new title: "Show the related description for a id parameter" if you want to get extra points.

Author Closing Comment

ID: 38389198

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses
Course of the Month19 days, 18 hours left to enroll

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question