0
Report Writer
Is it possible to sort on a field in the report writer but not display it? I have to sort on multiple fields so I had to concaténate them and it has to appear on the report.. not very professional looking. Or is there a different way to sort on multiple columns?
Thank you
2 replies
-
Hi Jane
jane.e.fielding said:
Is it possible to sort on a field in the report writer but not display it?Not that I am aware.
What I would recommend doing is create an additional number field, call it line, and add this code to a button or trigger
let a := 1; for b in ChildTable order by CompoundSortField do b.(Line := a); a := a + 1 end
Now include the line field as the first column of your report, and use this as the sort order. I see this commonly on documents and it looks highly professional.
Regards John
-
Thanks John! What a great solution. Sorry I didn’t think of it. Thank you!
Content aside
- 2 yrs agoLast active
- 2Replies
- 46Views
-
2
Following