# Part III: Advanced Reporting

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 our reports can answer include:

- What were the Sales totals last month? Last year?
- Which regions had the highest sales? Which sales representative?
- Which product was the best selling last month? Last year?

### Reports deliver real-time data

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:

### Data sources used in the tracks

The data store for the company is an RDBMS and XML files. The applications of the company—inventory management system, store operations, supply chain management, and order tracking—access and update the data store.

For the reports that you will be creating and managing in this part, the data sources are predefined in a built-in HyperSonic DBMS database and an 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 reports in JReport Designer
- Track 2: Creating business views and web reports
- Track 3: Creating library components
- Track 4: Publishing, running and administering resources
- Track 5: Integrating reports with JSP

Click the right arrow () below to begin reading the part.