Home › Discussions › Questions & Answers › Opening Blitz Report from Custom Forms (BLOB API)

Opening Blitz Report from Custom Forms (BLOB API)

Avatar photoCustomer Questions & Answers 7 replies

We need to integrate a report directly into a custom Oracle form, such that clicking a button generates and downloads the Excel file instantly. How do I achieve the download functionality after generating the report via the BLOB API?

7 replies

  • Support Enginatics

    After running the report using the `XXEN_API.run_report` procedure (which returns the output as a BLOB), you must use the procedure **`xxen_utils.download_file`**.

  • Avatar photoCustomer

    What argument does `xxen_utils.download_file` expect?

  • Support Enginatics

    It expects the file ID, which you retrieve by calling `xxen_api.report_file_id(l_run_id)`, where `l_run_id` is the ID generated when you initiated the run using `xxen_api.create_run_id_`.

  • Avatar photoCustomer

    Does this form code require any additional attached libraries?

  • Support Enginatics

    Yes, the `xxen_utils.download_file` procedure is included in the **`XXEN.pll`** library, so you must ensure this library is attached to your custom form to use the functionality.

  • Avatar photoCustomer

    Is the BLOB API method (using `run_report`) suitable for very long-running reports?

  • Support Enginatics

    The BLOB API is generally used for synchronous reporting, suitable for immediate drill-downs or quick previews, but long-running reports are typically submitted asynchronously using the concurrent program API (`report_submit_concurrent_`).

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