Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying JasperReports for Java Developers
  • Table Of Contents Toc
JasperReports for Java Developers

JasperReports for Java Developers

3.9 (7)
close
close
JasperReports for Java Developers

JasperReports for Java Developers

3.9 (7)

Overview of this book

JasperReports is the world's most popular embeddable Java open source reporting library, providing Java developers with the power to easily create rich print and web reports. This book shows you exactly how to get started, and develop the skills to get the most from JasperReports. The book steers you through each point of report setup, to creating, designing, formatting, and exporting reports with data from a wide range of datasources, and integrating JasperReports with other Java frameworks. Starting with the basics of adding reporting capabilities to your application, and creating report templates you will first see how to produce your reports through the use of JRXML files, custom ANT targets, and then see preview them in both the browser and the native browser of JasperReports. Getting data into your reports is the next step, and you will see how to get data from a range of datasources, not only databases, but XML files, and Java Objects, among others. You will create better looking reports with formatting and grouping, as well as adding graphical elements to the report. You will export your reports to a range of different formats, including PDF and XML. Creating reports will be made even easier with a walkthrough of the iReport Designer visual designing tool. To round things off, you will see how to integrate your reports with other Java frameworks, using Spring or Hibernate to get data for the report, and Java Server Faces or Struts for presenting the report.
Table of Contents (13 chapters)
close
close
12
Index

Database for Our Reports

In this chapter, we will use a MySQL database to obtain data for our reports. The database is a subset of public domain data that can be downloaded from http://dl.flightstats.us. The original download is 1.3GB. However, we deleted most of the tables and a lot of the data to trim the download size considerably.

A MySQL dump of the modified database can be found at this book's website: http://www.packtpub.com/support.

The database contains the following tables: aircraft, aircraft_models, aircraft_types, aircraft_engines, and aircraft_engine_types. The database structure can be seen in the following diagram:

Database for Our Reports

Note

The FlightStats database uses the default MyISAM MySQL engine, which does not support referential integrity (foreign keys). That is the reason for which we don't see any arrows in the diagram indicating dependencies between the tables.

Let us create a report that will show the most powerful aircraft in the database, say, those with a horsepower of...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
JasperReports for Java Developers
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon