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.

Note: If you choose .htm or .html as your output, you will always receive a .zip file containing all the file types needed to generate HTML.

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:

  • .ppt, .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

Excel reports
Type Folder Email NewsStand Hub
Single filename.format filename.format filename.format filename.format
Cycled filename.format .zip .zip .zip
Word reports
Type Folder Email NewsStand Hub
Single filename.format filename.format filename.format filename.format
Cycled filename.format .zip .zip .zip
PowerPoint reports
Type Folder Email NewsStand Hub
Single filename.format filename.format filename.format filename.format
Cycled filename.format .zip .zip .zip
HTML reports
Type Folder Email NewsStand Hub
Single .zip .zip .zip .zip
Cycled .zip .zip .zip .zip
PixelPerfect reports
Type Folder Email NewsStand Hub
Single filename.format filename.format filename.format filename.format
Cycled filename.format .zip .zip .zip
Qlik entity reports
Type Folder Email NewsStand Hub
Single filename.format filename.format filename.format filename.format
Cycled filename.format .zip .zip .zip

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?