1 / 20

Automatic Report Generation for WLCG/EGEE

This project aims to automate report generation for different groups in WLCG/EGEE, eliminating the manual and repetitive task of exporting data and generating graphs in excel. Various reporting tools, including JasperReports, will be used for flexible and rapid report generation.

sunnij
Download Presentation

Automatic Report Generation for WLCG/EGEE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Automatic Report Generation for WLCG/EGEE D. D. Sonvane (Gridview Team) B.A.R.C.

  2. Need for Automation • Need for different types of reports for different groups in WLCG/EGEE • Project Management • Operations • Currently Various Service Availability Reports being circulated • Generated Manually by cumbersome method like exporting data, generating graphs in excel, converting to pdf etc • Repetitive task (Reports needed for various periodicities) • Hence identified this area for Automation

  3. Approach to Automation… • Traditional Approach • Programming approach • Generating pdf thru program using pdf libraries • Most flexible • Cumbersome (repetitive code for every small formating related tasks) • Reporting Tool based Approach • Document/template based approach • Facilitates rapid report generation • Limited flexibility (Need to adapt report to flow/features of the tool)

  4. Report Generation Tools • Various tools available commercially as well as from open source community • Crystal Reports • most popular commercial report generation tool • JasperReports • most popular open source report generation tool • a viable alternative to commercial tools

  5. JasperReports Suite • JasperReports suite of reporting tools consists of • JasperReports Engine • Java based report generation engine • Needs report specification in xml file • iReport • Visual Designer (Graphical tool) for generation of xml report specification file • Open Reports • Server for deploying/exporting the reports on Web • Provides a web-based interface • Support various formats like pdf, rtf, xls, csv, html etc.

  6. JasperReports Architecture Open Reports Interface iReport Designer Jasper- Reports Reporting Engine pdf/ rtf/ xls/ html xml End User Designer Output Report Report Spec Deploy Reports on Web Visually Design Report DynamicallyGenerate Report jdbc/ xml/ csv/ custom DataSource

  7. iReport Designer Snapshot

  8. WLCG/EGEE Reports Automated • WLCG Reliability Report for Tier-1 sites • VO-wise Reliability report for Tier-1 sites • WLCG Tier-2 Availability and Reliability Report • Federation wise summary and details of each site • EGEE Availability and Reliability Report • Region wise summary and details of each site

  9. Thank You Your comments and suggestions please

  10. iReport – Features • Visually Design the Report by placing Elements (Static Text,Fields,Graphics, Charts,Images etc) appropriately • Query • Fields, Parameters, Variables • Expressions • For field data or for “Print When Condition” • Java or Groovy support • Scriptlets • Sub-Reports • Complex reports generated by aggregating subreports

More Related