QPR Knowledge Base 2017.1

Tags

Tags

Previous topic Next topic No directory for this topic  

Tags

Previous topic Next topic Topic directory requires JavaScript Mail us feedback on this topic!  

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.

 

mouse_24 Exercise 4: Generate a Measure Page Containing the Name and Graph of the Measure 'Number of Individual Customer Feedbacks'.

 

BTN_AR131. Create a new blank document.
BTN_AR132. On the QPR tab of the ribbon, click btn_insert_field Insert Field. The Insert Field pane opens.
BTN_AR133. On the Insert Field pane, select "QPR Metrics Models" from the 'Search From' drop-down menu and expand the hierarchy by clicking the btn_expand_model_hierarchy button:

pic_insert_field_search_from_expanded

 

BTN_AR134. Select 'QPR Add-In for Microsoft Office Training Model' from the list:

pic_insert_field_search_from_model_selected

 

BTN_AR135. Type "feedback" in the 'Search Text' field:

pic_insert_field_search_text

 

BTN_AR136. From the 'Scope' drop-down menu, expand the hierarchy by clicking the btn_expand_model_hierarchy button, and uncheck everything else but 'Company scorecard':

pic_insert_field_scope

 

BTN_AR137. Make sure that the 'Include References' check box is unchecked.
BTN_AR138. Click the Search button.
BTN_AR139. From the 'Search Results', select "Number of individual feedbacks".
BTN_AR1310. In the 'Fields Available' section, check "Name" and "Element Graph":

pic_insert_field_select_fields

BTN_AR1311. Click the Insert button.
BTN_AR1312. Close the Insert Field pane by clicking the btn_close_pane button in the top right corner of the pane. The document should now look like this:

pic_insert_field_done

BTN_AR1313. Save the document. It will be used later.
BTN_AR1314. Click btn_publish 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:

pic_insert_field_published

 

For more information, see the Fields topic in QPR Add-In for Microsoft Office - User's Guide.