Home › Discussions › Questions & Answers › Preventing SQL Exposure in Delivered Excel Files

Preventing SQL Exposure in Delivered Excel Files

Avatar photoCustomer Questions & Answers 5 replies

We are distributing reports to external parties via XLSX files and need to ensure the report’s source SQL is not included in the output file itself. Which profile option controls this?

5 replies

  • Support Enginatics

    You should set the profile option ‘Blitz Report Include SQL in XLSX Output’ to ‘No’. This ensures the report SQL is not included on the parameter tab of Blitz Report XLSX output files.

  • Avatar photoCustomer

    What is the default behavior for this profile?

  • Support Enginatics

    The default setting is ‘Yes’ (meaning the SQL is included).

  • Avatar photoCustomer

    Does this only affect the main data sheet?

  • Support Enginatics

    No, this profile specifically controls the inclusion of the SQL on the parameter tab of the XLSX output file.

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