New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › UFT / QTP Beginners v
Customized HTML reports in QTP

Thread Rating:
  • 1 Vote(s) - 4 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Customized HTML reports in QTP
azeem Offline
Junior Member
**
Posts: 19
Threads: 5
Joined: Aug 2009
Reputation: 0
#1
Not Solved 04-08-2010, 09:11 PM
HI All,

I am planning to write reports in HTML as per the client request, he wants to see only results in a table and result should be either pass or fail.

Could you please help me in understanding the concept of Customized HTML reports in QTP, I was able to create table structure in HTML, but not sure where to embedd this code in QTP script or should I invoke any VBS file, Please help me with sample code "Highly Appreciable"

Thanks for your precious time and knowledge sharing...!!!

Thanks,
Azeem
Find
Reply
rdemers25 Offline
Junior Member
**
Posts: 25
Threads: 2
Joined: Jul 2009
Reputation: 0
#2
Not Solved 05-28-2010, 12:52 AM
When I used in TestPartner, what I did was I logged the information to a log file, then when the script was done, I converted that code to HTML. You could probably do the same thing in QTP.
Find
Reply
funajju Offline
Junior Member
**
Posts: 4
Threads: 0
Joined: Apr 2010
Reputation: 0
#3
Not Solved 05-28-2010, 11:47 AM
HI Azeem ,

I dont know whether it helps u or not.
But one thing In QTP Test Results window you can find VIew>> filter option >> where u can select checkboxes which are only pass or fail etc. & then go to File>> Export to HTML to ur Specific location.You can get the reports right
Find
Reply
basanth27 Offline
Moderator
*****
Posts: 1,003
Threads: 1
Joined: Jul 2009
Reputation: 5
#4
Not Solved 05-31-2010, 01:20 PM
Load your functions to the vbs and then execute it on qtp. or primitively you can just paste the code on qtp and execute it. Ultimately either way you should see the results on html.
Basanth
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.
Find
Reply
carr2805 Offline
Junior Member
**
Posts: 2
Threads: 1
Joined: Jul 2010
Reputation: 0
#5
Not Solved 07-07-2010, 04:02 AM
hello,

I have one question, after the test performed in case of error in the result
appears that the object has an error, the reason and parameter.

How to export it to excel in the case?

thanks

Mark
Find
Reply
Arun Prakash Offline
Junior Member
**
Posts: 34
Threads: 2
Joined: Sep 2009
Reputation: 0
#6
Not Solved 07-10-2010, 12:20 PM
Hi Azeem,

We can use write function using HTML for the same.
Code:
Public Function fnSetResultLog()

    Dim objFileSystemObject, objTextFileObject
    Dim objTempFile, objFolder
    Dim sFileText
    Dim iPos

    'Creating a folder appended with date and time
      bFinalStatus=True
    tmStartTime=now
    
      Set objFileSystemObject = CreateObject("Scripting.FileSystemObject")
    
    If  not objFileSystemObject.FolderExists(gsBasicFolder)Then
        Set objFolder=objFileSystemObject.createFolder(gsBasicFolder)
    End If
    
      Set objFileSystemObject = CreateObject("Scripting.FileSystemObject")

      If not objFileSystemObject.FileExists(gsReportFile)  Then
        'Creation of HTML file and a temp file if it does not exist already
        Set objTextFileObject= objFileSystemObject.CreateTextFile(gsReportFile, True)
        Set objTempFile= objFileSystemObject.CreateTextFile(gsTempFile, True)

        'Write initial content of file
        objTextFileObject.WriteLine "<!DOCTYPE HTML PUBLIC ""-//W3C//DTD HTML 4.0 Transitional//EN"">"
        objTextFileObject.WriteLine "<HTML><BODY><CENTER>"
        objTextFileObject.WriteLine "<H1><FONT COLOR=#990000 face=""Arial"">Result Log</FONT></H1><BR>"

        objTextFileObject.WriteLine "<TABLE ALIGN=""Center"" BORDER=""1"" WIDTH=40% CELLPADDING=""1"" >"
        objTextFileObject.WriteLine "<TR BGCOLOR=""#CCCC99"">"
        objTextFileObject.WriteLine "<TD align=""left"" valign=""top""><FONT COLOR=#559999 face=""Arial""><small><B>Total Test Cases Passed: 0</B></small></FONT></TD>"
        objTextFileObject.WriteLine "</TR>"
        objTextFileObject.WriteLine "<TR BGCOLOR=""#CCCC99"">"
        objTextFileObject.WriteLine "<TD align=""left"" valign=""top""><FONT COLOR=#559999 face=""Arial""><small><B>Total Test Cases Failed: 0</B></small></FONT></TD>"
        objTextFileObject.WriteLine "</TR>"
        objTextFileObject.WriteLine "</TABLE>"
        objTextFileObject.WriteLine "<BR>"
    Else
        'Setting the position of the file if the file is already created
        Set objTextFileObject= objFileSystemObject.OpenTextFile(gsReportFile,1)
        sFileText=objTextFileObject.readall
        iPos=instr(1,sFileText,"<!--LOGDETAILS-->",vbTextCompare)
        If iPos > 0 Then
            sFileText=mid(sFileText,1,iPos-1)
            objTextFileObject.close
        End If
        
        Set objTextFileObject= objFileSystemObject.OpenTextFile(gsReportFile, 2)
        objTextFileObject.write sFileText
        
        Set objTempFile= objFileSystemObject.OpenTextFile(gsTempFile, 8)
    End If
'=============== writing to the main file =======================================================
Code:
objTextFileObject.WriteLine "<TABLE ALIGN=""Center"" BORDER=""0"" WIDTH=100% CELLPADDING=""1"" >"
    objTextFileObject.WriteLine "<TR BGCOLOR=""#aeaeff"">"            
    objTextFileObject.WriteLine "<TH width=15% rowspan=""1"" align=""left"" valign=""top""><FONT COLOR=black face=""Arial""><small><B><a href=""#" & now &  """>"  & gsTestCaseID & "</a></B></small></FONT></TH>"
    objTextFileObject.WriteLine "<TH width=85% colspan=""5"" align=""left"" valign=""center""><FONT COLOR=black face=""Arial""><small>" & gsTestCaseDesc &   "</small></FONT></TH>"
    objTextFileObject.WriteLine "</TR>"
    objTextFileObject.WriteLine "<TR BGCOLOR=""#aeaeff"">"                      
    objTextFileObject.WriteLine "<TH width=50% colspan=""2""align=""left"" valign=""center""><FONT COLOR=black face=""Arial""><small>Date: " & now & "</small></FONT></TH>"
    objTextFileObject.WriteLine "<TH width=35% colspan=""3""align=""left"" valign=""center""><FONT COLOR=black face=""Arial""><small><B>Duration:</B></small></FONT></TH>"
    objTextFileObject.WriteLine "<TH width=15% align=""left"" valign=""center""><FONT COLOR=black face=""Arial""><small><B>Status:</B></small></FONT></TH>"
    objTextFileObject.WriteLine "</TR>"
    objTextFileObject.Close

'=============== writing to the temp file =======================================================
Code:
objTempFile.WriteLine "<!--LOGDETAILS-->"
    objTempFile.WriteLine "<BR>"
    objTempFile.WriteLine "<TABLE ALIGN=""Center"" BORDER=""1"" WIDTH=100% CELLPADDING=""1"" >"
    objTempFile.WriteLine "<TR BGCOLOR=""#996600"">"            
    objTempFile.WriteLine "<TH width=15% rowspan=""1"" align=""left"" valign=""top""><FONT COLOR=white face=""Arial""><small><B><a name=""" & now & """>" & gsTestCaseID & "</a></B></small></FONT></TH>"  
    objTempFile.WriteLine "<TH width=85% colspan=""5"" align=""left"" valign=""bottom""><FONT COLOR=white face=""Arial""><small>" & gsTestCaseDesc &  "</small></FONT></TH>"
    objTempFile.WriteLine "</TR>"
    objTempFile.WriteLine "<TR BGCOLOR=""#996600"">"            '#CCCC99
    objTempFile.WriteLine "<TH width=50% colspan=""2""align=""left"" valign=""center""><FONT COLOR=white face=""Arial""><small>Date: " & now & "</small></FONT></TH>"
    objTempFile.WriteLine "<TH width=35% colspan=""3""align=""left"" valign=""center""><FONT COLOR=white face=""Arial""><small><B>Duration:</B></small></FONT></TH>"
    objTempFile.WriteLine "<TH width=15% align=""left"" valign=""center""><FONT COLOR=white face=""Arial""><small><B>Status:</B></small></FONT></TH>"
    objTempFile.WriteLine "</TR>"
    
    objTempFile.WriteLine "<TR bgColor=#996600>"
    
    objTempFile.WriteLine "<TH width=""80""colspan=""1"" ><FONT COLOR=#FF9933 face=""Arial""><small>Test Case ID</small></FONT></TH>"
    objTempFile.WriteLine "<TH width=""80""colspan=""1"" ><FONT COLOR=#FF9933 face=""Arial""><small>Request ID</small></FONT></TH>"
    
    objTempFile.WriteLine "<TH width=""80""colspan=""1"" ><FONT COLOR=#FF9933 face=""Arial""><small>Step to be Preformed</small></FONT></TH>"
    objTempFile.WriteLine "<TH width=""80""colspan=""1"" ><FONT COLOR=#FF9933 face=""Arial""><small>Status</small></FONT></TH>"
    objTempFile.WriteLine "<TH width=""80""colspan=""2"" ><FONT COLOR=#FF9933 face=""Arial""><small>Snap Shots</small></FONT></TH>"

      objTempFile.WriteLine "</TR>"    
      objTempFile.Close

    Reporter.reportEvent micDone,"Starting Test","Starting Execution of Test Case : " & gsTestCaseID

End Function
this is a sample script to set the result log
Find
Reply
QTPScript Offline
Junior Member
**
Posts: 18
Threads: 1
Joined: Aug 2012
Reputation: 0
#7
Not Solved 08-29-2012, 09:57 PM
This Two Years old Post and still works for me.

I have question can we add Jquery in report ?
Find
Reply
dfwweb Offline
Junior Member
**
Posts: 1
Threads: 0
Joined: Feb 2013
Reputation: 0
#8
Not Solved 02-26-2013, 03:22 AM
I am trying to understand the process of creating HTML Reports in QTP. So we have executed the testcases written in Excel and now trying to generate the report in HTML using QTP. Can some one please help out!

I want to know how to write in QTP the following
-Be able to read the data in Excel - all the testcases excuted and then generate report in HTML.
Find
Reply
SureshVaratharajan Offline
Junior Member
**
Posts: 1
Threads: 0
Joined: Jun 2013
Reputation: 0
#9
Not Solved 06-17-2013, 04:19 PM
Hi,

How to use the above script for my project?
Find
Reply
vinod123 Offline
Senior Member
****
Posts: 323
Threads: 8
Joined: Nov 2011
Reputation: 4
#10
Not Solved 06-22-2013, 10:32 AM (This post was last modified: 06-22-2013, 10:35 AM by vinod123.)
instead of using the script try this registry tweak
HKEY_LOCAL_MACHINE\Software\Mercury Interactive\QuickTest Professional\Logger\Media\Log and modify Active DWORD from 0 to 1 This will create a folder with name log it will save a html file for the report. This will save ur time
Find
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  [UFT] Get text into DIV through HTML tag robertosalemi 2 5,560 03-29-2016, 09:43 PM
Last Post: robertosalemi
  How to attach HTML file to Email Naresh 0 3,084 04-06-2015, 02:04 PM
Last Post: Naresh
  Reports shayk1985 3 4,070 01-03-2013, 10:11 PM
Last Post: diya
  How to generate QTP report in a new file(html)? yogesh kancherla 5 14,968 10-21-2012, 04:52 PM
Last Post: yogesh kancherla
  How to open html file and update values in particular cell of a table in QTP? yogesh kancherla 2 6,126 10-11-2012, 05:59 PM
Last Post: yogesh kancherla

Forum Jump:


Users browsing this thread: 1 Guest(s)