SSRS - MultiValue Param - distinct?

Posted on 2009-12-18
Medium Priority
Last Modified: 2012-05-08
I have a query that has a field called Region in it.  The region is across multiple records.  I tried using a multi-value but it shows the same value over and over. So I created a second dataset of distnct values.  Do I need to somehow tie that to the main query to filter the results and how do I do that?  

Question by:sbornstein2
LVL 44

Accepted Solution

zephyr_hex (Megan) earned 2000 total points
ID: 26086017
i'm not entirely clear on what you're trying to achieve, so i have two responses.

if you are just trying to keep from having region show multiple times, have you considered adding a Group to your table?  when you group by region, then you can display the region in the group row, and the details that differ for each record in the details row.

if you are indeed trying to filter by region, i'm assuming you have a parameter for region.  you'll want that parameter to be based on a query to your dataset that has distinct region values.  then filter your table by that parameter.

Author Closing Comment

ID: 31667895
had to use the param and multi filter

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

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

This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses
Course of the Month15 days, 4 hours left to enroll

839 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