Report output formats

The output format of a published report depends on a number of factors. Each report type has different output format options. If a report is cycled, it will be published as a .zip file.

Single reports

A single uncompressed report will be published as a filename.format file. For example, you have an Excel report called GlobalSales with the output format set to PDF in the publish task. The output file will be global sales.pdf. The same filename.format naming structure applies to compressed files, except that .zip is added as the file extension: global sales.pdf.zip.

Each report type has different output format options:

• Excel: .xlsx, .xls, .xlsm, .tiff, .pdf, .html
• Word: .docx, .doc, .html, .pdf
• PowerPoint: .pptx, .pdf
• HTML: .html, .htm
• PixelPerfect: .pdf, .html, .xls, .xlsx, .png, .gif, .jpeg, .tiff

• QlikEntity: .bmp, .gif, .jpeg, .png, .csv, .skv, .tab

  If they are printable in QlikView, they can also be exported as .pdf or .tiff.

Cycled reports

Cycled reports are compressed as .zip files, regardless of report type. For example, you have an Excel report called SalesData that you want to cycle by country and year. Your data covers 3 countries and 2 years, and the output format is set to .xlsx. You will get 6 .xlsx files in a zip file:

1. SalesData_Country1_Year1.xlsx
2. SalesData_Country1_Year2.xlsx
3. SalesData_Country2_Year1.xlsx
4. SalesData_Country2_Year2.xlsx
5. SalesData_Country3_Year1.xlsx
6. SalesData_Country3_Year2.xlsx

Cycled HTML reports are processed a little differently. When HTML reports have cycling enabled, the output format is one .zip file for each report cycle. For example, you have a report with three fiscal years, and you set the Field to cycle in the publish task to fiscal year, you will get three filename.html.zip published reports.

Adding password protection to reports

You can password protect the following report output types. The original template type does not matter:

• .pptx
• .doc, .docx
• .xls, .xlsx, .xlsm
• .pdf

If you password protect cycled reports, the reports will be password protected, but not the .zip archive.

Published output type by report type