Sub-Summary Report; Very wierd form behaviour

Classic Servoy
1

Using Servoy R2 2.0 rc7 & rc8.

I have created a new form and defined a subsummary part to sort by a break field. The form has two fields only on it, the break field and an aggregate field summing the total value of a field in the table. When I exit Designer mode, my form comes up with multiple lines of identical text and start with the word ‘Records’ followed by [COLUMS: and then a list of all the field names from this particular table. Below the 13 or so lines that are displaying, in a gray area that stretches to the bottom of the table is the grand total of all the records found. I have tried sorting by the break field and going into Print Preview but the pages there display as completely empty. In Designer mode, I have made sure that there is plenty of room below the fields so that the part does not cut off part of the field but it makes no difference. Any suggestions gratefully received. TIA.

2

my form comes up with multiple lines of identical text and start with the word ‘Records’ followed by [COLUMS: and then a list of all the field names from this particular table

is normally only seen when you do not place a body part

going into Print Preview but the pages there display as completely empty

did you do a sort on the column(s) in the subsummary?

3

There is no body in the report as you suggested and yes, I did sort by the break field. Even if I put the body back and then sort again, nothing shows up in print preview and there is no page counter even though over 200 rows of data have been found.

4

Hello Michael,

Are you still having problems with this report?
If so, please send me your solution and I’ll have a look at it.

5

I have the same issue, is there some solutions for this allready?

Servoy Developer
Version R2 2.2rc6-build 324
Java version 1.4.2-38 (Mac OS X)

6

freecolours:
…I have the same issue…

Well thanks for sending sample solution but it’s for sure not the same issue (the issue in this topic is fixed in Servoy 2.2RC6). What you are trying todo is showing the productname while grouping(=subsummary) on quantity (all based on table order_lines)
This is just impossible todo since 2 or more order_lines(= different products) may return (having the same quantity), so now you have multiple descriptions for one row, which one should be displayed?

Pls investigate your repport and design it better…