Skip to main content

Member Articles

This forum is for user/member-created articles across the entire Qlik portfolio. Any member that is logged in can create and publish an article here. You must choose the appropriate label in order for the articles to be properly categorized.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST

How to Embed a QlikView Sheet in a Microsoft Office or HTML Report Template

cancel
Showing results for 
Search instead for 
Did you mean: 
Frank_S
Support
Support

How to Embed a QlikView Sheet in a Microsoft Office or HTML Report Template

Description: A QlikView sheet can be exported directly from QlikView as images. Supported formats are PNG, JPEG, BMP or GIF. NPrinting automatically sets the image dimensions to include the entire sheet.

A QlikView sheet can also be used in NPrinting Reports. Select the QlikView sheet you want to use in the list and add it as an image into a Microsoft Office, HTML or PixelPerfect report template. In this case the available output formats the ones supplied by the used report type.

Begin Creating New HTML Report

Begin-Creating-New-HTML-Report.png

  1. Select Reports in the lower left pane
  2. Select HTML reports in the upper left pane
  3. Click on the HTML Report icon in the New group of the tool bar

Identify Report

Identify-Report.png

  1. Enter HTML report containing a QlikView sheet as the Name of the report
  2. Enter a clarifying description (optional)

Open New Template in Template Editor

Open-New-Template-in-Template-Editor.png

Click on the New icon in the Template group of the tool bar

Open Select Objects Window to Add Sheet as Image

Open-Select-Objects-Window-to-Add-Sheet-as-Image.png

  1. Right click on the Images node
  2. Click on the Add objects button

Select Sheet Object

Select-Sheet-Object.png

  1. Select the Connection to the QlikView document that contains the Sheet you want
  2. Select the Dashboard - SH30 object
  3. Click on the OK button

Embed Sheet Object in Template and Preview

Embed-Sheet-Object-in-Template-and-Preview.png

  1. Drag the SH30 - Dashboard node token into the template and drop it on the line between the body tags
  2. Click on the upper part of the Preview icon in the Actions group of the tool bar

View Original Sheet in QlikView

View-Original-Sheet-in-QlikView.png

We want to export the entire sheet as a single image regardless QlikView window dimensions.

Run a report Preview

Run-a-report-Preview.png

Click on Preview

Preview Dashboard Image

Preview-Dashboard-Image.png

Notice that the aspect ratio and content of the preview image depend only on the aspect ratio and visible content of the sheet in QlikView. It doesn't depends on the visible dimensions of the QlikView window.

Begin Saving Your Report Template

Begin-Saving-Your-Report-Template.png

Click on the Save As icon in the Actions group of the tool bar

Save Your Report Template

Save-Your-Report-Template.png

  1. Browse to C:\NPrintingTraining\Templates if necessary
  2. Enter a File name or accept the suggested one
  3. Click on the Save button

Close the Template Editor

Close-the-Template-Editor.png

Click on Close (X) in the upper right corner of the editor window or click on Save and Close icon in the Actions group.

Save and Close HTML Report

Save-and-Close-HTML-Report.png

Qlick on the Save and Close icon in the Actions group

Save Current Content of NPrinting Project File

Save-Current-Content-of-NPrinting-Project-File.png

Click on the floppy disk icon in the upper left corner of the NPrinting application window next to the NPrinting coffee mug logo.

Version history
Last update:
‎2015-11-25 06:10 PM
Updated by: