You are previewing iReport 3.7.
O'Reilly logo
iReport 3.7

Book Description

Learn how to use iReport to create, design, format, and export reports

  • A step-by-step, example-oriented tutorial with lots of screenshots to guide the reader seamlessly through the book

  • Generate enterprise-level reports using iReport 3.7

  • Give your reports a professional look with built in templates

  • Create master/detail reports easily with the sub-report feature

  • Produce summary data and present them in a dynamic crosstab report

  • In Detail

    Although JasperReports is the world's most popular open source Java reporting library, it has always lacked one thing: It doesn't provide a tool to visually design reports. iReport is a visual report designer built on JasperReports that fills that lack. It is an intuitive and easy-to-use visual report builder/designer for JasperReports, written in 100% pure Java.

    This beginner's tutorial book is a straightforward introduction to the iReport environment taking an example-oriented approach in developing your skills from scratch. It shows you how to use iReport for creating reports in PDF, RTF, and other formats, which can be delivered over the Web for immediate access.

    This book will guide you through using iReport to develop various types of reports from a simple report through to dynamic enterprise-level reports based on realistic examples based on a sample Inventory Management System. It takes you through the main types of report available in iReport, and shows you exactly how to create them. It shows you how to use different report templates, how to use special kinds of data operations to generate more powerful reports, combine data to produce master-detail reports, add images, control the layout and formatting of your report and many more.

    It will also show you how to use the NetBeans IDE to create Java projects with reporting facilities. You will learn how to vary report format and layout according to business requirements.

    Table of Contents

    1. iReport 3.7
      1. iReport 3.7
      2. Credits
      3. About the Author
      4. About the Reviewer
      5. Preface
        1. What this book covers
        2. What you need for this book
        3. Who this book is for
        4. Conventions
        5. Reader feedback
        6. Customer support
          1. Errata
          2. Piracy
          3. Questions
      6. 1. Introduction to iReport
        1. iReport features
          1. Simple to use GUI
          2. Report designer and tools
          3. Data sources
          4. Report templates
          5. Export and preview
        2. iReport Classic vs iReport NB
        3. Downloading and installing iReport
        4. References
        5. Summary
      7. 2. Building Your First Report
        1. Creating a connection/data source
        2. Building your first report
        3. Viewing and exporting the report
        4. Summary
      8. 3. Report Layout and Formatting
        1. Setting up the report pages
          1. Configuring the page format
            1. Page size
          2. Configuring properties
            1. What are the different checkboxes?
            2. When there is no data
        2. Configuring bands, formatting reports and elements
          1. Showing/hiding bands and inserting elements
          2. Sizing elements
          3. Positioning elements
          4. Handling null values
          5. Font settings
          6. Creating text field pattern
          7. Setting borders
          8. Using tools for current date and inserting page numbers
        3. Summary
      9. 4. Using Variables
        1. Reviewing the database tables
        2. Creating a basic report
        3. Adding variables
          1. Adding total variable
          2. Adding a grand total
        4. Summary
      10. 5. Using Parameters
        1. What is a parameter?
          1. Adding parameters in the SalesDetails report
          2. Using more than one parameter
        2. Summary
      11. 6. Grouping Data in Reports
        1. Building a Group by report
        2. Modifying group properties
        3. Managing report groups
        4. Variables for the group
        5. Summary
      12. 7. Subreports
        1. Creating a subreport
          1. Creating the master report
          2. Creating the subreport
        2. Returning values from the subreport
        3. Using an existing report as a subreport
        4. Compiling a report
        5. Summary
      13. 8. Crosstab Reports
        1. Understanding a crosstab report
        2. Creating a crosstab report
          1. Formatting crosstab elements
        3. Summary
      14. 9. Charting
        1. Developing a pie chart report
        2. Developing a 3D pie chart report
        3. Developing a bar chart report
        4. Summary
      15. 10. Working with Images
        1. Displaying an image from the database
          1. Scaling images
        2. Displaying images from the hard drive
        3. Setting a background image
        4. Summary
      16. 11. Calling Reports from Java Applications
        1. Downloading and installing NetBeans
        2. Creating a project in NetBeans
        3. Creating the iReport viewer class
          1. Adding JasperReports API in the NetBeans project
          2. Creating the viewer class
          3. Accessing the database
          4. Filling the report with data
          5. Viewing the report
        4. Calling the viewer class
        5. Creating GUI with menus
          1. Calling a report without a parameter
          2. Calling a report with a parameter
        6. Calling reports from a web application
        7. Summary
      17. 12. iReport in NetBeans
        1. Installing iReport plugins in NetBeans
        2. Creating reports
          1. Creating a NetBeans database JDBC connection
          2. Creating a report data source
          3. Creating a simple report
        3. Creating a parameterized report
        4. Summary
      18. A. A Sample Database
        1. Designing the database
          1. List of entities
          2. Data dictionary
          3. Entity Relationship Diagram (ERD)
        2. Installing MySQL and GUI tools
          1. Configuring MySQL Server Instance
        3. Creating a database
        4. Backing up and restoring database
          1. Backing up the database
          2. Restoring the database