Select Records for a Resource Planning Report

You can select the records included on a report using standard searches, custom searches, and report column filters. Deltek CRM "remembers" your latest standard or custom search for each report and applies it by default the next time you display the report.

To select the records included on a report, complete the following steps:

1. In the Resource Planning workspace, click to go to the Reporting area.
2. If the report that displays by default is not the report you want, do either of the following:
   • To display the standard Resources or Projects report, click the currently displayed standard report name (Resources or Projects) located above the upper-left corner of the report and select the standard report you want.
   • To display a saved report, use the Find saved report field at the top of the Reporting area to select the report.
3. If the default search displayed next to the standard report name is not the search you want, click that search name to display the drop-down list.

   To see the search criteria for the currently selected search in a tooltip, hover over the search name if the search is saved, or over Custom if it is not saved. (Tablet users can tap Refine next to the search name or Custom to see the search criteria.)

4. Do one of the following:
   • If the report is a version of the Projects report, click All Projects to include all projects.
   • If the report is a version of the Resources report:
     • Click All Resources to include all active employees and generic resources.
     • Click All Employees to include all active employees but exclude generic resources
     • Click Generic Resources to include active generic resources but not employees.
     • Click Employees I Supervise to include only active employees to whom you are linked as their supervisor.
     • Click Resources in My Organization to include only active employees and generic resources who are assigned to the same organization as you are.
   • Click a previously saved custom search to display the records returned by that search.
   • If none of the standard searches or the available custom searches is adequate, click Custom to create a new custom search.
   If the report contains a very large number of rows, which could occur if you simply select All Resources, it can take a long time to display. To avoid that delay, Deltek CRM does not display the report in that situation. Instead, it prompts you to apply a different search to restrict the number of records on the report.
5. If you selected Custom in the previous step and want to save the custom search so you can use it again in the future, enter a name for it in SEARCH NAME on the Custom Search dialog box.

   If you do not want to save the search, you do not need to give it a name.

6. Use the other fields on the dialog box to enter search values to further restrict the list of records that the search returns.
   For many fields with drop-down lists, you can select multiple search values. For lookup fields, you can also do the following:

   • Type a single character in the field and select the STARTS WITH <character> option at the top of the drop-down list to search for records with values in that field that start with the character you typed:

     

   • Type a string of characters and select the CONTAINS <characters> option at the top of the drop-down list to search for records with values in that field that contain that string of characters:

     

   If you enter search parameters and then decide you want to clear all of them and start over, click x Clear All at the bottom of the dialog box.

   Deltek CRM provides a default set of fields on this dialog box. However, if you need to select records for the report based on values in other fields, you can click + Add Field at the bottom of the dialog box to add a field to the dialog box. You can also delete fields from the dialog box that you never expect to use. To delete a field, hover over the field and click to the right of the field name. (If does not appear when you hover over a field, that field cannot be deleted.)

7. Do one of the following:
   • To save the search so you can use it again in the future, and then perform the search, click Save.
   • To perform the search without saving it, click Apply.

   The Custom Search dialog box closes, and the report displays the selected records.

8. If after viewing the report you want to make changes to your custom search, click Refine next to the search name to display the Custom Search dialog box again and modify the search.
9. To apply additional filters based on values in columns displayed on the report, do the following:
   1. Click above the upper-right corner of the report.
   2. In the fields that display below the column headings, specify filter values for one or more of the report columns.
   3. To hide the filter fields, click again. The filters are still active when the fields are hidden, and displays at the right side of each column heading area as a reminder that the report is filtered based on those columns.

   You can only use column filters for columns that you have selected to display on the report.

   Column filters are applied to the records currently selected by the standard or custom search you have applied. In other words, only records that satisfy both the search criteria and the column filters display on the report. If you specify column filters and then select a different saved report, all column filters are discarded, and the column filters for the newly selected report, if any, are applied.

   If you apply a search or filters and then want to clear those and start over with the default report (with only the All Resources or All Projects search applied), click Clear all filters above the upper-right corner of the report. If you are viewing a saved report and click Clear all filters, the default report for the area is displayed instead of the saved report.