Skip to content

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)

Generating PDFS