Grouping and Sorting tabs

From the Grouping tab:

 

The Grouping tab is primarily used to organize longer reports into a more convenient design - Usually grouped by project, task, employee, date, etc.

 

  1. From the Groupings list, select the items to group by and move them to the Selected list. The Groupings list contains those columns previously selected in the Columns tab that can be logically grouped.

  2. When grouping by more than one item, re-order the items using the up and down arrow buttons.

  3. Optionally check the Enable page break by topmost grouping option (not available for some report types).

 

From the Sorting tab:

The Sorting tab is used to change the order of data in a report. You can set from which column to sort by and set whether to sort ascending or descending.

 

  1. From the Sortings list, select the items to sort by and move them to the Selected list. The Sortings list contains those columns previously selected in the Columns tab that can be logically sorted.

Note: Any Grouping previously selected will have priority over any Sorting.

 

  1. Use the Sort Order drop-down list to select how the data column is sorted: Ascending (0 to 9, A to Z) or Descending.

  2. When sorting by more than one item, re-order the items using the up and down arrow buttons.

 

 

REPORTING
 

Basics

How to run a report

Public, private and favorite reports

Filters explained

Editing - making small changes to an existing report

Sneak peak at all the default reports

MORE FAQs                        Glossary

Operational Questions

Creating a report from scratch

Report types explained

Scheduling a report to run automatically

Calculated (custom) columns