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
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?
Would something like this work for you?
Andrew Sears, T4G Limited, http://www.performancepointing.com
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?