Reporting Server

Birt

Currently using Birt for generating reports and invoices for the child center.

Setup

1. Download Birt report designer
2. Create report using designer.
   • Connect to database using jdbc connector
3. Built-in report generator - create PDF versions of report.

Jasper

• Seems to have more moving parts.
• Comes with a server component.

Pentaho Reporting

• Has an open source server.

Currently using Birt to generate invoices.

• All data in postgres DB
• Connect to postgres DB via jdbc
• One view and sql queries to populate the reports
• Seems to work okay now.

Goals

1. Mobile view of reports. Web based mobile.
2. Generate reports on demand. Always most relevant data
3. Generate invoices that will be sent via email.
4. Enable reports for printing. Hardcopies are always nice.
5. Want to spend time desigining the report but only have to do it once. Easier with a graphic editor than trying to mangle XML, JSON, etc.
6. Want to chart.

Issue with Eclipse (starting up report server)

• Eclipse Wiki
  • Fix issue to set explicit JVM for Eclipse.

Generating PDFS

• Dynamic Jasper - Make dynamic reports.
• Dynamic Reports - Dynamic reports based on Jasper
• Jasper Reports Library
• Apache PDFBox - PDFBox - manipulate PDF docs.
• iText - Java PDF library - have book PDF

---

Last update: April 13, 2020 16:50:19