How To Generate Test Execution Report In Alm

by

Ive attached a mock-up that I am looking is generated. Im not looking at the exact format, only the columns.

I need help with writing an sql query in excel report generator of ALM 11.0 to generate Test Execution summary report, the columns of the report being the execution date, no. of test cases attempted, no. of test cases attempted, passed and failed.

I dont have a hands-on with using excel report generator in ALM and am not an sql expert.

0 Sorted by:

Thanks for contributing an answer to Stack Overflow!

  • Please be sure to answer the question. Provide details and share your research!
  • Asking for help, clarification, or responding to other answers.
  • Making statements based on opinion; back them up with references or personal experience.

    • To learn more, see our tips on writing great answers. Draft saved Draft discarded

    2 Answers 2 Sorted by:

    On HP ALM 11 Go to Test Lab, select the folder that you want to generate graph for. At your right you will see a pane with Live Analysis hyperlink. Click on that which will open up a small window with various filter options.

    Select on X axis the field that has your tester details e.g. responsible tester or test designer, etc.

    On Y axis choose your required field like Status for test runs/cases

    Thats it your graph will be ready.

    Alternatively you can also use Analysis on the menu bar or can also use Management Module.

    Using the Graph Wizard you can use the TestSet Name and the Test Subject (Test Plan path) but the Test Lab path is not available.

    If you are confortable with SQL and Excel VBA you can create an Excel Report using queries to extract exactly the data you want and execute some script to format and add graphs to the generated Excel file. The same think may be possible using Business View, to create a Business View you need access to the QC/ALM backend.

    Thanks for contributing an answer to Software Quality Assurance & Testing Stack Exchange!

  • Please be sure to answer the question. Provide details and share your research!
  • Asking for help, clarification, or responding to other answers.
  • Making statements based on opinion; back them up with references or personal experience.

    • To learn more, see our tips on writing great answers. Draft saved Draft discarded

    FAQ

    How do I get a test execution report in ALM?

    Analysis View
    1. Entity Graph: ALM enables users to generate graphs based on certain entity type such as requirements, tests, test instances, test runs or defects. …
    2. Step 1) Navigate to ‘Dashboard’ Tab.
    3. Step 2) Let us generate ‘Entity Graph’. …
    4. Step 3) The “Select Entity Type” Dialog is displayed to the user.

    How do you automate an ALM report?

    How to Execute Test Cases Using ALM/QC. Step #1: In the Test lab tab, choose the test set that you would like to run and click on “Run Test” or “Run Test Set”. Run Test- will execute the test set selected and the “Run test set” will run the entire set one test after the other until the end. Click on “Being Run”.

    How do you run Testcases in ALM?

    How to Execute Test Cases Using ALM/QC. Step #1: In the Test lab tab, choose the test set that you would like to run and click on “Run Test” or “Run Test Set”. Run Test- will execute the test set selected and the “Run test set” will run the entire set one test after the other until the end. Click on “Being Run”.

    How do I export test cases from ALM to excel?

    How to Execute Test Cases Using ALM/QC. Step #1: In the Test lab tab, choose the test set that you would like to run and click on “Run Test” or “Run Test Set”. Run Test- will execute the test set selected and the “Run test set” will run the entire set one test after the other until the end. Click on “Being Run”.