Previous Page Next Page
In this part, we will focus on some advanced reporting features of JReport: how to use JReport Designer to create data resources and use the resources to build reports and library components; how the resources are published to JReport Server and managed on the server, etc..
The reports we build in this part are related to a fictional, mid-size retail coffee chain named Jinfonet Gourmet Java. All documents needed to run the business and drive decision-making are reports generated by JReport.
The business questions that JReport reports can answer include:
By integrating sophisticated reporting functionality in enterprise applications, organizations can access, analyze and deliver real-time data as well as unlock critical business data hidden within applications.
The reports access the same data storage as the applications of Jinfonet Gourmet Java:
JReport reports can pull data from any type of JDBC-accessible database, including Oracle, Sybase and Informix, or other data sources such as XML, SOAP web service and HIVE. The data store for Jinfonet Gourmet Java is an RDBMS and XML file. The applications of the company: inventory management system, store operations, supply chain management and order tracking, access and update the data store.
Reports created in this track are based on the built-in HyperSonic DBMS database and XML data source. The table below shows the tables in the DBMS and XML data sources. The DBMS Name/XML Name is the name of the table as it is known in the DBMS or XML data itself; the Table Name is the table name that is shown in the JReport Designer:
| DBMS database | ||
|---|---|---|
| DBMS Name | Table Name | Table Description |
| ACCOUNTMANAGERS | Account Managers | Jinfonet Gourmet Coffee employees |
| CONTACTS | Contacts | Customer contact information |
| CUSTOMERS | Customers | Customer name, contact, and address |
| ORDERS | Orders | Customer orders |
| ORDERSDETAIL | Orders Detail | Orders line items |
| PRODUCTS | Products | Product information |
| STOCKMARKET | Stock Market | Stock information |
| XML data source | ||
| XML Name | Table Name | Table Description |
| _Jinfonet | Jinfonet | |
| _Jinfonet_Employee | Employee | Jinfonet Gourmet Coffee employees |
| _Jinfonet_CompanyInfo | CompanyInfo | Company information |
| _Jinfonet_StockMarket | StockMarket | Stock information |
| _Jinfonet_Customer | Customer | Customer name, contact, and address |
| _Jinfonet_Customer_Order | Order | Customer orders |
| _Jinfonet_Customer_Order_OrderDetail | OrdersDetail | Orders line items |
| _Jinfonet_Catalog | Catalog | Product number and description for catalog |
| _Jinfonet_Catalog_Product | Product | Product information |
By mapping the actual data source names to JReport Designer names, report designers can work with more intuitive or customized names.
This part contains the following tracks:
Track 1: Creating Page Reports
Track 2: Creating Business Views
Track 4: Creating Library Components
Click the right arrow () below to begin reading the part.