Summary Reports - presentation

[RonP]

Relations.jpg (141.76 KiB) Viewed 2602 times

Result-Elektra-Report_01.png (191 KiB) Viewed 2602 times

Result-Elektra-Report_02.jpg (82.15 KiB) Viewed 2602 times

Hi,

I've just bought Summary Reports and now playing around.
I ran into an issue, because of my ignorance or of not supporting

My Case:
I have a AppGini Project for registration gas/electric consuming per year per month
It would be great to have some reports of that to avoid actions by Excel afterwards
It is, for now, about two tables, connect to each other
The main table: Deelnemers (translated: Participants)
The other one: Verbruik elektra (Translated: Electric usage)
As you can see, Attachments, The Electric usage table has, per the columns (Int / Dec), a Year column and 12 Month columns and Total column

What I would like to create is a report in which I could select by YEAR or by (one of) months.
If this is possible to create, why can’t I create this
Is this not yet supported?
If not, will that come in short future?

Ron

[saymaad]

Hi Ron,

Since you're working with a table where each month is a separate column, that layout doesn’t play too nicely with the Summary Reports plugin, which expects a more normalized structure (like one row per participant per month). That’s probably why you’re running into limitations when trying to filter or group by year or month.

Nothing against this plugin but with the price tag, it does a lot and is great for many use cases. Still, I find it limiting for more customized or interactive reporting, so I always generate my reports and dashboards using custom pages with Chart.js, Tabulator, or other front-end libraries. It’s actually a very powerful approach when the built-in plugins don’t fully meet your needs.

With a custom page, though, you can either Query and restructure the data on the fly using PHP (even if the table has Jan–Dec as columns), or create a SQL view that "unpivots" the data into a format that Chart.js or Tabulator can easily consume. Here’s what that approach gives you:

• Full layout control
• Ability to create interactive charts or sortable/filterable tables
• Combine multiple datasets (electric + gas, yearly comparisons, etc.)
• Easily add export to Excel/CSV, search, filters, etc.

[RonP]

Hi Saymaad,

Thank you for the quick response.

Why did I buy Summary Reports?
As I'm not familiar with programming in PHP / JS..../ I was looking for a quick to install and easily to use plugin.

The AppGini application I use now is for people with no interesting in programming and so on and wants to have user-friendly input forms and, for me as admin, quick to generate reports.

I certainly can make an effort to create a view for the wanted functionality, that will be my next goal then
Ron