Advanced Printing Apex Report

-

 

Declare
l_context        apex_exec.t_context;
l_highlights     apex_data_export.t_highlights;
l_export         apex_data_export.t_export;
l_print_config    apex_data_export.t_print_config;
begin
apex_data_export.add_highlight(
p_highlights          => l_highlights,
p_id                  => 1,
p_value_column        => ‘HIGHLIGHT_NAME’,
p_display_column      => null,
p_text_color          => ‘Black’,
p_background_color    =>  ‘Green’);

l_context := apex_exec.open_query_context(
p_location    => apex_exec.c_location_local_db,
p_sql_query   => ‘select nationality, country_code, case when name like ”%G%” then 1 end as HIGHLIGHT_NAME
from eba_countries’ );

l_print_config := apex_data_export.get_print_config(
p_body_font_color             => ‘Black’,
p_page_header                 => ‘Country’,
p_page_header_font_color      => ‘Black’,
p_page_header_font_size       => 14,
p_page_header_font_weight     => apex_data_export.c_font_weight_bold,
p_page_footer                 => ‘Country’,
p_page_footer_font_color      => ‘Black’,
p_page_footer_font_size       => 14,
p_page_footer_font_weight     => apex_data_export.c_font_weight_bold,
p_border_width                => 1,
p_border_color                => ‘Black’);

l_export := apex_data_export.export (
p_context      => l_context,
p_format       => ‘PDF’,
p_print_config => l_print_config,
p_highlights   => l_highlights );

apex_exec.close( l_context );

apex_data_export.download( p_export => l_export );

exception
when others then
apex_exec.close( l_context );
raise;
end;

Comments

Post a Comment

Popular posts from this blog

Install and Configure OBIEE 12c on Linux VM

-
Image
Install and Configure OBIEE 12c on Linux VM · 1 Today we are going to be installing Oracle BI 12c on our Linux Virtual Machine. If you have not already created an Oracle Linux VM, I wrote a blog on how to do this  here . If you have not already installed Oracle Database 19c on your Linux VM, I wrote a blog on how to do this  here . This blog also assumes that you have access to the sample HR dataset that comes pre-installed with Oracle Database 19c. I covered how to access this in the Oracle 19c installation blog that I mentioned above. Before we begin, I just wanted to say good luck  and … Starting-up and opening the database If you have not already done so, log-in to your Linux instance’s GUI. Your screen should look like this. First, let’s start our listener and open-up our database. Open a new terminal window and execute the following command to start your listener, if it is not already started. If it has already been started, the terminal will let you know. lsnrctl s...
Read more

Web Based Electricity Billing and Payment System with SMS Notification

-
  The proposed electricity billing and payment system is a web based system to be developed using PHP, MySQL and Bootstrap. It is intended to replace the manual process of operation into an automated one. The said project will have two subsystems namely the billing module and the payment module. The billing module is responsible for recording the monthly bills of its customer supported with sms notification to inform their clients about their respective bills in a faster way. Meanwhile the payment module is responsible for recording the payment of its customers, in this module collection report will be included to determine the amount collected and the amount to be collected for a specific period of time. The project will use the iTexMo SMS api for the sms notification part of the project and to make the project more convenient to use the researcher will also develop a mobile app for IOS and Android. Objectives The objectives of the proposed web based electricity billing and paymen...
Read more

How to create oracle APEX plugins

-
Image
  Oracle APEX (Application Express) plugins are custom components that can be added to APEX pages to extend the functionality of the application. To create an APEX plugin, you will need to have an understanding of HTML, CSS, JavaScript, and PL/SQL. Here are the general steps to create an APEX plugin: Create a new plugin in the APEX builder by going to Shared Components > Plugins. Define the plugin attributes, such as the name, type and others. Create the PL/SQL package that will contain the plugin’s functions and procedures. Create the plugin’s JavaScript and CSS files. Add the plugin to a page by going to the page’s properties and selecting the plugin from the “Plugins” section. Test the plugin and make any necessary adjustments. Let’s start building APEX plugins here is an example of creating a simple APEX plugin that adds a button to a page and displays an alert message when the button is clicked: Create a new plugin in the APEX builder by going to Shared Components > Plug...
Read more