I am trying to create a new Default layout for "Interactive Reports" so that when user tries to download the data by navigating to "Actions -> Download -> RTF" from the interactive report it should call the new word template that I have created using BI publisher instead of the default layout.
Please advise me on how to implement this. I am using Oracle APEX version 5.1.3.
Thanks, Ashlesh.
You have to configure oracle APEX with BI Publisher check it https://www.youtube.com/watch?v=H1knIDsjn1A
I was going though the APEX developers guide and found that "Interactive Reports" do not support custom layouts.
"Note: Interactive reports do not support a custom report layout." (section Developing Reports 10-83 in APEX developer guide) this was in APEX 5.0, can some one confirm if this is the case in 5.1.3 as well ?
Finally, I was able to resolve this issue by following the approach stated below.
1) "Note: Interactive reports do not support a custom report layout." (section Developing Reports 10-83 in APEX developer guide) this was in APEX 5.0, can some one confirm if this is the case in 5.1.3 as well ?
2) By making use of the routine "DOWNLOAD_PRINT_DOCUMENT" (please refer "APEX API guide" for a detailed explanation), we can download the printed document.
3) The data to the printed doc can be provided via XML as BLOB or XML (in UTF-8 format) as CLOB to the routine "DOWNLOAD_PRINT_DOCUMENT".
4) Lastly, this call out to the "DOWNLOAD_PRINT_DOCUMENT" should be within a process to work
