Reporting and automation

[dagb60bear]

I am looking at solutions for reporting.  I need to import my test complete checkpoint pass fail results into an existing word .docx format.   I only need to filter out the pass/fail checkpoints and import into the word document.  We are trying to automate our test reporting process.  

[LinoTadros]

Implement Events like OnLogError and OnLogMessage and others... to directly report the status of the test to a Word Document using COM Automation "Sys.OleObject(Word.Application")"

From there you can create a document and write to it from your events directly.

Hope that helps

-Lino

[dagb60bear]

I have a word doc could i put those results into my table using odbc

[AlexKaras]

Hi,

> using odbc

No, this is not possible because test results in TestComplete are not stored in database tables.

https://support.smartbear.com/testcomplete/docs/testing-with/log/working-with/from-tests.html help article may provide you with some ideas.

[tristaanogre]

While @AlexKaras  is TECHNICALLY correct, if you want to do the work, you could use direct ADO SQL queries to insert records into SQL tables.  So, it's possible, but you'd have to write the ADO/SQL code.

[AlexKaras]

Hi,

Just to clarify:

> I have a word doc could i put those results into my table using odbc

I got this question this way: "Can I get test results out of TestComplete's test log (using ODBC?) and insert them into existing table in the Word document (using ODBC?) ?"

My answer was based on the above understanding and for sure may appear to be incorrect if I got the question wrong.

[TanyaYatskovska]

Thanks for the help, Leaders!

@dagb60bear, which solution did you decide to use? Please share it with us.