Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1168
  • Last Modified:

Multiple Values in RDLC Matrix

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
-------------------------------
Id
MakeName


Model Table
-------------------------------
id
MakeId
SeriesId
ModelName


Series Table
--------------------------------
id
SeriesName
0
Jorell
Asked:
Jorell
1 Solution
 
Chris LuttrellSenior Database ArchitectCommented:
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.
0
 
JorellAuthor Commented:
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!
0
 
mckoderCommented:
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.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now