Chapter 1. Designer Guide

1.1. Overview / Introduction

Welcome to EspressReport. Written in 100% pure Java, EspressReport is a set of tools that allows you to easily create professional, information-rich reports from many data sources and include them in your applications, web based or otherwise. Among other components, EspressReport comes with Report Designer and a robust object oriented API. The Report Designer provides a powerful, yet easy to use graphical user interface where you can quickly edit and format content, turning raw data into polished reports in a matter of minutes. The finished report design can be saved in a template for subsequent distribution with the latest data. To publish a report on the web, you can write JSP/servlet code using the API to refer to the template and generate the report in a desired format. Supported export formats include PDF, DHTML, text, Excel (XLS) and Excel 2007 (XLSX) spreadsheets. Reports can also be viewed in a browser with Report Viewer or EspressReport’s API running as applet, and later printed in a WYSIWYG hard copy.

Included in the report designer is a Query Builder and Data Source Manager that allows you to quickly extract data from JDBC, XML, and ASCII sources. The sophisticated Data View features allow administrators to create local data catalogs for end users and present data from databases in simplified view. Using this feature, end users with no knowledge of databases can easily perform ad-hoc reporting.

To facilitate easy report design and creation, EspressReport supports five report types, namely: simple columnar, summary break, crosstab, master & details and mailing labels. Advanced features allow users to include sub-reports, drill-downs, parameters, insert hyperlinks and images, manipulate data with over eighty-five built-in formulas and incorporate sophisticated charts and graphs into reports.

1.1.1. EspressReport Documentation

There are four sections of the EspressReport Documentation.

Quick Start Guide:

This is a good starting point for EspressReport first time users. It covers most commonly used features and provides Report Designer and API tutorials.

Designer Guide:

This explains all of the functionality of the Report Designer and teaches you how to develop queries in the Query Builder and format and manipulate data to create polished reports.

Programming Guide:

This covers the Report API and teaches you how to create reports programmatically, as well as incorporate them into servlets, JSPs, and applications.