I am currently running a bunch of automated tests and recording the results in a SQL database. Has anyone built a reporting dashboard for automation results before? What are some good open source tools for doing so?
I suggest you to use fine reporting tool such as Allure framework. Here is an example of report:
Allure is based on standart xUnit results output but adds some supplementary data. Any report is generated in two steps. During test execution (first step) a small library called adapter attached to testing framework saves information about executed tests to XML files. We already provide adapters for popular Java, PHP, Ruby, Python, Scala and C# test frameworks.
Allure is provided by Yandex.
For more details: http://allure.qatools.ru/
Also, Jenkins or other CI servers provide some dashboard capabilities such as with https://wiki.jenkins-ci.org/display/JENKINS/Dashboard+View and with https://wiki.jenkins-ci.org/display/JENKINS/Sectioned+View+Plugin
ATU Graphical Reporter is an Open Source Reporting utility for TestNG. It is basically a listener for generating customized graphical reports. Following reports can be generated by this listener.
- Line Charts
- Bar Charts
- Pie Charts
Details from the report:
An Index page - A Start Page, you can set any Description in this page
A Consolidated Report Page - Displays all the Runs in the form of Line and Bar Charts
A Current Run Report Page - For each run, The Current Run page shows the number of Test cases executed in a tabular format along with the Iteration details, a Summary section and a Pie Chart
A Test Case Report Page - This Page gives the information about a Test Case with detailed steps in a tabular format along with the screenshot, a Summary section, Execution Platform details, Author Details and provides information about Failure / Skipped / Parameters
My experience: I have used this reporter in a Selenium WebDriver+TestNG project. It is easy to setup and creates a nice visually appealing report for each run.
Information taken from: http://automationtestingutilities.blogspot.in/2014/04/ATUReporterForTestNG.html