All SSRS reports you get out of the box with TFS 2010 are trend reports and they don’t show any details. I was recently asked to build a custom report listing all test cases in a test plan and for each test case every step should be listed with action, expected result ant test outcome. Basically the same kind of info you can get for a single test case when you view the test results in Microsoft Test Manager 2010. This turned out to be quite a bit trickier than expected but after getting some much needed info from a developer at Microsoft (thank you Sriram) I was able to get it all together.
Getting test steps and results from Tfs_DefaultCollection
Test steps are stored as XML and are found in table WorkItemLongTexts. You can use this query to get them.
declare @fldIdSteps int = (Select top 1 fldid from Fields where ReferenceName = ‘Microsoft.VSTS.TCM.Steps’) select * from WorkItemLongTexts where FldID = @fldIdSteps
Test results for each step are found in table tbl_TestActionResult. You can use this query to get them.