Filter Column - Choose the column (or on which the filter will be applied. “field”) Filter Operator - Choose the type of filter operation (see Filter Operators below) Filter Expression - Enter the specific criteria for the filter. Page The page section allows you to specify how many records you want to display at a time in the results grid. For example, if you enter 15, then the results grid will only show the first 15 matching records of your report. However, you can view the additional records by clicking the Next link under the grid, which will then display the next 15 matching records. View Now that you have specified all of your desired criteria in the sections click the View link to view the results of your report. The results display in a grid, similar to other grids in the applications. You can download the results of the grid to a spreadsheet by clicking the Download link at the bottom of the grid. You can print the results to a PDF (requires Adobe PDF Viewer) by clicking the "Print to PDF" button. Total In order to determine the total number of records that are in your report, click the Total link. This is useful if you want to know the number of assets with a particular criteria (e.g., number of assets in a particular department), but don't want to view the individual attributes about each asset. Filter Operators The following filter operators are available: Equal This will match assets where the field value is exactly equal to the value you specify in the Filter Expression field. For example, you choose the Status field and enter Active in the filter expression, then only active assets will be included. Does Not Equal This will match assets where the field value is not equal to the value you specify in the Filter Expression field. For example, you choose the Status field and enter Active in the filter expression, then active assets will be excluded from your report. Is Blank This will match assets where the field value is has no value. For example, you choose the Serial Number
Filter Column - Choose the column (or “field”) on which the filter will be applied. Filter Operator - Choose the type of filter operation (see Filter Operators below) Filter Expression - Enter the specific criteria for the filter. Page The page section allows you to specify how many records you want to display at a time in the results grid. For example, if you enter 15, then the results grid will only show the first 15 matching records of your report. However, you can view the additional records by clicking the Next link under the grid, which will then display the next 15 matching records. View Now that you have specified all of your desired criteria in the sections click the View link to view the results of your report. The results display in a grid, similar to other grids in the applications. You can download the results of the grid to a spreadsheet by clicking the Download link at the bottom of the grid. You can print the results to a PDF (requires Adobe PDF Viewer) by clicking the "Print to PDF" button. Total In order to determine the total number of records that are in your report, click the Total link. This is useful if you want to know the number of assets with a particular criteria (e.g., number of assets in a particular department), but don't want to view the individual attributes about each asset. Filter Operators The following filter operators are available: Equal This will match assets where the field value is exactly equal to the value you specify in the Filter Expression field. For example, you choose the Status field and enter Active in the filter expression, then only active assets will be included. Does Not Equal This will match assets where the field value is not equal to the value you specify in the Filter Expression field. For example, you choose the Status field and enter Active in the filter expression, then active assets will be excluded from your report. Is Blank This will match assets where the field value is has no value. For example, you choose the Serial Number
UCTrainingGuideDepartmentUser.docx