Throughout Projector Web you will encounter our Flex Search and Smart Grid. If you are unfamiliar with these tools you should read this page to gain a general understanding about how they function. You'll then be able to apply that knowledge anywhere you encounter them in Projector Web.
The flex search is where you specify your search criteria. It is an easy to use, yet incredibly powerful search tool.
- Add in search criteria like resource name, project name, cost center, etc
- Specify the values you are interested in
- Run your search. Easy!
From the dropdown box at the bottom, choose your criteria. You can also type text in to refine the available criteria.
Click the trash can icon () next to a criteria.
Start typing in any text field to see a list of relevant choices. Pick one by clicking on it.
Some criteria such as Project Code or Description can be searched based on a character string. For instance, searching Project Code using Begins with P001 would return all records with a Project Code such as P00100-001 but not P00200-001. Searching Does not contain - 01 would omit all records with a Project code containing hyphen-space-01 anywhere in the code.
The Advanced option allows advanced pattern matching using the following list of wildcard characters:
-  brackets can contain options for a single character, so  would look for either 3 or 5 for that character, and [3-5] would look for 3, 4, or 5.
- _ underscore is a wildcard for 1 character.
- % percent is a wildcard for 1 or more characters.
- ^ caret inverts whatever follows.
- \ backslash is the escape that can precede a special character, so \% would permit a search for items including the percent symbol.
For instance, searching a Project Code using Advanced P0011% would return all projects starting with either P00113 or P00114 but not P00115 etc. Searching Advanced %[^1-3] would return all records whose Project Code doesn’t end in 1, 2, or 3. These can be mixed to further refine the search.
The smart grid is where your search results are displayed. It functions much like a pivot table in Microsoft Excel. You can display flat data, or you can group data together and then drill into the details.
In the screenshot below you can see time cards grouped by resource. I've expanded the top node for Dolly Lee so that you can see the individual time cards.
Click the menu icon, , and choose Customize Grid. Columns on the left are available. Columns on the right are the ones displayed. Use the arrow keys or double click to move an item between columns.
Click the menu icon,, and choose Customize Grid. Use the arrows to reposition the column.
You can also reorder columns directly in the smart grid. Simply drag and drop the column in its new location. The insert location is denoted by a line between columns. You can see the line in the screenshot below - between Project Code and Project Role.
Group Data by Column
Data grouping is what gives you pivot table like abilities in the smart grid. Any field with a checkbox next to it is available for grouping. Some fields are not available for grouping, like time card description, as it is unlikely identical values would be available.
In the screenshot below I have grouped by Resource Display Name.
If your smart grid uses groupings, you can quickly toggle between them by using the Ctrl + Shift + Number keys. You must use the number keys above the letter section, not your number pad.
For example, Ctrl + Shift + 1 collapses everything together. Two would expand the next level. Three would expand the next level after that.
Make sure the smart grid has focus by clicking on it.
For advanced users, the summary grid is a great way to sift through large or complex searches. The summary grid displays a second grid on top of the first. This upper grid contains only roll up information. When you select one of the roll ups, the normal grid shows all the details.
In the screenshot below, the summary grid is on top. When you click on a row, the individual time cards are shown in the lower grid.
To enable the summary grid, click Options | Customize results grids | Grid Display Options | Choose Summary Grid with Details
You can then click View/Customize from the options dialog to specify the summary grid columns and grouping. Or click the menu icon () on an existing summary grid.
Notice in the screenshot below that the summary grid dispenses with the checkboxes for grouping and you instead use the dropdown boxes at the top. You can group on up to three columns.
Tick the Grand summary checkbox if you want to see subtotals in the summary area.
On the customize grid screens you'll see options for displaying totals.
- Checked summary - subtotal all items with ticked checkboxes
- Brand summary - subtotal all items regardless of checkbox state
In the screenshot below the checked summary and grand summary are shown.
Click theicon to bring up the options editor.
|Reporting Currency||Special columns in the results grid can FX'd to a single currency. Specify that currency.|
|Grid Display Options||Choose whether you want a signle results grid or two result grids. If you choose two grids, then one grid is a summary of the other.|
|View / Customize||Specify which colums of data should be returned in a result grid. You have the option of adding/removing fields, reordering them, grouping values, and specifying KPIs|