The APEX Office Print (AOP) is used to export the data in the format we want, The data can come from the database, a REST or GraphQL web service, or even components like Reports as Interactive Report/grid, classic report …etc. from Oracle APEX.
APEX Office Print is classified into two types : Cloud and On-premise service.
APEX Office Print (AOP) Architecture.(Cloud Service) A cloud service, Were the interactions Going Between Browser -> Autonomous Database & Server -> APEX Database -> APEX Office Print(AOP) Server.(Data sent over the internet is in Jason). – We let our Oracle Autonomous Database and APEX talk to the APEX Office Print Cloud. – The benefit of using the Cloud service is printing the report using the latest version of APEX office print.
Install APEX office print in you Application
Go to APEX office print website https://www.apexofficeprint.com and create a account by Sign up, After Logged in you will be redirect to the Dash board page of your Cloud account.
APEX office print (AOP) Dashboard page of your AccountThis is the dashboard page for your APEX office print account. where you find the API key and other components. a) Your API- key b) The no of Print that are available for the month c) if your are out of subscription, Then buy the subscription for according to your usage. d) Your Account name and property.
Download The APEX office print (AOP)- software
APEX office print Download The AOP Software-To download the APEX office print software, Go to Getting Started menu, you see the wizard progress list, You will heading with the Welcome page, where you can prefer the Video to get familiar more about APEX office print (AOP). Then go to download, and get the AOP software. After downloaded unzip the downloaded file.
Installation of APEX office Print (AOP) in Application
Yeah lets install the AOP software in APEX Application, before installing the AOP software we need to run a script. Navigate to your Application Go to SQL-workshop inside that to SQL-scripts and select upload script button and select the file, and label a name to the script and run the script.
APEX office print (AOP) install plugin script installThe file is reside inside in the unzipped directory ( Go to DB directory inside you will find the file name called Aop_db_pkg.sql ).
NOTE: If you receive an ORA-01031 insufficient privileges on creation of the synonyms, ask a dba to grant the CREATE SYNONYM privilege to your schema.
APEX office print (AOP) install plugin Script ResultNote : All the 9 Scripts should run successfully with out Error
Time to install the plugins, Go to Shared components -> Select Plugins -> Choose import-> Select “import a File”, Go to unzipped install package -> Select “APEX” -> inside choose the “APEX-Version” of your Application -> Select(“dynamic_action_plugin_be_apexrnd_aop_da”) File. And install the plugin and click next, you will be end of the installation process, and you will see the conformation message.
APEX office print (AOP) Installation Plugin 
APEX office print (AOP) installation plugin - Component Setting pageAfter the conformation message, the wizard will Automatically redirected to Component setting page, In that You will see a field call API-key get the API key from the APEX Office Print(AOP) Dashboard, Now paste the API key in the field and click Apply changes button. That’s it now we are ready now to generate and customize the template.
Generating and Customizing the AOP Template
Choose a report in your Application, I have choose My Application called Comida ( It is in production, which helps to Supporting fight Covid-19 for Local community). In that Application There is a Report called Donation-List where all the past donation are Stored in there, let me show you haw to export the report . Now Open the page designer , for the particular page which contains the report, Now to export report, create a button – name it a “Print”
APEX office print (AOP) Export report Now create a dynamic action to the button which we have created, and set the event as “click“, In the true action set action as “APEX office Print-DA Plugin(AOP) ” which we can see in the Action drop down. In the setting down below, set the template type as AOP-template in the drop down.(By choosing AOP template we are telling the server to generate a default template which we can use to customize to our need, this avoids the need to build template from scratch). In the Data type field set as Region(s): classic report, interactive report, interactive grid. Your class report should have a static id now assign the static id in the region Static-ID field and set the affected element as null in the drop down, by default the value will be “item”, that’s it now save and run the page.
APEX office print (AOP) Customization report I have customized the button. according to my convenient. Now we are ready to download the template, so let get the template, click the button(print) now your template started to download. Once the template downloaded open the downloaded template and start to customize them to your convenient.
APEX office print (AOP) Print templateHere the “{#Donation}…..{/Donation }” represent the Starting and ending of the loop and inside the row represent the column of the report where you can remove them and customize it.
APEX office print (AOP) Printing the Report
Here we are one step ahead to print the report, I have customized the Template, and uploaded in to the static application file, Now copy the file name without the reference link, Go to your Dynamic action, and change the template Type to static application file. and set template source to “file name” paste the file name and the rest of the options remains same .
APEX office print (AOP) Upload the customized templateHere in the output Type can you set the output format easily with in a minute, Save and run the page, now click the “print” button your Customized APEX office print (AOP) – Report started to download you can see in this report I have achieved my requirements which are formatting, alignment, etc.….
APEX office print (AOP) Export report For further refence you can view the sample application in the APEX office print (AOP) – sample applications
THECanny Tech 