1.how can we report the QTP test result in a different
excel sheet
2.

Answer Posted / puneeth

'Parameterization ... Data Table (Global Sheet) for Flight
Reservation


Invokeapplication "C:\Program Files\Mercury
Interactive\QuickTest
Professional\samples\flight\app\flight4a.exe"
'or
'SystemUtil.Run "C:\Program Files\Mercury
Interactive\QuickTest
Professional\samples\flight\app\flight4a.exe"

Dialog("Login").WinEdit("Agent Name:").Set
DataTable("Agent_Name", dtGlobalSheet)
Dialog("Login").WinEdit("Password:").Set
DataTable("Pword",dtGlobalSheet)
Dialog("Login").WinButton("OK").Click

If Window("Flight Reservation").Exist then
Window("Flight Reservation").WinMenu("Menu").Select "File;Exit"
DataTable.Value("Act_Res")="Pass"
Reporter.ReportEvent 0,"Login Details","Valid Values"
else
Dialog("Login").Activate
Dialog("Login").WinButton("Cancel").Click
DataTable.Value("Act_Res")="Fail"
Reporter.ReportEvent 1,"Login Details","Invalid Values"
End If

er=DataTable("Exp_Res",dtGlobalSheet)
ar=DataTable("Act_Res",dtGlobalSheet)
If Strcomp(er,ar)=0 Then
DataTable.Value("Remarks")="OK"
Else
DataTable.Value("Remarks")="Defect"
End If
DataTable.Export("D:\QTP9\LoginResults.xls")

Note: Create a data table in QTP and enter the following details
Agent_Name Pword Act_Res Exp_Res Remarks
puneeth mercury Pass
pooja mercury Pass
soumya mareiou Fail
mahesh miaoreu Fail
shivakumar mercury Pass

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to open a new test using quicktest professional?

573


i need qtp tutorial. pls send it to sridhar.k151@g mail.com

1639


Explain different type of event trigger option.

539


What are the features of quick test pro(qtp)?

536


Where we use data driver in qtp?

609






Hi All, I need code for how to execute qtp scripts from excell sheet

1463


What is difference between design time and run time data table?

587


What is use of object spy?

612


Hi, How Accessibility checkpoint in QTP can be implemented in the test script?

1610


How do Parameterization and Data-Driving relate to each other in QTP?

554


How do you handle multiple banners(at the top the page, the banner is scrolling) in a web page(Dont take the name property(regular expression))

1669


I want to do Certification course in QTP. For this I request you to suggest the best Tutorial in PDF format. Hence, if possible, kinldy mail PDF file to my mail-ID: sushmapokhriyal79@gmail.com

1496


how can we do the frame work in qtp

1602


What are metrics and matrix?

1365


Hi, Can we open a test in qtp10 which is saved in qtp 9.2?

1429