JasperSoft makes a number of software products under the JasperSomething name, including tools which are available under "community edition" open source licenses / free to use. They also offer commercial paid products.
TADL has been using JasperReports Server as a web frontend for a self-service reporting interface for staff, and using iReport to design the report templates. If you have an SQL report, you can turn it into a JasperReports report template, give parameters that staff can be prompted to enter, etc.
I've got a demo server up with a very basic pair of reports. Between now and the conference, I'll be fleshing it (or its replacement) out with more reports (and more data – so that the reports are less boring).
-
Log in with the read-only username and password of egdemo / open-ils
Once there, probably the easiest way to navigate is to pick Reports from the View menu/navigation across the top. If you run the "User Profile Counts" report – simply click it – you'll see a count of users in profile groups by library location. This is just using some demo/sample data on a 2.1 system. If you then click the name of one of the profile groups in the report output, it should run a drill-down report which will list all of the patrons (family, first, and username) in that group. On the left-hand side, you'll see options where you can change the criteria, to see just users with a certain home OU, or to see users in a different group.
-
Reports export to pdf, excel, etc. Users can log in and schedule reports and have the report output (say, pdf) emailed to them – or they can log in to the web interface to retrieve it.
It can tie to an ldap server (such as active directory) for staff logins – TADL uses this.
TADL also has reports for other non-ils data, such as our soft stats, wireless/public computing stats, visitor counts, etc.
Jeff will probably not be at the Reports Interest Group meeting at the conference, but Amy will give a summary of this work and steer people towards Jeff's presentation devoted to JasperReports later at the conference.