Dear @lubos can you add multiple level group by in custom reports or, at least, a second level of grouping? Thanks

What is the use case? Can you give some example of report which you need this for?

I use inventory kits to create different finished products. I had to inventory kits many custom fields to classify them. When I create custom report it would be useful to have them grouped for example first by typology and secondly by subtypology.

I tried to build a custom report showing totals for sales reps. We print a report showing them what was sold for the month, for payout purposes, it would be nice to have customer > sales in income account A then another section for income account B. So if Johns Tractor store bought equipment and 3 …

Lubos pur it into ideas. Let’s see if he will implement it soon.

Just wondering , any update on this yet? - Thks

It’s in the air a major update in custom reports but still no news from @lubos

Another use case: Report grouped by Capital account (ie member) then Capital Sub account. (Then showing the transactions sorted by date)

As the time goes on I think more and more that @lubos should enable an “expert” mode in which the user can edit the existing query directly in SQL with the possibility to join different tables, group the results and so on. Just like in Access when you switch from the visual tool to the scripting one…

Davide I think Lubos has probably already given us a expert mode via the report transform facility.

Me too… but it’s a little bit to expert mode! It’s not just doing an SQL query but programming, ie declaring variables and writing scripts. And also… right now is focused only on taxation as far as I understand.

Custom Report - Multiple level group by

lubos May 31, 2020, 11:03pm 17

This has been implemented now as part of the new custom report implementation.

Topic		Replies	Views
[18.9.60] Improved custom reports (added visual query builder)	90	6034	November 11, 2018
Shared Custom Fields	22	1399	August 17, 2022
New implementation of custom reports available	111	10298	November 16, 2020
Request: Custom Report	1	495	September 20, 2019
Custom Reports	72	17151	May 17, 2018

Custom Report - Multiple level group by

Related topics