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

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

Project Management System ER Diagram

-
Image
  This article will discuss the step by step process on how to prepare the entity relationship diagram or ERD of the project entitled Project Management System. Project Management System is an information system that will manage the processes and transactions involved in monitoring and recording the updates of a project. The said project can be implemented in an offline settings but in most cases this is implemented in a live server or it simply means an online system. The first step in the development of the Project Management System is to prepare the ER diagram that will serve as the basis later on in the creation of the actual database. We will create and explain the process of making the entity relationship diagram of project management system. Let’s start from the symbols used in the ER Diagram. Entity is represented by the rectangle shape. The entity will be our database table of Project Management System later on. Attribute is represented by the oval shape. This will be the ...
Read more