First off, I don't think having PivotTables in Excel and having reports in SSRS are mutually exclusive. That said, there are a ton of tutorials on YouTube that cover this kind of thing. Look up SSRS + Drilldown, SSRS + DrillThrough and you should find a bunch of videos.

Hope that helps.