IF statement

[mahadevan.swamy]

Hi,

In QTP, I have a column in the data table which contains the name of the reports.

All Listed Invoices
Invoice List
Fleet Invoice and Details
Key To The Highway Invoice and Details
Fuels & Lubes Invoice and Details
Multiple Fuels & Lubes Invoice and Details

If QTP were to test the first two reports, it would work. The 3rd,
4th, 5th and 6th reports requires some navigation through the
application where I have use the Query function in the application to
sort out the reports. I would like to know how to generate an IF
statement after this line:

Code:

Browser("Reports").Page("Reports").WebList("s_0_1_7_0").Select DataTable("Select_a_Report", dtGlobalSheet)
Browser("Reports").Page("Reports").Link("Run Now").Click

Basically i need some syntax to capture the value from A3 and say:

Code:

If <syntax> = "Fleet Invoice and Details"
Then ..........
End IF

Please tell me the syntax to capture the value from cell A3. Thanks


Swamy

[stevol]

Code:

dim rep_name
rep_name= DataTable("xxx","yyy")

If rep_name = "Fleet Invoice and Details" Then
   ...
End If

where xxx= column name, yyy=sheet name

Other way: use Select Case Statement
Select Case rep_name
   Case "All Listed Invoices"
         ...
   Case "Fleet Invoice and Details"
         ...
   Case Else
         ...
End Select

[ssping]

Hello,

try this

Code:

if Browser("Reports").Page("Reports").WebList("s_0_1_7_0").value="Fleet Invoice and Details"  then

hope this helps.