Use of part Trailing subsummary.

Classic Servoy
1

Hello Servoy users.

I would like produce reports with total and subtotal and I try to use trailing subsummary in order to display the total order on that specific part of my form after each order.

My form is like this :

Order id Product Quantity Price Total Line
101 122 10 25 250
101 145 6 7 42
101 107 12 12 144

Total order : 436

Is it possible to use trailing subsummarry to calculate and print the Total order and how ???

I have had trailing subsummary part on my form based on OrderId and I add a label and total on that part but nothing appears on that part of the form ???

:?:

I hope somebody can help me.

Thanks in advance.

2

In the help navigator (help in Developer) there is a section ‘form parts’. That should help you a great deal with what you try to do I think!

3

I had read that part, that don’t help me at all. I suppose I miss something obvious.

Anyway, I will never post something in the forum before looking on the help and the forum itself.

Regards.

4

Hi

Just a thought but have you sorted the data by your order_id?

subsummary parts won’t show any values unless you first sort the data by whatever the part is ordered by.

5

Yes I sort the records by orderid. I try to do the sort using “initialSort” property of the form or with method called by method linked to “onShow” property of the form.

But nothing happens.

Thanks for suggestion.

6

Are you previewing the report?

7

Thanks a lot Christian.

I was not aware that we can not see the subsummarry before Preview.

:D

DomTom.

8

Hi,

Indeed you cannot see the subsummary before print preview. But I don’t want to print :) … So I come and ask: why not being able to see the subsummary in normal mode? … after all, it’s a nice feature

Best,
Adrian