Transcript Ad Hoc Graphical Reports CSCI 6838.2 Research Project and

Ad Hoc Graphical Reports
CSCI 6838.2 Research Project and
Seminar
Team #4
March 1, 2007
Copyright © Team #4 CSCI 6838 Spring
2007
1
Team Information



Advisor:
• Dr. Kwok-Bun Yue
[email protected]
Mentors:
• Abbasi Dhilawala
[email protected]
• Scott Hetherington
[email protected]
Team Members:
• Prathyusha Patinjaryil [email protected]
• Nikhila Chilkamarri
[email protected]
• Augustine Patil
[email protected]
• Abdul Hafeez Khan
[email protected]
Copyright © Team #4 CSCI 6838 Spring
2007
2
Customer Information

Tietronix Software, Inc
• Full-service provider of custom software applications
and advanced technology solutions
• Tie Flow Software for NASA JSC

Contacts:
• Abbasi Dhilawala
• Scott Hetherington

[email protected]
[email protected]
Website: www.tietronix.com
Copyright © Team #4 CSCI 6838 Spring
2007
3
Table of Contents








Project Overview
Project Requirements
Tasks
Design & Implementation
Current Ad Hoc Tool
JasperReports
BIRT
Implementation Challenges
Copyright © Team #4 CSCI 6838 Spring
2007
Nikhila
Nikhila
Nikhila
Prathyusha
Augustine
Augustine
Augustine
Abdul
4
Table of Contents





Refinement
Conclusions & Future Work
Project Timeline
Development Team
References
Copyright © Team #4 CSCI 6838 Spring
2007
Abdul
Abdul
Abdul
Abdul
Abdul
5
Project Overview


The main goal of the project is to provide the existing
report generator with graphical display capability
The tools used to generate these reports are
• JasperReports
•

BIRT
Both JasperReports and BIRT take XML input which is
the report definition file
Copyright © Team #4 CSCI 6838 Spring
2007
6
Project Overview

Technologies:
• JAVA
•
XML
•
JBoss
•
SQL Server 2005
Copyright © Team #4 CSCI 6838 Spring
2007
7
Project Requirements

Initial project requirements
• XML translator to accept Ad Hoc report definition XML
• XML translator then produces XML report definition in
Jasper or BIRT format

Present project requirements
• Modify the Ad Hoc reporting tool to generate XML
report definition
• This XML report definition must be understood by
Jasper or BIRT engines
Copyright © Team #4 CSCI 6838 Spring
2007
8
Tasks

Learn the Existing System

Learn the tools Jasper and BIRT

Learn the XML’s accepted by the Jasper and BIRT engines
Copyright © Team #4 CSCI 6838 Spring
2007
9
Design & Implementation
Architectural Diagram
 Class Diagram
 Use Case Diagram
 Sequence Diagram

Copyright © Team #4 CSCI 6838 Spring
2007
10
Architecture Diagram
Existing
GUI
Java
Current
GUI
Ad Hoc Reporting Tool
Tabular
Output
Capstone
Data
BIRT XML
Jasper XML/ jrxml
BIRT
Jasper
Graphical Output
Graphical Output
11
Use Case Diagram
Ad Hoc Graphical Reports
Select the Area Of
Interest,
Select options for
the report
Generates the Area
of Interest
Sets the BIRT/
JASPER charts to user
Select the Chart and Give
input parameters for chart
Report
Viewer
Administrator
View Graphical Report
Copyright © Team #4 CSCI 6838 Spring
2007
12
ReportDefinition
AreaOfInterest
Datasource, querry,
versionnumber,…..
mCategory, mLabel,
vColumn,
vjoinConditions..
+getAreaOfInterest();
+setAreaOfInterest();
+getColumnReference(St
ring columnQName);
+setDataSource();
+getTableReference(Stri
ng tableQName);
+getDataSource();
…………..
+getReportDatabases();
……………..
+getReportResults();
ReportManager
<<Interface>>Report
Charts
paramName, chart types,
paramValue……
+getAvailableCharts();
<<Implements>>
Jasper
paramName, charttypes,
paramValue……
+setparam(String
paramName, object
paramValue);
+getparam(String
paramName):Object
+CreateChartXML():String
+getParamChartType(String
ChartType);
+viewopchart(String XMLloc
):image
<<Implements>>
BIRT
ReportChart rc;
+rc.setChartType(String
ChartName, cvalue);
+rc.getChartType(String
Chartname): Chart
+rc.getAvailableCharts();
+rc. setparam(String
paramName, object
paramValue);
+rc.getparam(String
paramName):Object
+rc.getParamChartType
(String ChartType);
+rc.viewopchart(String XML
loc):image
13
Report
Viewer
Report
Manager
Report
Charts
Report
Definition
Area Of
Interest
request AOI
request AOI
forward AOI to
Report Viewer
generate AOI
Sets
Jasper/BIRT
Returns Java object
with tabular output
charts
Returns tabular data
info
Admin
Request charts
Give available
charts
Presents the
available charts
Returns set of
available charts
Select chart and
give input
parameters
Accept the input
Output chart
ready in HTML
parameters
Creates the chart
XML & returns
output
14
The Current Ad Hoc Tool
Copyright © Team #4 CSCI 6838 Spring
2007
15
The Current Ad Hoc Tool
Copyright © Team #4 CSCI 6838 Spring
2007
16
The Current Ad Hoc Tool
Copyright © Team #4 CSCI 6838 Spring
2007
17
The Current Ad Hoc Tool
Copyright © Team #4 CSCI 6838 Spring
2007
18
The Current Ad Hoc Tool
Copyright © Team #4 CSCI 6838 Spring
2007
19
The Current Ad Hoc Tool
Copyright © Team #4 CSCI 6838 Spring
2007
20
The Current Ad Hoc Tool
Copyright © Team #4 CSCI 6838 Spring
2007
21
The Current Ad Hoc Report
Copyright © Team #4 CSCI 6838 Spring
2007
22
Jasper Reports

JasperReports is a powerful open source Java reporting tool that has the ability to deliver rich
GRAPHICAL content onto the screen, to the printer or into PDF, HTML, XLS, CSV and XML files.

Available Charts in Jasper:
Copyright © Team #4 CSCI 6838 Spring
2007
23
BIRT

BIRT is an open source Eclipse-based reporting system that integrates with your Java/J2EE
application to produce compelling Graphical reports.

Available Charts in BIRT:
Copyright © Team #4 CSCI 6838 Spring
2007
24
How To Do: A very basic Diagram
Current Tool
Java Code
Generated Jasper
/ BIRT
understood XML
Runtime
Jasper / BIRT
Engine
Copyright © Team #4 CSCI 6838 Spring
2007
Graphical Report
25
Implementation Challenges

Identifying the correct JDK version to run the pre-compiled classes
in the deployment package

JBoss Application Server – outdated jar file was provided (jtds 0.9 to
jtds 1.2)

Current tool required SQL Server Authentication (not the default
Windows Authentication) for connecting to the database

SQL Server 2005 Network Configuration has TCP/IP protocol
disabled by default - which needed to be enabled
Copyright © Team #4 CSCI 6838 Spring
2007
26
Refinement

According to Initial requirements, the XML part needed modification
TieFlow Data
Data Formatting in Report XML
Report
formatted data
Requirements were refined to bypass the XML.
 Factory Method design is used.
Copyright © Team #4 CSCI 6838 Spring
2007
27
Conclusion and Future Work

The required classes to be extended have been identified

Sequential flow of the process is well understood

Understanding the XML format. More research on the existing
package is needed

Developing the required classes

Modifying the User Interface
Copyright © Team #4 CSCI 6838 Spring
2007
28
Project Timeline
Copyright © Team #4 CSCI 6838 Spring
2007
29
Development Team
Team Leader:
Prathyusha Patinjaryil
Research & Design:
All
Webmaster:
Augustine Patil
Abdul Hafeez
Database Administrator: Nikhila Reddy Chilkamarri
Testing & Debugging:
All
Developers:
All
Documentation:
All
Copyright © Team #4 CSCI 6838 Spring
2007
30
References

JBoss At Work,
http://today.java.net/pub/a/today/2005/03/01/InstallingJBoss.html

Reporting in JAVA using JasperReports
http://members.lycos.co.uk/oderin/tutorials/JavaReporting/JavaR
http://jasperforge.org/sf/projects/jasperintelligence
http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=sh
owcat&catid=9
http://www.javaworld.com/javaworld/jw-09-2002/jw-0920opensourceprofile.html

BIRT
http://www.eclipse.org/resources/
http://www.onjava.com/pub/a/onjava/2006/07/26/deploying-birt.html
http://www.theserverside.com/tt/articles/article.tss?l=EclipseBRT
Copyright © Team #4 CSCI 6838 Spring
2007
31
Thank You
Copyright © Team #4 CSCI 6838 Spring
2007
32