O
O
O
P
P
P
E
E
E
N
N
N
R
R
R
E
E
E
P
P
P
O
O
O
R
R
R
T
T
T
S
S
S
O
O
P
P
E
E
N
N
R
R
E
E
P
P
O
O
R
R
T
T
S
S
A
A
D
D
M
M
I
I
N
N
I
I
S
S
T
T
R
R
A
A
T
T
I
I
O
O
N
N
G
G
U
U
I
I
D
D
E
E
V
V
E
E
R
R
S
S
I
I
O
O
N
N
3
3
.
.
0
0
Table of Contents
INTRODUCTION .......................................................................................................................................................................... 3
ADMINISTRATION CONSOLE ................................................................................................................................................. 4
REPORT DATASOURCES .......................................................................................................................................................... 5
REPORTS ....................................................................................................................................................................................... 6
Report Definition .......................................................................................................................................................................... 7
QueryReports ................................................................................................................................................................................ 8
ChartReports ................................................................................................................................................................................. 9
Adding Report Parameters .......................................................................................................................................................... 10
JasperReports Export Options ..................................................................................................................................................... 11
Additional Report Information .................................................................................................................................................... 12
REPORT PARAMETERS .......................................................................................................................................................... 13
Query Parameters ........................................................................................................................................................................ 13
List Parameters ........................................................................................................................................................................... 14
Boolean Parameters .................................................................................................................................................................... 16
Additional Parameter Information .............................................................................................................................................. 17
CHARTS ....................................................................................................................................................................................... 18
Chart Definitions ......................................................................................................................................................................... 19
Bar Chart ................................................................................................................................................................................. 20
Pie and Ring Charts ................................................................................................................................................................. 20
XY Chart .................................................................................................................................................................................. 20
Time Chart ............................................................................................................................................................................... 21
Charts in JasperReports ............................................................................................................................................................... 22
Drill-Down ChartReports ............................................................................................................................................................ 23
ONLINE ANALYTICAL PROCESSING (OLAP) ................................................................................................................... 24
USERS AND GROUPS ................................................................................................................................................................ 25
User Administration .................................................................................................................................................................... 26
Report Groups ............................................................................................................................................................................. 27
SCHEDULED REPORTS ........................................................................................................................................................... 28
QUERYREPORT TEMPLATES ............................................................................................................................................... 29
EXTERNAL/DRILL-DOWN REPORT EXECUTION ........................................................................................................... 31
OPENREPORTS PROFESSIONAL FEATURES .................................................................................................................... 32
Report DashBoard ....................................................................................................................................................................... 33
Alerts and Conditional Scheduling ............................................................................................................................................. 34
Scheduler Administration ........................................................................................................................................................... 36
Report Statistics .......................................................................................................................................................................... 37
OPENREPORTS SYSTEMS ADMINISTRATION ................................................................................................................. 38
Cache .......................................................................................................................................................................................... 38
Localization ................................................................................................................................................................................ 38
Eclipse BIRT ............................................................................................................................................................................... 38
Spring Configuration .................................................................................................................................................................. 39
DICTIONARY ............................................................................................................................................................................. 40
ROLE DEFINITIONS ................................................................................................................................................................. 41
LICENSE AND CREDITS .......................................................................................................................................................... 42
Introduction
OpenReports is a powerful, flexible, and easy to use open source web reporting solution that provides browser
based, parameter driven, dynamic report generation and flexible report scheduling capabilities.
OpenReports supports a variety of open source reporting engines, including JasperReports, JFreeReport, JXLS,
and Eclipse BIRT, to provide support for a wide range of reporting requirements and capabilities. OpenReports
also supports QueryReports and ChartReports, easy to create SQL based reports that do not require a predefined
report definition.
OpenReports provides a web based report generation and administration interface with the following features:
Support for a wide variety of export formats including PDF, HTML, CSV, XLS, RTF, and Image.
Web based Administration of Users, Groups, Reports, Charts, Parameters, and DataSources
Flexible Scheduling capabilities including Daily, Weekly, and Monthly options and multiple recipients.
Comprehensive Report Parameter support including Date, Text, List, Query, and Boolean parameters.
Fine-grained security controls access to Reports, Scheduling, and Administration functionality.
Report Auditing tracks start time, duration, status, and user of every report generated.
Support for multiple JNDI or Connection Pool DataSources for use in generating reports.
Support for Drill Down reports and external application integration via secure report generation URL
OpenReports report generation and scheduling capabilities are also available directly via the ReportService, a
Service-oriented architecture (SOA) for report generation and scheduling. The ReportService provides the ability
to quickly add reporting functionality to existing or new applications through a comprehensive and flexible API
exposed as a SOAP web service and to HTTP GET/PUT requests.
OpenReports Professional, the commercial version of OpenReports, includes all the features of the open source
version and introduces advanced functionality, including the Reporting Dashboard, Alerts, Conditional Report
Scheduling, and Report Statistics at an affordable price point.
Administration Console
The OpenReports Administration console provides the ability to manage Reports, DataSources, Parameters, Users,
Groups, Charts, and other important settings.
Note
Tables with clickable headers, such as the list of reports in the following example are sortable.
Report DataSources
Report DataSources are used to run queries in reports, parameters, and charts. Report DataSources can be either
JNDI DataSources or connection pools. Each report, parameter, or chart can be assigned its own DataSource. At
least one Report DataSource should be created before defining any reports, parameters, or charts.
To create a Report DataSource, click on the DataSources link in the Administration Menu, and then click on
the Add DataSource link in the top center of the page.
Notes:
When the Ok button is pressed, OpenReports tests the DataSource by trying to get a connection. If an error
message is displayed, check the connection properties and try again.
JNDI DataSources require only Name and URL. See the Dictionary for definitions of the connection pool
properties.
- 1
- 2
前往页