- Description of Features
- Template Editor
- Multiple Drag and Drop
- Remove an entity
- Using ToolBox controls
- Rich Text
- Other Controls
- Export Formats and Advanced Properties
- PDF Advanced Properties
- CSV advanced properties
- JPG Advanced Properties
- TIFF Advanced Properties
This article will explain the new PixelPerfect features. PixelPerfect is the NPrinting application of “band reporting” which allows you pixel-level control over layout and appearance. Font size and color, image positioning and dimensions, an infinite amount of charts types and options and much more are all available with this release.
Description of Features
The PixelPerfect editor allows you to design structured templates. Using the Field List “treeview”, you can drag and drop images, cells, variables and formulas. You can also add levels to create tables or to repeat a segment of the report for each value of the field or the table used as level. Levels can be nested within one another to create a hierarchical view.
You can configure the appearance and behaviour of each object using its properties. They are entered in the Property Grid panel that you find on the bottom-left side of the editor. The articleProperties of PixelPerfect Labels, Table and Charts contains a complete description of the most frequently-used object properties.
To add Levels, right-click on the node “Levels”, then select “Add Levels” and choose an object from the list that appears. If you insert a QlikView field, the report segment will be repeated for each value of the field. For instance, if you select a QlikView table with a country and a salesman column, you’ll get a segment for each combination of country/salesman values.
Levels can be made hierarchical: to add a sub-level right-click on the name of an existing level, then select “Add Level” and choose the field or the table you want to insert.
Before adding a level in the template, select the destination band and right click on it; then click on “Insert Detail Report” and select the name of the level you wish to add. A new band will be created and it will be cycled by each value of the level. “Drag and drop” the level content to the band which will be transferred to the final report: a new Label containing the field information will be created.
To add a sub-level to an existing level, right-click on the parent level band in the Levels node. Next, right click on the parent band in the template editor and “Insert Detail Report” again then select the new level. Be sure the level you want to add already exists as a sub-level of the parent in the Field List “treeview”.
If you want to create a table in the final report you have to use Levels. Check this tutorial How to Create PixelPerfect Reports With a Level
In PixelPerfect templates, Tables are data sources for charts and sparklines. To add a table, right-click on the “Tables” node, then select “Add Objects” and click on desired object from the list that appears.
To learn more about chart creation, refer to the tutorial How to Create PixelPerfect Charts To learn more about Sparklines, refer to the tutorial How to Create PixelPerfect Reports with Sparklines
You can add images to your template. Right-click on the “Images” node in the Field List and choose “Add Objects”. Select a QlikView object from the list that appears, then drag and drop the new image onto the template. A new Picture Box will be created.
To specify the image position, select its area with the mouse and move it until you reach the desired position. To change the image area, select one of the blue squares on the corner or at the middle of a side and adjust to desired position.
Then, using the “Sizing” property, you can set the image behaviour. Possible values are:
- Normal: the image is inserted into its area with the original size. If the area is too small the image will be clipped keeping the alignment with the upper left corner
- Stretch Image: the image is stretched to fill both the control's width and height. Aspect ratio will be changed
- AutoSize: the final image keeps the original size of the image exported from QlikView. Other data in the final report will moved in order to maintain integrity of the report
- Center Image: the image is displayed in the center (horizontally and vertically) of the area with the QlikView dimensions. If the image is larger than the area, the image is cropped
- Zoom Image: the image is proportionally re-sized to fill the area while keeping aspect ratio. Image can both zoom-in or out
- Squeeze: if the area exceeds the image size, the image is centered and shown at full-size. Otherwise, the image is re-sized to fit into the area
To set other properties of the image, use the Property Grid.
It’s possible to add QlikView variables to your template. Right-click on the “Variables” node in the Field List, choose “Add Objects”, then select the variable you want to add from the list that appears. A new Label containing the variable’s information is created when you drag and drop the variable. You can set other variable properties using the Property Grid.
You can add formulas to your template. Right-click on the “Formulas” node in the Field List, choose “Add Formula”, then insert a name and the formula using QlikView syntax. Drag and drop it onto the template. A new Label containing the formula’s information will be created. By right-clicking over the formula name and selecting “Edit Formula”, you can edit the formula.
You can add specific cells from a QlikView object to your template. To do this, right-click on the “Cells” node in the Field List and choose “Add Cells”. Then insert a Name, click on the “dots” to the right of the label Object, then select a QlikView object from those that appear. Insert the number of rows desired on the top and bottom in addition to the number of columns. Then drag and drop each cell onto the report area. For each cell a new Label containing the cell’s information will be created. You can set other cell properties using the Property Grid. Notice that cells with a “0” in the row number refer to the QlikView table header. If the original QlikView object has totals on the first row, the cells with “1” as row number will contain the total. In this case the first cells with data is the one with “2” as row number.
Multiple Drag and Drop
To speed up template editing, you may select more than one entity in the Field List by pressing the SHIFT or CTRL buttons. Next, drag the items onto the template. When you drop them, a table containing your selected entities will be created. To drag and drop only the column headers, select the columns and drag them by pressing the “SHIFT” key or by right-clicking the mouse.
Remove an entity
To remove an entity from the Field List, right-click on it and select either “Remove Object” or “Remove Levels”.
Using ToolBox controls
The ToolBox on the right side of the editor allows you to insert some Control objects onto the template. For instance, you can insert Charts, Sparklines, Page break, Labels and many others. To insert a Control on your template, select it from the Toolbox then drag and drop it onto the template. You can set Control properties using the Property Grid.
To insert a fixed text or bind it to a source (eg. fields, variables or formulas) you need Labels. To insert a new label, select it from the Toolbar then drag and drop onto template. Insert your own text by double-clicking on the control, then typing over the text. You can bind a label to a data source by selecting it and clicking on the smart tag (the small arrow in the top right corner) then by opening the “Data Binding” menu. Be sure to select the proper data source. You can set other Label properties using the Property Grid.
You can develop awesome Charts from your QlikView data with NPrinting PixelPerfect. It’s not necessary for a chart to exists in a QlikView document to add it. NPrinting uses QlikView Tables as data sources for charts. You can also choose from a great variety of chart types to customize the appearance you want.
Drag a Chart object from the Toolbox in order to add the chart onto the template. A Wizard will appear. Follow the steps to select the data series and set properties.
A data series can be binded by going to the “Data” tab and choosing “Series Binding”, then by selecting the “Argument” and the “Values” for each series. Click on the columns of the tables already inserted in the Field List.
Following the other steps will help you customize presentation properties. You can also change properties by using the Property Grid panel or by reopening the wizard and clicking on smart tag and selecting “Run Wizard”. To jump to a specific property in the Wizard click on its name on the left side column.
You can insert a Chart inside a Level.
Refer to these tutorials:
- How to Create a PixelPerfect Chart
- How to Create a Well Formatted PixelPerfect Chart
- Properties of PixelPerfect Labels, Table and Charts
A sparkline is a very small line chart (typically drawn without axis) that presents the variation of a measurement typically over time. NPrinting PixelPerfect supports sparklines, so they can be inserted in your reports.
Sparklines need a table as the data source. So, first add a table in the Tables node, then select the sparkline object from the Toolbar and “drag/drop” it onto the template. To bind it with your data, click on the smart tag (the small arrow in the top right corner) then set the “Data Member” and “Value Member” properties.
You can insert a sparkline inside a Level; therefore, you can display a sparkline for each row of a table. To learn how to do this refer to the tutorial LINK
Use Rich Text to display information in many different formats. Select the Rich Text button from the Toolbar, drag and drop onto your template and double click on it to input data in edit mode. In edit mode you can type fixed text or drag and drop entities from the Field List: a field between square brackets will appear. Your can drag and drop variables, fields, formulas, images and cell values.
You can set other Rich Text properties using the Property Grid or the ribbon bar.
Rich Text also supports nested Levels.
Use Page Break, Zip Code, Panel or Line to customize your template.
Export Formats and Advanced Properties
PixelPerfect supports: Pdf, Html, Rtf, Xls, Xlsx, Csv, Png, Bmp, Gif, Jpg,Tiff and Mht formats. The default is PDF and it’s the best choice when you want total control of appearance. To display the Preview in another format, click on the arrow under the lens or set a specific output format in the task.
PDF Advanced Properties
By clicking on the dots under the “Advanced” column in a task that exports a PixelPerfect report as PDF, you can configure two properties:
- Report Security - set two passwords: one to open and another to write the PDF. Set the password source by:
- using recipient passwords
- using task passwords
- inserting two new passwords
- Quality - select the quality of images in the PDF
CSV advanced properties
By clicking on the dots under the “Advanced” column in a task that exports a PixelPerfect report as CSV, you can set these separators:
- White space
- Custom separator. Refer to How to Customize the Separator Character When Exporting QlikView Objects to CSV Files
JPG Advanced Properties
To specify the output quality, click on the dots under the “Advanced” column in a task that exports a PixelPerfect report as JPG. You can specify:
- High: 96 dpi
- Medium: 80 dpi
- Low: 60 dpi
TIFF Advanced Properties
By clicking on the dots under the “Advanced” column in a task that exports a PixelPerfect report as TIFF, you can select between creating one file per page or a single file with the entire report.