Grouping items, with subsummary

Classic Servoy
1

Hello everyone,

I would like to ask for your opinion about how something should be done in Servoy.

Here is the situation: i have a table with groups and a table with items related 1-m. Also the items table has some columns and calculations that I want to show.

What I want is a form (listview) in which all the items are displayed grouped by groups, with subtotals after each group and with a grand total at the end. Also there are fields that should be editable, so this excludes a read-only (html) report.

What do you think, did you encounter something like this? What would be the correct aproach?

Thanks,
Adrian

2

Hi Adrian,

You should do this in HTML, because you can’t show the subtotals without print preview.

3

Hi Bob,

First of all, thanks for your answer.

I want the fields of my table to be editable, so I don’t see how html can be a solution. Something like a DataGrid is what I’m following, but with groups and subtotals after each group.

Best,
Adrian

4

Hi again,

I was thinking of some methods of achieveing my list-view, did not manage so far still wanted to share.

A trailing subsummary on a sorted foundset seems very good, just that the subsummary is not visible but in print-preview (please correct me if I’m wrong) and also I think I can display in the subsummary just some basic aggregates (also I hope I’m wrong :) )

Well, I’m still looking… some extravagant ideas come to my mind… really isn’t there a way to do it in Servoy?

Best,
Adrian