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!
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!
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?
- Entity Graph: ALM enables users to generate graphs based on certain entity type such as requirements, tests, test instances, test runs or defects. …
- Step 1) Navigate to ‘Dashboard’ Tab.
- Step 2) Let us generate ‘Entity Graph’. …
- Step 3) The “Select Entity Type” Dialog is displayed to the user.
How do you automate an ALM report?
How do you run Testcases in ALM?
How do I export test cases from ALM to excel?
