SSRS - MultiValue Param - distinct?

Posted on 2009-12-18
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 42

    Accepted Solution

    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

    had to use the param and multi filter

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
    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. …
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now