sort error in %%<relation>.<field>%% label (4.0.1)

Classic Servoy
1

If I display a form in printPreview the sort (initSort and also controller.sort())is not respected.
If I order alphabetically all the alphabeth letters, the Z id displayed as first and after all the others letters (B…Y)

This is simply catastrophic if there are subsummary, cause all the record are faulty graphically related.

In attachment a sample solution.
In the 2 report as you can see the record is not correctly sorted.

Servoy 4.0.1
MySQL 5.0.45 (5.1.6 connector)

test.servoy (6.31 KB)

2

We will have a look at that.

Regards

3

I made more test and if the printPreviewed report has more than one page, the fault is on every page:
the first entry of the page should be the last or something of similar…

And then…

the problem seem related to the labels objects 'cause if I replace them with fields the problem not exist.

4

I tested the solution and found the following:

  1. the sorting is ok, including in print preview
  2. the label %%.%% is not ok: it seems that the order of the labels is not updated when making the sort.

I will look at this last issue. Thanks for posting this.

Regards

5
  1. … this happens only in smart client.
6

This issue is corrected in the next public release of Servoy (4.0.2).