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

null
    • John_Halls
    • 1 yr ago
    • Reported - view

    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

    • janeefielding
    • 1 yr ago
    • Reported - view

    Thanks John!  What a great solution.  Sorry I didn’t think of it.  Thank you!

Content aside

  • 1 yr agoLast active
  • 2Replies
  • 42Views
  • 2 Following