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

Column Actions Menu

Use the Column Actions menu to perform column-specific actions available to the current user. For example, renaming a column, combining multiple columns, and specifying column format. The Column Actions menu is accessed within a report table on the Report Working. The actions available depend on your permissions and on whether you are creating, editing, or viewing the report.

Contents

Access a Column's Actions menu by clicking the column header or right-clicking anywhere in the column. You can also use the spacebar as a keyboard shortcut, after navigating to the column.

Field Description
Rename Column Click this option, edit the name, and click the checkmark to save.
Copy Click to insert a copy of the column to the right of the selected column.
Delete Click to remove the column from the report.
Combine with other columns Click this option to open a dialog that lists all columns in the report, then click the columns you want to combine. Before clicking Combine Now, specify the following options :
  • New column title: Enter the name and click the checkmark to save.
  • Remove the existing columns? Select Yes to replace the columns you selected with the combined result. Select No to add the combined column and keep the originals.
  • Separated by: Select the option used to separate values in the selected data.
Add filter on this column When selected the Filter widget opens where you can create a new filter using the column's values.
Edit with Expression Editor

Right-click a column and select Edit with Expression Editor to open Expression Editor. Users with basic knowledge of MySQL can use this tool to quickly create and edit SQL statements for your report using a graphical interface that allows you to drag and drop content like data objects, functions, and operators to build statements graphically. You can also use the Column formatting, Aggregate functions, and Options sub-menus to quickly add common functions and formats. Advanced users can choose to Switch to SQL View and manually enter their own SQL statements.

Column formatting This option allows you to select from common formatting options related to date and time, numbers, and simple text formatting, such as case and spacing.
Aggregate functions By default any column that does not contain grouping is auto-aggregated using the Group Concat - combine all distinct values function. You can use this menu to change the default to one of a selection of common aggregate functions without using the expression editor.
Options Select from the following options:
  • Show average in footer: Select this option to add a report footer containing the column's average for numeric and date values. When a checkmark displays, this option is selected.
  • Show total in footer: Select this option to add a report footer containing the column's total. When a checkmark displays, this option is selected
  • Display HTML tags when present: Select this option to retain any HTML tas in the column's values.
  • Hide Column
Pivot to columns (crosstab) Select to