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

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • John Halls
    • John_Halls
    • 2 mths 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

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

    Like
Like Follow
  • 2 mths agoLast active
  • 2Replies
  • 29Views
  • 2 Following