Hello experts, One of my requirement is to create a SSRS matrix report like the one blow. Year 2000 2001 2002 issues raised 100 200 300 issues resolved 50 150 250 issues put on hold 25 25 25 unknown issues 25 25 25 The column 1 is the measures(issues raised,issues resolved etc), column2,3,and 4(2000,2001,2002) are the date dimension. Here in the report, these dates column should allow drill down functionalities, there should be an option(+) on the year so that it can go to the quarter level and so on.I have already created the date heirarchy, all the measures and an extra dimension which holds the name of the measure(like issues raised,issues resolved etc), but not able to replicate the requirement. Is there any way I can do it? All your suggestions are welcome! Thanks in advance, Nikesh

If your date hiearchy is set Year, Quarter, Month then add a Matrix to the report. Set column group properties > group expression to DateHierarchy.Year. Add child group on DateHierarchy.Quarter. Add child group (of Quarter group) on DateHierarchy.Month. In your example, it appears that the left count is a demension akin to State or status. That would be your row group "group on" expression. If it is actually 4 measures (IssuesRaisedCount, IssuesResolvedCount, IssuesOnHoldCount and IssuesUnknownCount) then you just add 4 rows, one for each measure. Don't set a row group "group on" expression. In the left column enter the four labels as you show in your example. In the right cell, add the appropriate measure. In either case, open the group properties for each child column group and goto visibility. Set to hide. Turn on "Display can be toggled by this report item". Set the value to the name of the textbox in the parent group header cell. Repeat for all column header cells except the top most group. The child group header rows will remain visible however the header values will be hidden and the parent will have the + button. Because this is a matrix, you can't hide the whole header row like you can a data row.

Hi Tim Pacl, That really works!!! Thanks a milliom for your suggestion. Regards, Nikesh