Can I Apply Word Formatting to my NPrinting Word Reports?

    Description: When creating templates for generating Word reports, you might sometimes want to present information with the formatting as it is in QlikView. This is the default setting. Other times you might want to apply formatting using the tools that Word provides. We are going to deselect Keep Source Formats for the table as a whole and then apply Word provided formatting. Table formatting using tools provided by Word work only if you save your template in .docx format and not if your template is saved in .doc format. Save Word templates in .doc format only if necessary for backward compatibility.

    Allow Application of Word Formatting for Whole Chart

    Allow-Application-of-Word-Formatting-for-Whole-Cha.png

     

    After you have added a QlikView object as a table:

    1. Click on the table node
    2. Uncheck the Keep Source Formats box and click on OK at the bottom of the Properties dialog window. If you don't find the Properties windows, right click on the table node and select Properties...
    3. Click on the Toolbar button.
    This will cause the contents of all cells in all columns of the table to be exported from QlikView without formatting.

    Wrap Text Feature

    Wrap-Text-Feature.png

    Checking Wrap Text causes NPrinting to automatically create two lines if the cell is too small. This works only with Keep Source Formats unchecked. Wrap Text is a Table property that affects all columns of the table.

    Resulting Unformatted Table

    Resulting-Unformatted-Table.png

    Not very nice. Now, to apply Word formatting.

    Apply Word Formatting to Entire Table

    Apply-Word-Formatting-to-Entire-Table.jpg
    Before adding the table to the template:
    1. Select the Insert tab on the toolbar
    2. Select Table
    3. Select the uppermost left cell to insert a 1x1 Table into the template

    Add Your Table to the Template

    Add-Your-Table-to-the-Template.jpg
    1. Expand the CH184 - Top 25 Products node by clicking on the '+' to its left if necessary
    2. You can select multiple values by keeping CTRL or SHIFT pressed during the columns selection
    3. "Drag and drop" them into the template. This will create all tags and insert them into a horizontal series of cells.

    Set Table to AutoFit Columns

    Set-Table-to-AutoFit-Columns-.jpg
    1. Select the Layout tab in the Table Tools section of the toolbar
    2. Click on AutoFit in the Cell Size section of the toolbar
    3. Select AutoFit Contents

    Apply Table Style

    Apply-Table-Style.png
    After selecting the table:
    1. Select the Design tab in the Table Tools section of the toolbar
    2. Select a general style in the Table Styles section of the toolbar

    Prepare to Preview

    Prepare-to-Preview.png

    1. Click on Save As and save the template
    2. Close

     

     

    Preview

    Preview.png

     

    1. Click on Preview in the Actions section of the toolbar.

     

    Inspect Result

    Inspect-Result.png