data in Leadingsubsummary not updated

Classic Servoy
1

I have the following problem:

I have a field: weeknr (calculation: return parseInt(utils.dateFormat(offertedatum, ‘w’));_ which returns the weeknr of the field: offertedatum

This field (weeknr) is placed in a Leading subsummary and in a Trailing subsummary (both sorted on weeknr!): See the picture: designer.gif

now if I sort the form on: weeknr and goto printpreview the weeknr are not updated in both subsummaries!
See picture: printpreview.gif
In Filemaker this works like a charm.

I think this beheaviour has been adjusted with the header and the footer. But I think not in a subsummary (or maybe a grant total)

Please help!

2

Use the MAXIMUM type.

3

What are you meaning by that?

4

sorry - meant to say…

Create an aggregation column where the type is set to Maximum.

When you place this on the form in a subtotal area it should work.

5

Ah oke, that works!
In Filemaker you don’t need to create a aggregation
Servoy-guys: Is this staying this way? Or is this the right approach?

6

Yes, creating a aggregate is the the right approach.