Follow
Applying sorting to a column by another object

Problem

You wish to apply sorting to a column by an object but not actually add the column with that object. For example, you wish to sort the Project Name column by its reference number but not include the column with the Reference Number.

 

Solution

To do that you will need to:

  • Open a new or the existing Project Report
  • Add the Project Reference Number column
  • Click to sort by that column
  • Switch to Text Mode
  • Copy the three lines from there:

sortOrder=2
sortType=asc
querysort=referenceNumber

  • Remove the Reference Number column
  • Click on the Project Name column
  • Switch to Text Mode
  • Paste the code 
  • Save And Close

Now your Project Name column will be sorted by the Project reference number but the Reference Number column will not be visible in the Report.