Use an Advanced Search to Find Report Data
Use the advanced search options to search a report that is displayed in the Preview window, based on the fields and search values that you specify in the Search Criteria grid. You can then view the search results, print them, or download them to a spreadsheet.
Keep the following guidelines in mind as you use the advanced search feature:
- The advanced search feature is not available if you use SQL Server Express or SQL Server Workgroup.
- For quick results, the Search Criteria grid remembers your prior selection each time that you access the grid.
- The list of search fields generated is based on the structure of the report. That structure is determined by your sorting and grouping criteria, other report options that you select, and groups that are built into the report. Use the information in the
Level
column and the
Name column to locate the fields that you want.
For example, if you want to search the Project Summary report and include current hours from detail rows in the search results, select the grid row that contains Detail in Level and Current Hours in Name. If you instead want to see total current hours for projects, select the grid row that contains Group Project Number in Level and Current Hours in Name. Vantagepoint attempts to provide meaningful names for the levels and fields, but in some cases, it must use generic names. If you cannot tell from the level and field name which search field to select, pick the most likely candidate and do a trial search.
- The search results columns display from left to right in the same order that the fields display in the grid on the Search Criteria tab. To change that order before you launch the search, use the row option and drag and drop the rows into the desired order.
- You cannot use the search output as links to jump to the corresponding location in the report.
To use an advanced search to find report data:
- Related Topics:
- Group Advanced Search Results
After creating an advanced search, you can organize and group the search results so you can extract report information and downloaded to an external file or spreadsheet. - Filter Advanced Search Results
After you complete an advanced search of a previewed report, you can filter the results of the search to focus on specific data. - Sort Advanced Search Results
After you do an advanced search of a previewed report, you can change how the results of the search are sorted.