Home › Discussions › Questions & Answers › Audit Archiving: Automating PDF Output Generation via Blitz Report Postprocessing Feature

Audit Archiving: Automating PDF Output Generation via Blitz Report Postprocessing Feature

Avatar photoCustomer Questions & Answers 5 replies

While Blitz Report excels at generating fast Excel output, our compliance requirements dictate that certain period-end reports must be archived in an uneditable PDF format. Using BI Publisher’s Output Post-Processing (OPP) is unreliable and complex for basic PDF conversion. Can the Blitz Report postprocessing feature be used to automatically invoke an external tool to Generate PDF output from the Excel file directly after report execution, satisfying our audit needs?

5 replies

  • Support Enginatics

    Yes, the powerful Blitz Report postprocessing feature is designed exactly for this purpose, allowing users to perform additional actions on the final output files, such as conversion via external tools. This bypasses traditional reliance on OPP management.

  • What external tools are typically recommended for the conversion from Excel/XLSX to PDF on a Linux server, and how do we integrate them via script?

  • Support Enginatics

    A highly recommended tool is Libre Office, which offers headless conversion capability on Linux. The conversion logic is placed within a custom post-process script (e.g., `generate_pdf.sh`) saved in the custom top directory, utilizing `libreoffice –headless –convert-to ‘pdf’` command syntax.

  • How do we trigger this script automatically, and can we ensure the PDF retains clear formatting, including cell borders?

  • Support Enginatics

    The script is triggered by setting the `Custom Postprocess` field value when running the report. To ensure clear visual formatting, users can enable the Blitz Report XLSX Cell Borders profile option, which applies borders to the Excel output, resulting in a cleaner, formatted PDF document upon conversion.

  • You must be logged in to reply to this post.