In this chapter we will start to automate the creation of the second page of the hand built QPR Add-In for Microsoft Office Training Guide Hand Built Report.docx. For this we needs tags. Most tags needed in designing a report can be inserted by using the Insert Field pane.
Exercise 4: Generate a Measure Page Containing the Name and Graph of the Measure 'Number of Individual Customer Feedbacks'.
1. Create a new blank document. |
2. On the QPR tab of the ribbon, click Insert Field. The Insert Field pane opens. |
3. On the Insert Field pane, select "QPR Metrics Models" from the 'Search From' drop-down menu and expand the hierarchy by clicking the button: |
4. Select 'QPR Add-In for Microsoft Office Training Model' from the list: |
5. Type "feedback" in the 'Search Text' field: |
6. From the 'Scope' drop-down menu, expand the hierarchy by clicking the button, and uncheck everything else but 'Company scorecard': |
7. Make sure that the 'Include References' check box is unchecked. |
8. Click the Search button. |
9. From the 'Search Results', select "Number of individual feedbacks". |
10. In the 'Fields Available' section, check "Name" and "Element Graph": |
11. Click the Insert button. |
12. Close the Insert Field pane by clicking the button in the top right corner of the pane. The document should now look like this: |
13. Save the document. It will be used later. |
14. Click Publish and define a name and a location to the report. The report is then created and it should look as in the picture below: |
For more information, see the Fields topic in QPR Add-In for Microsoft Office - User's Guide.