My current client would like a high level weekly report from Quality Center with information such as total number outstanding defects, number of requirements which no coverage, etc. I have had a play with the Project report generator in Quality Center 11 but it seems to generate all the information from a defect for example instead of just the number counts.
Just wondering what the best way is to produce a weekly status word report for managers without having to produce pages and pages of data detailing all the low level stuff about defects and requirements.
I'm going to look at retrieving the info from excel then using VBA to format and transfer the data to word but hoping there is an easier way.
I also looked at creating my own project templates using the generator but it requires Office 2007 and they are only on 2003 here
looks like a bit of confusion here. I cannot use the document generator as it requires Office 2007. The client only has Office 2003.
How can I include graphs from the dashboard module. When I Add a report section I don't get an option to included dashboard graphs
we use excel-reports to consolidate reports for our clients.
The first step is to export the graphs and lists to excel. In postprocessing a vba-script creates new pages as a management summary (2 pages with 6 graphs and text). Most of the time the summary is all our clients ever need.
If we have to write a summary in word, we use our excel-report and copy/paste it to word. [img]/images/graemlins/smirk.gif[/img]
Gavin, if you want a button that generates a Word document you'll need to ...
<ul type="square">[*] add a button[*]add button code to generate the Word document (Word automation, runs on the client)[/list]
You can either put together a new document or use some template that you'd insert data into.
Another way is to use the 3d party reporting tools to convert a custom report to Word. For example, MS SQL Server Reporting Services (SSRS) has a native integration with Word. Actually a generated word document is compatible with all versions of Word since Word 97.
Personally I rarely use the "convert to Word" feature. In order to provide a high level report to managers (and often to directors) I set an email subscription inside the Report Manager of SSRS with needed schedule. Managers are very happy to see the report in their inboxes. [img]/images/graemlins/smile.gif[/img]