Abstract
Database reporting is used to generate useful information from database for the purpose of data analysis and making business decisions. A reporting tool is a frontend interface that requests and executes backend database queries with certain restrictions and presents the data in a required format. We can make either our own reporting tool or use appropriate reporting tools provided by various vendors. Today, mostly all the organizations use these reporting services to analyze their business operations and decide future goals for the company. This project focused on generating web-based reports from Oracle database. Oracle provides a web application tool, Oracle Application Express (Oracle APEX), for developing applications using the Oracle database. I have used it to develop parameterized, drill-down, interactive, tabular and graphical reports from Oracle database. I have explored report features including linking columns in reports to other reports, sorting, data entry, control breaks, pagination, sums and downloading reports in PDF, HTML and XLS formats. Chart features allow users to view information in graphical format, drill down report on chart values. "Interactive Reporting" Regions in the tool enables dynamic end-users report customization. Users can change the report layout by applying filters, selecting to display particular columns, sorting and highlighting. Users can also define aggregations, customized chart, breaks, computations and group by reports. Each variation on the report can be saved as named report. The reports were developed using Company database schema that contains all tables with relationships and constraints. In order to create this database schema objects in Oracle database, we have created scripts and ran those scripts in Oracle database. The table data are loaded from “*.csv” files through SQL Developer Import Utility. This report illustrates on extracting crucial information from database tables and represent it in an appropriate format through detailed steps and examples including installation, configuration, implementing database schema and generating web based reports from Oracle database.