Aggregate only working in last leading subsummary

Classic Servoy
1

I am designing reports for my solution and finding that an aggregate is not behaving as expected. I have tested this on the orders table of the example_data database. I would like to have a report that groups data first by customer, then by employee, then by orderdate and shows a count of records for each grouping. I create a form with a leading subsummary for each group and place the same aggregate field (a count of the orderid column) in each subsummary. In 2.2.5, I sort the records in the order of the subsummaries and what I find is that the aggregate only shows the count for the last group in the sort and shows 1 for all the preceding subsummaries. In 3.0.1, the aggregate only works if there is only 1 leading subsummary.

Is this a Servoy limitation? If so, is there a workaround? HTML is not an option in this case until the 70-page limit problem is addressed.

Steve In LA

2

We are unable to reproduce this, could you please create a support case at: http://crm.servoy.com/servoy-webclient/ … oy_support

3

I have submitted a sample solution to the Support System. In creating it, I discovered that the problem only occurs if the aggregate value is shown in a label only. If a field for the aggregate is placed within the subsummary, then the aggregate value is correct in both the field and the label. I can use this as a workaround, but I lose the flexibiliy of being able to display the data in a label, such as if I wanted the value to appear in the middle of a sentence (i.e. “There are %%aggregate_value%% orders for customer %%customer_name%%.”).

4

We found and fixed the issue, it will be corrected in Servoy 3.1 rc1 (to be expected tomorrow)
Thanks for sending in a sample solution!