none
Calendar Matrix Report - more values in one field

    Question

  • 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?

    Thursday, March 06, 2014 9:58 AM

Answers