Introducing Ad hoc Reporting with Jaspersoft Studio

1. Introducing Ad hoc Reporting with Jaspersoft Studio John Snyder

2. Agenda • Defining Jaspersoft Studio • What is JasperReports? • What is Jaspersoft Studio? • How do they work? • Using Jaspersoft Studio • Learning the user interface • Creating a new report template • T-Recs and Jaspersoft Studio • Connecting to your T-Recs database • T-Recs integration with a new report template • Getting Started • How you get Jaspersoft Studio? • What resources are available? • What do you need to know?

3. What Is JasperReports? • An open source, Java based, reporting engine • Supported and distributed by Jaspersoft (www.jaspersoft.com) • Used for all T-Recs reporting • Delivered with T-Recs as part of the installation • Outputs PDF, HTML, XLS(X), RTF, TXT, XML, and CSV • Supports internationalization, multi-language and multi-currency

4. What Is Jaspersoft Studio? • The successor to iReport (which is being sunsetted in 12/15) • A small footprint, standalone, desktop report designer program based on JasperReports • No runtime platform, just design and test • Similar to Crystal Reports (now SAP Business Objects), MS Access report designer, etc. • Not included with T-Recs • Produces the same report template files Chesapeake already uses in T-Recs, jrxml files • Used by our implementers and developers to create custom reports for our customers • T-Recs customers may use it to create their own custom reports

5. How Does It Work?

6. Using Jaspersoft Studio – Demonstration

7. Connecting Jaspersoft StudioTo Your T-Recs Database • Developing a new report template requires a direct connection to your T-Recs database from your iReport workstation • Database access should be read only • Licensed customers: • Work with your DBA team to acquire appropriate authorization • Establish a connection using the same authentication as T-Recs uses • Hosted customers: • Create a test database environment

8. T-Recs Integration With A New Jaspersoft Studio Template (PDF)

9. T-Recs Integration With A New Jaspersoft Studio Template (Internal)

10. How You Get Jaspersoft Studio • Only the Community Edition is free • Trial editions of the Commercial Edition are available • Download Jaspersoft Studio Community Edition installation setup from: community.jaspersoft.com/download • Context sensitive help is built in • Get the latest version, currently 5.6 • Backward compatibility is supported • T-Recs is currently using version 4.7

11. What Resources Are Available? • Books: • “Jaspersoft Studio User Guide” from: http://community-static.jaspersoft.com/sites/default/files/docs/jaspersoft-studio-user-guide_0.pdf (current version 5.6) • “JasperReports Ultimate Guide” from: http://jasperreports.sourceforge.net/JasperReports-Ultimate-Guide-3.pdf (last updated 2011) • Jaspersoft Resources: • http://community.jaspersoft.com/project/jaspersoft-studio/resources • Chesapeake Training: • At Chesapeake • Onsite

12. What Do You Need To Know? • About Jaspersoft Studio • Report design concepts and practices • Database connectivity and structure • Basic SQL • Jaspersoft Studio design user interface and processing • About T-Recs • The database schema • How to set up External Tasks

13. Other Possibilities • JasperReports Server • Report depository • Build your own dashboards

14. Q&A