TestStand browse results from database

[rafal.kusmider]

Hello

I have a test sequence that generates lovely HTML report and also stores the results in a database using default schema of Generic Recordset. Is there a tool that can browse database and shows results in human readable form (like originally generated HTML)?

[WireWeaver]

There is a database viewer that ships with TestStand:

TestStand Help: Database Viewer Application

-Trent

[rafal.kusmider]

Thanks WireWaver. I did checked that out and it confirms that the data is there in "database friendly" form, not really human friendly form. Is there a way of converting data from database to HTML report?

[WireWeaver]

You'd have to write some code to query the database and generate the report. Is there any reason you want to generate HTML reports from the database rather than use the reports that are already generated?

[rafal.kusmider]

the scenario is as follows: A subcontractor performs test sequence. Right after it is done he can take a look at HTML report to see what is wrong, fix it and repeat test. Meanwhile all iterations are logged to on-line database.

After a while there is need to verify what were precise results of each step for device with known serial nr, i.e see the test result one more time but the original report is gone with subcontractor PC because he forgot to upload them.

Of course after each test sequence I can make Test Stand to upload the html to some ftp, but storing results in database is more convenient since it allows  running queries for statistical purposes.