0

How to sort records in print format?

I have a table that has a child table. The first table has the heading informtation for my report. It's child table has the line items for the report.
I can do this well, but I can't find a way to sort the line items. The line items has 5 fields or columns. I need to sort by 3 of those: task type; then Expected Completion; finally Complete.
THis will be the equivalent of a SQL Select order by (these can be nested or several listed).
I would apprciate some help in this matter.
Thanks very much!Screen Shot 2020-05-03 at 3.19.47 PM

2 replies

null
    • Cegep de jonquiere
    • James_Deraps.1
    • 3 yrs ago
    • Reported - view

    In Print format: add formula with a concatenation of task type+ Expected Completion+ finally Complete and sort up or down. after that select the formula field (It will change in blue) change the colon width by only 1

    • JPL
    • Rosana
    • 3 yrs ago
    • Reported - view

    Hi James, thanks very much for your response. How do I sort in print format? I was not able to figure this out. I sort in the form format, but is nor reflected in the print format. This seems basic but like I said I was not able to figure it out!

    Thanks again!

Login to reply

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 751Views