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 ![]() |
![]() | 3. On the Insert Field pane, select "QPR Metrics Models" from the 'Search From' drop-down menu and expand the hierarchy by clicking the ![]() |
![]() | 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 ![]() |
![]() | 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 ![]() |
![]() | 13. Save the document. It will be used later. |
![]() | 14. Click ![]() |
For more information, see the Fields topic in QPR Add-In for Microsoft Office - User's Guide.