How to Create Word Reports

    This tutorial illustrates the creation of Word reports. It is presumed that you are familiar with common NPrinting procedures.

    The data of one QlikView object and the images of two others are going to embedded in a Word report and two QlikView variables are going to be used in a heading.

    Open an existing NPrinting document or a new one. We will use a sample QlikView document, SalesDemo.qvw, for this tutorial. It is part of the NPrinting Training Materials that you need to download and expand into C:\NPrintingTraining\ so that the the relative path structure continues to be valid. Establish a connection to it (see: How do I connect to my QlikView documents?).

    Add New Word Report

                       
                Add-New-Word-Report.png                   
             
    1. Select Reports in the lower left pane
    2. Select the Word reports in the pane immediately above
    3. Click on the Word Report icon in the New group of the tool bar

    Creating New Word Report

                       
                Creating-New-Word-Report.png                   
             
    1. Enter an appropriate Name
    2. Enter optionally a Description for your report
    3. Click on New in the Template group of the tool ribbon

    Open Select Objects Window

                       
                Open-Select-Objects-Window.png                   
             
    1. Right click on the Images node
    2. Click on the Add objects pop-up button

    You can select multiple values by keeping CTRL or SHIFT pressed during column selection then "drag and drop" them onto the template. This will create a Microsoft Word table with the selected columns. Dragging and dropping multiple tags into an existing Microsoft Word table will add new cells to the row.

    Select QlikView Objects to Add as Images

                       
                Select-QlikView-Objects-to-Add-as-Images.png                   
             
    1. Select the Connection to the QlikView documnet that contains the entities you want
    2. Enter the letters or numbers that the entity identifiers have in common till you can see the entities in the list
    3. Select the QlikView objects CH186 and CH212 in the Select Objects window to be included in your template as images
    4. Select the OK button

    Embed Images in Template

                       
                Embed-Images-in-Template.png                   
             
    1. Expand the Images node in the left pane by clicking on the '+' to its left
    2. Drag and drop the CH186 and CH212 tokens onto the page

    After "dragging and dropping" an image into the template it might be necessary to wait for a few seconds so NPrinting can retrieve the preview. You can then re-size and/or move the images onto the page just as in any Word document.

    Open Select Variables Window

                       
                Open-Select-Variables-Window.png                   
             
    1. Right click on the Variables node
    2. Click on the Add variables pop-up button

    Add Variables for Heading

                       
                Add-Variables-for-Heading.png                   
             
    1. Select the Connection to the QlikView document that contains the entities you want
    2. Enter the letters or numbers that the entity identifiers have in common until you can see the entities in the list
    3. Select the vLastYear and vCurrentYear variables from the list in the Select Variables window
    4. Select the OK button

    Open Header Editor

                       
                Open-Header-Editor.png                   
             
    1. Right click anywhere at the top of the page and the Edit Header pop-up button will appear
    2. Click on the Edit Header button to start creating header content

    Create and Format Heading

                       
                Create-and-Format-Heading.png                   
             
    1. Expand the Variables node in the left pane by clicking on the '+' to its left
    2. Drag and drop the V\vCurrentYear and V\vLastYear node tokens into the header section of the page and compose the heading
    3. Highlight the heading and format it using Word formatting tools

    Close Header Editor

                       
                Close-Header-Editor-.png                   
             
    1. Select the Design tab
    2. Click on the Close Header and Footer icon in the Close group

    Open Select Object as Table Window

                       
                Open-Select-Object-as-Table-Window.png                   
             
    1. Right click on the Tables node icon or label in the left pane
    2. Click on the Add objects pop-up button

    Select Object to Add as Table

                       
                Select-Object-to-Add-as-Table.png                   
             
    1. Select the Connection to the QlikView document that contains the entities you want
    2. Begin entering an entity identifier, either its Name or its ID, until you can see the entity you are looking for in the list
    3. Select the Top 25 Products - CH184 in the Select Objects window
    4. Click on the OK button

    Embed Table

                       
                Embed-Table.png                   
             
    1. Move the two charts from the left side to the right to create an empty space
    2. Select Expand the Tables node in the left pane by clicking on the '+' to its left
    3. Drag and drop the Top 25 Products - CH184 node token onto the page

    Preview Resulting Word Report

                       
                Preview-Resulting-Word-Report.png                   
             

    Select Preview in the Actions group in the Report window

    The Result

                       
                The-Result.png                   
             

    The resulting Word report looks like this.