locked
Archive Test Case And Test Result RRS feed

  • Question

  • Hi,

    Our management requires us to report all test results at the end or every release cycle. We need to report all test run data (including test steps and expected results) on a report that can be archived for later review.

    The data necessary is not available in the Warehouse and I can't find it in the Collection database.

    How can I create the report to archive all test run data.

    Thanks,

    Best Regards,

    Nico

    Monday, September 24, 2012 12:18 PM

Answers

  • We had a similar need with different data. Some was in the reporting db but a few fields were rich text and were therefore not reportable. Our solution was a hybrid report. We used SSRS to generate the report with the available reportable data. Where we needed no reportable data, we wrote a place holder with a standardized naming convention that identified the data that was needed. We then created a custom web page that would retrieve the report from the report server web services in HTML 4.0 format. We walked the report DOM to find the placeholder fields and using the info from the report and placeholder name, we leveraged the TFS API to retrieve that data from the transactional DB and insert it into the report.

    Since your needs, like ours, requires the report be archived, we then converted the HTML 4.0 report to mht so the report images (including all charts) would be embedded into the report prior to writing it to our archive location.


    • Edited by Tim Pacl Tuesday, September 25, 2012 10:39 PM
    • Marked as answer by Lily_WuModerator Thursday, September 27, 2012 7:24 AM
    Monday, September 24, 2012 2:13 PM

All replies

  • We had a similar need with different data. Some was in the reporting db but a few fields were rich text and were therefore not reportable. Our solution was a hybrid report. We used SSRS to generate the report with the available reportable data. Where we needed no reportable data, we wrote a place holder with a standardized naming convention that identified the data that was needed. We then created a custom web page that would retrieve the report from the report server web services in HTML 4.0 format. We walked the report DOM to find the placeholder fields and using the info from the report and placeholder name, we leveraged the TFS API to retrieve that data from the transactional DB and insert it into the report.

    Since your needs, like ours, requires the report be archived, we then converted the HTML 4.0 report to mht so the report images (including all charts) would be embedded into the report prior to writing it to our archive location.


    • Edited by Tim Pacl Tuesday, September 25, 2012 10:39 PM
    • Marked as answer by Lily_WuModerator Thursday, September 27, 2012 7:24 AM
    Monday, September 24, 2012 2:13 PM
  • Hi Nico,
     
    How about the issue now?
     
    I mark useful reply as answer. It will be very beneficial for other community members having the similar questions.

    If anything is unclear, you can unmark the post, and please free feel to let me know the problem.

    Best Regards,


    Lily Wu [MSFT]
    MSDN Community Support | Feedback to us

    Thursday, September 27, 2012 7:24 AM
    Moderator