SSRS Multi Value Matrix Field

0
votes

I have the data as follows:

WEEK    WEEK_DAY    DAY_NAME    DATE        RECORD
1              4    Wednesday   2014-01-01  NULL
1              5    Thursday    2014-01-02  IM13368
1              5    Thursday    2014-01-02  IM13377
1              6    Friday      2014-01-03  IM13381
1              6    Friday      2014-01-03  IM13364
1              7    Saturday    2014-01-04  NULL

Now I want the data represent with Matrix report via SSRS (Calendar-like), but if there are two or more values for the same week and weekday, the matrix's field shows only one value, not all of them.

How can I force the report to show all of them in the specific day?

1
reporting-servicesmatrixssrs-2008ssrs-tablix
So for 2014-01-02 what do you want to see? – Ian Preston

1 Answers

0
votes

You have to click the matrix and select HideDuplicates to None. Like in the image below:

enter image description here

Maybe this topic might help you:

as well as this other one.