Ad Hoc Graphical Reports CSCI 6838 2 Research

Скачать презентацию Ad Hoc Graphical Reports CSCI 6838 2 Research

157a2d1e8c82a3fbb0c1b3aeabeb8704.ppt

Количество слайдов: 32

Team Information Ø Ø Ø Advisor: • Dr. Kwok-Bun Yue yue@uhcl. edu Mentors: • Abbasi Dhilawala adhilawa@tietronix. com • Scott Hetherington shetheri@tietronix. com Team Members: • Prathyusha Patinjaryil prathyusha 0282@gmail. com • Nikhila Chilkamarri nikhilauhcl@gmail. com • Augustine Patil augustinpatil@yahoo. com • Abdul Hafeez Khan hafeez 83@gmail. com 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 Ø adhilawa@tietronix. com shetheri@tietronix. com 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 Jasper. Reports BIRT Implementation Challenges Copyright © Team #4 CSCI 6838 Spring 2007 Nikhila Prathyusha Augustine Abdul 4

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 • Jasper. Reports • Ø BIRT Both Jasper. Reports and BIRT take XML input which is the report definition file Copyright © Team #4 CSCI 6838 Spring 2007 6

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

Architecture Diagram Existing GUI Java Current GUI Ad Hoc Reporting Tool Tabular Output Capstone Data BIRT XML Jasper XML/ jrxml BIRT Jasper 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

Report. Definition Area. Of. Interest Datasource, querry, versionnumber, …. . m. Category, m. Label, v. Column, vjoin. Conditions. . +get. Area. Of. Interest(); +set. Area. Of. Interest(); +get. Column. Reference(St ring column. QName); +set. Data. Source(); +get. Table. Reference(Stri ng table. QName); +get. Data. Source(); …………. . +get. Report. Databases(); ……………. . +get. Report. Results(); Report. Manager <>Report Charts param. Name, chart types, param. Value…… +get. Available. Charts(); <> Jasper param. Name, charttypes, param. Value…… +setparam(String param. Name, object param. Value); +getparam(String param. Name): Object +Create. Chart. XML(): String +get. Param. Chart. Type(String Chart. Type); +viewopchart(String XMLloc ): image <> BIRT Report. Chart rc; +rc. set. Chart. Type(String Chart. Name, cvalue); +rc. get. Chart. Type(String Chartname): Chart +rc. get. Available. Charts(); +rc. setparam(String param. Name, object param. Value); +rc. getparam(String param. Name): Object +rc. get. Param. Chart. Type (String Chart. Type); +rc. viewopchart(String XML loc): image 13

Report Viewer Report Manager Report Charts Report Definition Area Of Interest 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

Jasper Reports n Jasper. Reports 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. n Available Charts in Jasper: Copyright © Team #4 CSCI 6838 Spring 2007 23

BIRT n BIRT is an open source Eclipse-based reporting system that integrates with your Java/J 2 EE application to produce compelling Graphical reports. n Available Charts in BIRT: Copyright © Team #4 CSCI 6838 Spring 2007 24

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 Tie. Flow 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

Development 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/Installing. JBoss. html Ø Reporting in JAVA using Jasper. Reports http: //members. lycos. co. uk/oderin/tutorials/Java. Reporting/Java. R http: //jasperforge. org/sf/projects/jasperintelligence http: //www. jasperforge. org/index. php? option=com_joomlaboard&Itemid=215&func=s howcat&catid=9 http: //www. javaworld. com/javaworld/jw-09 -2002/jw-0920 opensourceprofile. 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=Eclipse. BRT Copyright © Team #4 CSCI 6838 Spring 2007 31