Home › Discussions › Questions & Answers › Hyperlinks in Blitz Report™

Hyperlinks in Blitz Report™

Avatar photoCustomer Questions & Answers 9 replies

We need our report output to facilitate instant navigation back into the EBS forms or to external documents related to a specific record. Does Blitz Report support embedding clickable hyperlinks directly into the Excel output?

9 replies

  • Support Enginatics

    Yes, Blitz Report fully supports hyperlink functionality. This is a powerful feature that turns static reports into dynamic navigation tools, enabling deep drill-down features directly from the Excel file back into the source data within Oracle EBS or linking to external systems or document management.

  • How must the underlying SQL query be structured to output a column that is recognized by Blitz Report as a clickable hyperlink?

  • Support Enginatics

    The underlying SQL query must be crafted to construct the necessary URL string, often concatenating the EBS base URL, the function parameters (like form name, primary key ID), and the relevant field. Blitz Report recognizes this structured output and renders it as a clickable hyperlink in the resulting Excel file.

  • Does implementing hyperlinks in this way affect the speed of the report run?

  • Support Enginatics

    Since the calculation of the hyperlink URL is handled within the SQL query itself, the impact on performance is generally negligible, as the Blitz Report engine is optimized for high-speed SQL execution. The ability to deliver the required data as native Excel files contributes to this speed.

  • If we use the Zoom function to integrate a Blitz Report into an EBS form, is that different from embedding a hyperlink in the Excel output?

  • Support Enginatics

    They serve different stages of analysis. The Zoom function integrates the report execution *into* the EBS Forms experience for contextual access. Hyperlinks, conversely, allow users operating *outside* of EBS (within the exported Excel file) to click back into a specific record or document, providing traceability and immediate access post-export.

  • We need to ensure that when we update the URL or parameters for a hyperlink in a report, that change is logged.

  • Support Enginatics

    Because the hyperlink construction is part of the core SQL logic, any changes saved to that report definition benefit from full version control and audit history automatically managed by Blitz Report.

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