Reports with multiple connections

Reports can contain objects from more than one QlikView document or Qlik Sense app.

You can download the Sales Demo files at Sample files

Creating a new connection

Do the following:

  1. Select Apps from the Qlik NPrinting main menu, and then select Connections.
  2. Click Create connection.
  1. Enter a Name for the connection. For example, enter Budget.
  2. Select Sales Demo from the App drop-down list.
  3. Enter the complete document path of the QlikView document that you want to add. If the .qvw file is saved on the computer where Qlik NPrinting is installed, the path is relative to that computer.

    In this example, enter C:\NPrintingServer\QlikViewDocuments\Samples\Budget.qvw. To open a document from a network location you must use the Universal Naming Convention in the path. You can also open a .qvw file from a QlikView server.

  4. Click Create.

    The generation of the cache starts automatically. You have to wait until the end of the process to be able to use objects from this document in your reports.

Creating a new Excel report

Do the following:

  1. Select Reports in the Qlik NPrinting main menu, and then click Create report.
  2. Enter Simple MultiDoc Excel Report as the Title.
  3. Select Excel from the Type drop-down list.
  4. Select an app from the App drop-down list.
  5. Leave Enabled check box selected.

    If you clear the Enabled check box, the report will persist in the repository but will not be generated. This can be useful during the development of the report. You can select Enabled when the development of the report is complete. You may also want to clear Enabled to prevent the generation of a report that you want to save for the future.

  6. Click Create to create the report.
  7. Click Edit template to open the Template Editor.

Adding an object from Budget to the template

Do the following:

  1. Right-click the Tables node, and then select Add objects.
  2. Open the Connection drop-down list in the Select Objects window and select Budget.
  3. Find and select the CH332 - Top 5 Products object in the objects list.

    You can use Search to find the object name or ID.

  4. Click OK.

    You can also double-click the object row to add it to the node of the preview.

  5. Drag the CH332 - Top 5 Products node onto a cell on the template, for example, B6.

    The object tag, <CH332>, is replaced by its content in the QlikView document when the report is generated.

Adding an object from Sales Demo to the template

Do the following:

  1. Right-click the Tables node, and then select Add objects.
  2. Open the Connection drop-down list in the Select Objects window and select Sales Demo.
  3. Select CH317 - Top 5 Products from the list.
  4. Click OK.
  5. Drag the CH317 - Top 5 Products node onto cell B10 in the template.

Running a preview

You can check the final report, filled with your data, at any time during development.

Do the following:

  1. Click the Preview icon in the ribbon bar to get a preview in the default output format.
  2. Open the drop-down menu by clicking the small arrow under the lens to select a different output format among the ones available.

The report is populated with two tables from two distinct QlikView documents.

Saving the template

Do the following:

  1. Click the small disk icon in the upper left corner of the window title bar to save the template.

    Save frequently because there is no auto-save feature.

  2. When you have finished editing the report template, click Save and Close to save the template and close the Template Editor.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?