Loading ...
March 29th, 2008 by 
Yaron Assa
Update: ReporterManager now has its own support forum – please ask all questions there.
A new update is available for ReporterManager - Version 0.9.2!
This version includes several bug-fixes, as well as a new reporter - XML. Unlike QTP’s native report , this XML reporter can save its contents to disk with every report event, so you never have to worry about losing the log in case QTP hangs or crashes. If you’d like, you can even control the tradeoff between the reporter robustness to its performace, by setting the interval between each disk-write.
As the XML log can utilize an XSL stylesheet, it can become practically any type of report you’d like. HTML with rich tables, AJAX enabled report, CSV, plain text, etc. I’ve included a default XLS stylesheet, but you’re welcome to make one tailored to your own custom needs. In fact, we would love to get you custom XSL stylesheets, and include them in future releases of ReporterManager, for the benefit of the entire QTP community.
Here’s an example of an XML report as viewed with the default XLS stylesheet:
So go right ahead and download the new version:
Registeration is FREE, quick and private.
You can either Register or Login if you have already registered
Update: ReporterManager now has its own support forum – please ask all questions there.
Posted in ReporterManager
April 8th, 2008 at 10:23 pm
Thanks for the great reporting tool! This will allow our team to quickly standardize reporting functionality we are currently working on.
I did encounter a small bug where the ExcelEngine fails if the “Sheets in new workbook” setting (Excel’s Tools->Options dialog, General tab) is set to 1.
Easily fixed. Perhaps the below fix can be included in the next release. Until then, users can fix this minor inconvenience by following these steps:
1) Open Engines.vbs
2) Search for the CreateResultFile() function in the ExcelEngine class, the go down a few lines to the oEngine.Workbooks.Add statement (Line 1656 in version 9.21).
3)Add the following lines directly below the oEngine.Workbooks.Add statement:
If oEngine.Sheets.Count = 1 Then
oEngine.Sheets.Add
End If
April 9th, 2008 at 6:31 am
Thank you very much for the feedback, and the bug hunting!
April 10th, 2008 at 5:40 pm
I am not able follow the installation of this Tool.Can some one help me out
April 10th, 2008 at 6:52 pm
Sure thing.
Open the ZIP file.
Inside you’ll find a .CHM help file, explaining the general usage and other issues, as well as full code documentation.
Also, there’s a \Demo folder, with a QTP test demonstrating actual use of ReporterManager.
May 1st, 2008 at 10:31 pm
Hi There,
I am really thankful to you for providing this utility. I downloaded the utility however I can’t open the “Tests/ReporterDemo” with QTP 9.2, when I try to open the test with QTP it gives me an error that the file is modified with later version of QTP.
Any idea what’s going on?
I really appreciate your help.
May 2nd, 2008 at 4:52 am
The file is saved as a QTP 9.5 file.
You can either upgrade to 9.5 (which is recommended), or create a new test and:
1. Copy the contents of \Tests\VBS Backup\Demo.VBS into the test
2. Connect the test to all the files in the \Libraries directory
The new test you’ve created will be identical to the demo test.
May 22nd, 2008 at 1:28 am
hello Yaron,
thanks for the utilities…
I like these since I write some small utilities for my personal use. I want to try yours too…
But my question, my client has still QTP 8.2, will your utilities work for QTP 8.2?
May 22nd, 2008 at 9:49 am
Most of it will. The XML engine requires DotNetFactory, and it wil not work under 8.2
May 25th, 2008 at 5:14 pm
pls give solution for html reporting…
May 30th, 2008 at 10:17 pm
Hello. Thank you for the tool! Can you, please, advice how to setup QTP (or tool) to use it for reporting?
Thanks.
June 6th, 2008 at 6:00 am
how can we use this?
June 23rd, 2008 at 1:22 pm
please tell from start how to use this tool?
June 26th, 2008 at 3:58 am
Great stuff…Thanks
July 2nd, 2008 at 7:03 pm
I’m trying to use the ExcelEngine, but Excel is not exiting after the test is completed. I’m writing 3 different reports (FullBackup, IterationCounter, and ErrorLog), which results in 3 separate instances of Excel after each test run. The resulting files are read-only and each instance absorbs memory.
I tried SystemUtil.CloseDescendentProcesses, but that doesn’t kill the Excel processes. Any hints/tips on how to clean up these processes after a test?
July 2nd, 2008 at 9:09 pm
Found it. Should have looked at the engine sooner. In Engines.VBS, the Report sub for ExcelEngine, I think you need to close the workbook object after saving it. (Add after line 1625)
Original:
‘Save the Workbook
objWorkBook.Save
Set objWorkBook = Nothing
Patched:
‘Save and Close the Workbook
objWorkBook.Save
objWorkBook.Close
Set objWorkBook = Nothing
July 28th, 2008 at 1:52 pm
Do You have any function so that it will automatically generate .xml and html report at the end of script execution?
July 30th, 2008 at 2:52 pm
Great support all the QTP learners & Implementors. Thanks!!!
September 4th, 2008 at 8:51 am
Hello!!! Thanks for the gr8 tool. It is really helpful to have such a report-manager. My only concern is that how to include the status of QTP provided checkpoints(Pass/Fail) in all the logs(xml, xl, csv, txt) along with the Call oReporterManager.Report(”…”) status?
Plz suggest!!!
September 15th, 2008 at 4:42 pm
I am frequently getting this popup error while using “oReporter.Manager.Report” in my project:
a) A file Named “ExecutionReport_1592008.xls already exist
September 15th, 2008 at 4:44 pm
sorry for that it was an incomplete statement.
I am frequently getting this popup error while using “oReporter.Manager.Report” in my project:
a) A file Named “ExecutionReport_1592008.xls already exist.Do you want to Replace it?”.
The oReporter.Manager.Report is not appending the report to an existing file name. Is this a bug of this oReporter.Manager.Report?
September 15th, 2008 at 5:19 pm
I think somewhere in the Engine.VBS something is missing.Can any one point out where it could have gone wrong.I am in the last stage of my project delivery due to this issue i am unable to deliver.The oReporter.Manager.Report is creating problem by throwing Excel popup Error when it wants to write any status to the excel sheet
October 21st, 2008 at 10:20 pm
I will appreciate if any body tell me how can i use this tool, i’m getting the following errror while trying to run it:
Variable is undefined: ‘oReprterManeger’
Line(11): “Call oReporterManager.StartEngine(”QTP”,”QTP”,”")”
October 21st, 2008 at 10:22 pm
I’ve followed the Yaron’s instructions i.e.
Yaron Assa Says:
May 2nd, 2008 at 4:52 am
[+]
The file is saved as a QTP 9.5 file. You can either upgrade to 9.5 (which is recommended), or create a new test and: 1. Copy the c… …
[Open ↓]
[-]
The file is saved as a QTP 9.5 file.
You can either upgrade to 9.5 (which is recommended), or create a new test and:
1. Copy the contents of \Tests\VBS Backup\Demo.VBS into the test
2. Connect the test to all the files in the \Libraries directory
The new test you’ve created will be identical to the demo test.
October 24th, 2008 at 2:21 pm
Hi,
I don’t know how to create multi Iteration for each QTPLog (XML report)
Please help!
November 3rd, 2008 at 7:15 am
There is no brief explanation about how to use this tool
can anyone help on this
thanks
sug
November 14th, 2008 at 2:39 pm
Hi Yaron Assa,
First of all, Great Thanks!!! Such a wonderful scripts… My long waiting ended here…
Can you please clarify me on following things?
1. How to change the TestCaseName?
2. How to change the Run Engine (means how do i get results in xml, html excel etc.) The default is Excel.
3. My scenario is I have 100 test cases need to be executed and each Cases may have 2 to 3 steps? Can you suggest me how to proceed?
Others also welcome to answer..
Thanks a lot.. GOD Bless
Ram
November 14th, 2008 at 3:26 pm
Hi All,
Just went through all files and can anyone please suggest me how to do the following?
I have created all the Test cases in single action but in the Report, Test case name is based on Actions..
What I need is:
1. I want to add Test Case ID
2. I want to change the Test case name (All the testcases are in single Action)
Can anyone suggest how to achieve the same..
Very thanks to all..
Ram
November 15th, 2008 at 10:09 am
Hey Ram,
To handle the TestCaseName issue:
In the Engines.VBS file, go to line 1512. It should be within the Report sub of the ExcelEngine class. It should look like this:
TestcaseName = Environment(”ActionName”) & ” > Iteration (Test-Action) = ” & Environment(”TestIteration”) & “-” & Environment(”ActionIteration”)
As you can see, the test case name is a combination of the action name, test iteration, and action iteration.
You can change it to whatever you like. For example, lets say you can an environment variable while holds the TestCase id, you can just use it:
TestcaseName = Environment(”TestCaseID”)
Or if you’d like to only use the action name:
TestcaseName = Environment(”ActionName”)
Or any other combination you may wish.
You can make the line react to one of the parameters you send to the report function. For example:
If sStepName = “Change Test Case” then
TestcaseName = sDetails
End If
This means that every time your report a step named “Change Test Case”, the test case will change to the details you supply. So you can use:
Call oReporterManager.Report (”General”, “Change Test Case”, “”, “”, “TestCaseID - TestCaseName”)
Manipulating this line will solve both your need to add the TestCaseID, and the problem with the multiple iterations.
Whenever the test name differs, a new section will be created in the report.
As for changing the run engine:
You can start an new engine via the .StartEngine command. As the demo file shows, you may start multiple engines that will work together.
For example, adding this line at the top of your test will start the XML engine in its default settings:
Call oReporterManager.StartEngine(”XML”, “XML Backup”, “File>C:\Logs\QTPLog.XML”)
Please read the supplied .CHM help file for more details.
November 18th, 2008 at 5:58 pm
[…] download the latest version – look here. Was this article useful? Rate […]
November 19th, 2008 at 9:43 am
[…] Yaron Assa, co-founder and CTO of SOLMAR was also nominated in recognition of his ground breaking Reporter Manager, which was contributed to the Quicktest Professional community worldwide. The award entitles Dani […]
November 26th, 2008 at 5:16 am
There are always creative thing happens. QTP itself report is not organized well. Especially when we adopt functions to composite test case. I am interesting in the reporter manager. Thanks for your contribution.
December 19th, 2008 at 3:37 pm
Hi Yaron
Thank you for the nice scripts. Could you clarify how i can get error which was produced by QTP. For example QTP doesn’t found some window and report this event in it’s own log but i need to have this in xml log.