JReport User's Guide

Table of Contents

Basic Concepts
    Working Set
    Query
    Group and Sort
    Catalog Browser
    Report Inspector
Starting a Report
    Choose Report
    Report Wizard
Using Designer Features
    Major JReport Workbench Features
Deploying Reports
Advanced Usage
Tutorial Lessons

You can click any of the follow topics for further explanations.

Basic Concepts

Working Set

Query

• What is a Query in the Catalog?
• Editing Queries in the Working Set
• Query Editing: add/delete table, additional Search Conditions with Logical Operators, arrange tables, show/hide table names, Joining columns with Join Options, Auto Join based on PSQL Options
• Column Editing: add/delete column, create Computed Column, add Column Search Criteria, show/hide columns

Report Inspector

• Sections: Report Header, Report Footer, Page Header, Page Footer, Group Header, Group Footer, Details
• Properties: General, Text Format, Geometry, Color, Pattern, Border, Picture, Arc, Box, Line, Round Box, Others

Starting a Report

Choose Report

• New Report: Use Report Wizard to create a new report of the following types: Blank Report, Standard Report, Form Letter:, Labels, Cross Tab, Sub Report, Drill Down, Columnar
• Existing Report: Open an existing report.
• Recent Report: Open a recently accessed report.

Using Designer Features

Main JReport Workbench Functions

• Work Area
  • Design tab: This allows you to build the report using the IDE provided.
  • Editing Reports
  • Selecting, moving, and resizing
  • Changing fonts, font size, style, and justification    
  • Definition of Sections: The work area is partitioned into different sections.
  • Grid options
  • View tab: This allows you to run the report and view the results.
• General Operations
  • Report Operations: Create New Report, Open Existing Report, Save Current Report, Save as New Report, Save to Another Catalog
  • Catalog Operations: Create New Catalog, Open Catalog, Save Catalog, Save Catalog as New Catalog.  Establish a database connection for a new catalog.
  • Define or modify Working Set
  • Output Report Results: Print report result or export to HTML.
  • Set System Options, Measuring Units, Page Parameters
• Edit: undo or redo previous actions, Cut/Copy/Paste, Delete Objects, Find DBFields in the report.
• View: Turn on or off Toolbars, status line, grids, rulers, guidelines, Catalog Browser, Report Inspector, and "on top" setting for Catalog Browser and Report Inspector.
• Insert Objects
  • Labels, Summary Fields, Database Fields, Formulas (see Syntax), Parameters
  • Special Fields not from the database, Text, Charts and Graphs, Cross tab
  • Report Sections, fields Group/Sort and Advanced Sort criteria,  Subreport
  • Arc, Box, Line, Round Box, and JPEG and GIF images. 
  • Once created these objects may be viewed and edited with the Report Inspector.
• Format: Move to Back, Move Backwards, Move to Front, Move Forward, Align Left, Align Right, Align Top, Align Bottom, Align Vertical Center, Align Horizontal Center
• Toolbars: How to Use and Move Toolbars, Standard Toolbar, and Edit Toolbar

Deploying Reports

• Standalone Mode
• Deploying Reports in Client/Server Mode

Advanced Usage

• Command Line Parameters
• User Supplied Data Source (More Than JDBC and ODBC)
• Setting Catalog and Report Paths for the Server
• Starting the Server from a Java Program
• Use of JReport Java Beans
  • Using JReport Viewer Bean
  • Using JReport Engine as a Bean
  • Using JReport Result Viewer Bean

Tutorial Lessons

• Lesson 8:  Creating a Report Using User Data Source
• Create a dummy table in catalog
• Create a report using the dummy table
• Write the data source driver class
• Run the report with the data source driver
• How to install the JReport server on Solaris
• Definitions