Home Discussions Questions & Answers Hyperlinks in Blitz Report™

Hyperlinks in Blitz Report™

Avatar photoCustomer April 16, 2020 at 1:33 am

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?

Viewing 8 reply threads
  • Author
    Replies
    • Support April 17, 2020 at 4:04 am  

      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.

    • Avatar photoCustomer April 17, 2020 at 3:57 pm  

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

    • Support April 19, 2020 at 2:34 am  

      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.

    • Avatar photoCustomer April 20, 2020 at 4:49 am  

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

    • Support April 20, 2020 at 5:49 pm  

      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.

    • Avatar photoCustomer April 22, 2020 at 8:15 pm  

      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 April 23, 2020 at 2:20 am  

      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.

    • Avatar photoCustomer April 23, 2020 at 11:49 pm  

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

    • Support April 25, 2020 at 3:44 am  

      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.

Viewing 8 reply threads
  • You must be logged in to reply to this post.

Login with: