Multiple Values in RDLC Matrix

Posted on 2009-12-16
Last Modified: 2012-05-08
Hi there,

I have 3 tables:
Makes, Models and Series

Every Model has a make and a series
There could be multiple models for each Make and Series

So when I do a matrix it shows like below

                           a                     b                          c
Ford                 Mustang           Malibu                 F350

Where it should be

                           a                     b                          c
Ford          Mustang, Colt           Malibu                 F350, F150, F250

Make sense? The tables are simple as below:
Make Table

Model Table

Series Table
Question by:Jorell
    LVL 26

    Expert Comment

    by:Chris Luttrell
    Put both the Series and Model in the Matrix groupings, Series first, if you want to list the Models in multiple cells by Series.  If you need the comma separated list, let us know.  Also, it would help to know which version of SSRS your are using as syntax and options can differ.

    Author Comment

    Hi there
    We would need each cell to be a comma separated list. As well, I am using whatever version comes standard with VS 2008

    Thank you again!
    LVL 2

    Accepted Solution

    Reporting Services does not have the ability to create comma separated list inside a matrix cell. You would have to create such a list in code and drop this computed field to the body cell.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Suggested Solutions

    Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
    Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    779 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

    11 Experts available now in Live!

    Get 1:1 Help Now