Ask Your Question

DPSSpatial's profile - activity

2019-07-03 21:45:07 +0200 received badge  Famous Question (source)
2018-02-01 00:54:47 +0200 received badge  Famous Question (source)
2017-08-10 11:35:54 +0200 received badge  Notable Question (source)
2017-08-02 10:42:14 +0200 received badge  Popular Question (source)
2017-08-01 23:44:09 +0200 asked a question Loading geometry in Base causes hanging, crash

Loading geometry in Base causes hanging, crash All, We use LibreOffice Base as an interface to our PostgreSQL database,

2017-06-27 17:03:20 +0200 marked best answer How to create 'full page' reports?

All,

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

2017-06-27 17:03:20 +0200 received badge  Scholar (source)
2017-06-16 17:56:17 +0200 commented answer How to create 'full page' reports?

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

2017-06-16 17:55:56 +0200 received badge  Supporter (source)
2017-06-15 08:48:00 +0200 received badge  Notable Question (source)
2017-06-14 04:28:07 +0200 received badge  Student (source)
2017-06-14 04:25:01 +0200 received badge  Popular Question (source)
2017-06-13 19:52:28 +0200 asked a question How to create 'full page' reports?

How to create 'full page' reports? All, For lack of a better term, I'm trying to figure out how to build 'full page rep