This sql code snippet displays all tests cases and sums how many times they have passed and failed
Solution
1. Log into Site Admin
2. Select the project you would like to report on
3. Select the Bug table
4. Paste the following code in the SQL box
5. Press the Execute SQL button
SELECT t.ts_name, sum(decode(r.rn_status,'Passed',1,0)) as Pass, sum(decode(r.rn_status,'Failed',1,0)) as Fail FROM RUN r, TEST t WHERE t.ts_test_id = r.rn_test_id GROUP BY ts_name