SSRS Matrix report with Drilldown/Subreport
Posted on 2010-11-12
I have a matrix report that contains a part number, partname and job number in the rows. The columns are the months/year for the next 12 months. The detail is a sum of parts due for each of those months.
I now want to add either a subreport or drilldown capability to the report. When you click the Job number it should show details about the job (amount of parts ordered, how many were shipped and on what date, how many are in process, etc.). I can get it to work with a drilldown report by setting the toggle item for all of the details to the job number. The issue I have is that the job number column looks like it is about 6" wide because of the details columns. I want it to be normal width until you click the toggle switch, then open up the details below the job number.
I have tried inserting a subreport into the matrix but have not had any luck. It doesn't seem to link the 2 reports correctly.
Any help on how to accomplish this would be appreciated. Please provide details, I am a novice with SSRS reports.