CobbleStone Documentation Wiki Welcome Guest: 6/21/2024 12:05:36 AM
 
View for Version
 
 
Contract Insight Version:
select
Version Released On:
Friday, October 8, 2021
 
   
 
Search
 
 

search text
Search 
 
   
 
Navigation
 
 
 
   
4. Sort Order   
Page last modified on Monday, September 24, 2018 9:43 AM (by Nash DeVita) (initially created on Wednesday, July 20, 2011 2:36 PM)
Assigned to: Ad-Hoc Report Wizard: Legacy Reports
  Generate Manual Print View
 
Page Content
 
 

Ad-Hoc Report Wizard: Sort Order

 

The fourth step in the wizard allows for one or more fields selected in step 2 to be assigned as a default or starting sort order. 

 
Sort Order Management

Managing the sort order consists of two multi-select boxes:

1. The Selected Table-Fields (the left-hand box). It shows all the fields selected in step 2 for this ad-hoc report.

2. The Table-Field Sort Order (the right-hand box). It shows the fields selected for the sort order.

To use a field in the sort order, the field can either be clicked and dragged from the left-hand box to the right-hand box, or the field can be selected in the left-hand box and moved to the sort order (right-hand box) by clicking the right arrow button.

 

Setting sort order parameters

Once a field is moved to the Sort Order (right-hand box), a parameter based area displays.

 

Each field can be specified as either sorting based on Ascending or Descending order.

Sort Order Hierarchy

When defining multiple fields to be part of the sort order, you are configuring a sort order hierarchy. Sort Order Hierarchies follow the following logic:

  • Sort the results of the report by the first field specified in the sort order
  • For any duplicates based on the previous field sort order, sort those duplicates based on the next field in the sort order
  • Repeat this step for any additional fields in the sort order (field 3 and up)

With this logic in mind, the last aspect of the sort order functionality is the ordering of fields selected for the sort order. To change the order, click the field in questions and click the up or down arrows to the right of the Sort Order box (right-hand box). This moves the field up or down in the sort order hierarchy.

 

 
   
 
Related Wiki Video Tutorials
 
 
 
   
 
Page Tags (Keywords)
 
  
   
 
Files & Attachments
 
  
   
 
CobbleStone Software |  Contract Insight Wiki |  version: 17.1.1.171020
CobbleStone Software is developed in the U.S.A.