Sorting in report designer PDF page design

User Talk
1

hello there,

Strange issue.
The sorting in the page design seems okay in the page designer, but when printing PDF its wrong.
I have 10, 11, 12 coming after 1, instead of 9. Screenshot 1 is from the designer, screenshot 2 is from the PDF.

Screenshot 2025-07-14 101005
Screenshot 2025-07-14 101005574Ă—1027 9.64 KB

Screenshot 2025-07-14 105606
Screenshot 2025-07-14 105606717Ă—1106 94.9 KB

2

I have two questions:

  1. Do you mean report design plugin? (Because you mentioned page design plugin too.)
  2. What column type is “Module CH#” column?
3

  1. This is from page design, inside the page design plug in. When doing a PDF export (the top right hand side button).

  2. It’s a text type column.

4

This is a limitation in sorting for text column. When you export the PDF, the list of rows is sorted at the server side using the dtable-db component, which does not support sorting with mixed text and number.

5

I see. So if I change it to numbers only it will be okay? (I’ll need to change how I do a few things but maybe I can work it out)

6

If you change it to numbers, the sorting should work.

1 Like