Calendar Matrix Report - more values in one field

Hi,

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.

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

March 6th, 2014 5:00am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics