I'm automating a daily report that needs to be emailed out in word document format.
The report has some typed text from the test manager regarding the current status, issues, etc. We would like to include some of the graphs from Quality center but I'm trying to avoid copy and pasting them from QC and have the report more automated.
Is there somewhere in QC that the SQL needed to generate the reports is stored or do we have to try and recreate it ourselves. My goal here is to connect to QC from Excel grab the data I need then create the graph and copy into a word template. The user would then just add her comments and send it out.
Any ideas would be appearciated
Besides the use of external tools, as suggested by qarom, there are several ways to achieve your goal.
1. Use the OTA API to get the graph data in Excel. Almost every "factory" has Build...Graph methods that return a Graph object. It's relatively obvious to populate an Excel Range from the Graph Data. The methods allow you to define a filter and all the parameters you define when building a graph in the QC user interface.
2. Mimic the document generator to include the graphs in a Word document. You can find how it is done by looking for a TDMain.dot file in your TEMP directory after you used the document generator. IMHO, the output is not worth the work....
3. Use the Excel reports with post processing to create the graphs, which means that you have to define some SQL query. You can see most of the queries made by QC when you set the log level for the QC server to Debug (refer to the admin guide). Note that most of the progression graphs are built with several queries, some of which create temporary tables...