How to create 'full page' reports?


For lack of a better term, I’m trying to figure out how to build ‘full page reports’ - rather than nice looking spreadsheets (sorry, that’s a harsh way to refer to standard reports…).

Here’s our use case:

We are developing ‘reports’ using Microsoft Publisher that are summaries of demographic and school changes based on data we have created that is stored in PostgreSQL.

I’d like to use LIbreOffice Reports to create a single (or multiple) page report for each Neighborhood (based on NBHD_ID), so each page would have the neighborhood name at the top, and various data points from the PGSQL table throughout the page (we’d love to pull in map images created in QGIS that are named by NBHD_ID as well, and of course charts).

What I can’t figure out is how to break each page of a report down to an individual NBHD_ID and the corresponding data elements that are associated with that ID - instead, I can only see how to create (again I’m sorry) fancy looking spreadsheets.

Our BI team uses SQL Server Reporting Services to create multi-page reports for each school (example), and I’m wondering if the same type of report can be built using LibreOffice.

Many thanks for any insight!

-Matthew Baker
Denver Public Schools
Denver, CO, USA

Sorry but your example link doesn’t seem to work. Can you please edit your question and fix it. Thanks.

Link works for me, so it might be related to your configuration

Thanks; now the link works. Nice report. Producing it with LO is beyond my skills at the moment.

You may be hard pressed to produce your provided sample in Report Builder.

I typically use DynamicReports. A sample of theirs is similar to the one you have. Note the Complex Sales report & just below that a Map sample - click here. The drawbacks for you may be that there is no graphical interface (after getting used to it, I now prefer this approach) and the interface is in Java. It connects with most databases (including PostgreSQL). You can work with it using Eclipse Java.

I would guess that you would continue to use QGIS for geocoding as typically you wouldn’t find this in a report generator.
Hopefully you could export a file for use in the report.

If you are using or plan to use LibreOffice, the finished program from DynamicReports can be exported as an executable .jar from Eclipse and then stored with the Base file(s). Base, using a very simple macro with a shell command, can then execute the report.

There are other open software report builders available, all with graphical interfaces: Jasper Reports (DynamicReports is based on this), Pentaho Report Builder (somewhat the basis for LO Report Builder) and DataVision Reports (not updated in quite some time).

With the exception of DataVision, each product mentioned has a user forum for potential help in report creation.

Thanks for that insight! Barring any more feedback I’ll mark this as the answer in a few days… Much appreciated!