Deltek Talent Management

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Grouping Widget

The Grouping widget lets you add and order how your report rows are grouped. Any column with grouping added displays in this widget, whether it was grouped from the widget or by clicking the Grouping folder icon at the top of a column. You drag and drop grouped columns in the widget to re-order your grouping. You can also use expressions for more complex groupings. Grouping functionality uses the MySQL GROUP BY statement.

Contents

You access the Grouping widget on the Tools Report Action menu (Tools >> Grouping).

Grouping allows you to organize related data across multiple columns into one row. For example, if you create a report to show all of the courses still incomplete for your employees, you can group by Student Name. This creates a report where each employee in the Student Name column is listed only once in one row. Each employee's incomplete courses are then grouped together in the Course Name column for each employee.

Field Description
Widget ToolbarWidget Toolbar At the top of every widget are three action icons:
  • Details:Expands a panel with information about how to use the widget to build your report.
  • Refresh: Updates and reloads the content.
  • Close: Closes the widget.
Add grouping Click to add a column to group on, then select the column name from the Select a column to group by drop-down. You can also do the following:
  • Expression EditorEdit Expression: Advanced users with an understanding of MySQL can click to open the Expression Editor where
  • Static/Prompted Toggle:
and the type of sort, Ascending or Descending, for that column.
Grouping Icon Key Use this key to understand what each Grouping icon means:
  • Edit Expression:
  • Static/Prompted Toggle: