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
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
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.
ASKER
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.