I am trying to modify the SQL Server Reporting Services Build Summary report to include a little more information. What I want to do is add two more rows, then insert a table into each of the rows. One table will have all the passed tests for the build and
one table will have all the failed tests for the build.
I successfully modified the dsBuilds dataset in Report Builder 3.0 to do this and everything works except for one little annoyance. Lets say the build had 1 passed tests, "passedTestA", and 3 failed tests. The passed table will have 3 passed tests in it
all name "passedTestA" when there should only be one passed tests.
Heres that part of the query that is getting the passed/failed tests:
SELECT ResultTest As FailedTests, ResultErrorMessage, BuildName
WHERE ResultOutcome = N'Failed'
SELECT ResultTest As PassedTests, BuildName
WHERE ResultOutcome = N'Passed'
FROM @Results r
LEFT OUTER JOIN AllPassedTests pt ON r.BuildName = pt.BuildName
LEFT OUTER JOIN AllFailedTests ft ON r.BuildName = ft.BuildName
I pretty much self taught myself this query language yesterday so I dont know much about joining and it is when I a
View Complete Post