Columns & Groups Tab
Use the Columns & Groups tab to select the columns, groups, and also to specify the sequence in which data displays on the report.
This tab displays as either a Columns tab, a Groups tab, or a Columns & Groups tab, depending on the type of report that you selected. In this topic, it will be referred to as the Columns & Groups tab.
The type of report that you select determines the sections that are available on the Columns & Groups tab.
Grouping and Sorting
Use options in this section to sort and group data on a report, to make it easier to locate and review report data. You can select multiple sorting and grouping criteria for a single report. The sequence in which you arrange the selected criteria determines which group or sort is applied first.
For example, you can sort and group the Project Summary report first by project manager and then by project number for each project manager. You can also print subtotals for each group. In addition, you can sort a report without grouping it if you disable the heading and subtotal options.
You set report options on standard reports separately for each company. When you switch companies, the standard report options reset back to the default options. However, saved favorite reports, saved favorite options. and saved favorite selections remain the same, even when you switch companies.
Some reports are company-specific and only include details for a single company. For example, payroll reports are company-specific because they only allow you to view an employee's payroll information for one company at a time.
| Field | Description |
|---|---|
| Grid Type | In this field, specify the grid for which you want to include additional columns. Reports with this option can only include information from one grid. The sorting, grouping, and columns that are available for the report will vary, based on your grid type selection. For example, contact-related fields are available if you select
Contacts.
When you select an option from the drop-down list Vantagepoint displays the grid column labels with a prefix for that record type. For example, if you select Contacts, the grid column labels appear as Contacts - (such as, Contacts - Name, Contacts - Title, and so on). |
| Grouping and Sorting Grid | The order of the selected items in the grid determines the sort or group order. The information is sorted or grouped first by the first selected item and then by the second, and so on. To move an item up or down in the sort order, use
 to the left of the grid and drag it to move that row up or down in the list.
You can combine multiple sort or group fields. If you do, the lowest sorting level has the most detailed information. For example, if you sort by project, then by phase, and then by task, the task level has the most detailed information. |
| Group By | This column lists the fields by which the current report is grouped or sorted. |
| Label | Use this column to enter the label for the column header that displays on the report. You can change the label for an individual report. |
| Sort In | In this column, specify whether data sorts in ascending or descending order. Click the
Sort column for a sort criterion and then select one of the following:
|
| Project Level | If the sorting and grouping criterion is project-related and can be specified at any level of the work breakdown structure (WBS), select the WBS level on which you want to base the sorting and grouping.
For example, Principal Number displays only once in the list of sorting and grouping criterion for the Project Earnings report, but you can assign principals at each of the WBS levels. If you select Principal Number as a sorting criterion and you want to sort by the principal assigned at the project level of the WBS, select Project in Project Level. If you want to sort by the principals assigned at the phase level, select Phase in Project Level. |
| Color | Select the color of the sort band for each sorting level. Click in this column for a sort criterion to display the color palette, which you can use in one of the following ways:
|
| Subtotal | Use this toggle to turn on ( ) or off ( ) the subtotal for the grouping. When subtotals are turned on,
Vantagepoint totals the amounts for this group. The total is shown either in the header line, if you selected the
Show Totals on Header check box in the
Other Options section, or as a footer.
If you exclude the header and subtotal, Vantagepoint sorts data, rather than grouping data, on the report. If Subtotal is turned on and the Hide Single Line Totals check box is selected in the Group Options section, totals do not display for groups that contain only one detail line. |
| Heading | Use this toggle to include () or exclude () the label for the criterion on the report. If the heading is not displayed, then the report is simply sorted and not grouped by this field.
|
| Page Heading | Use this toggle to turn on () or off () the page heading. When this option is on, the sorting group headings repeat on subsequent pages when data for the group spans more than one page.
|
| Collapse/Expand | You can set up group levels so that you can collapse and expand the groups at that level to display or hide the sub-groups and detail rows when you preview the report. If you print the report from the Preview window, the groups are expanded or collapsed just as they are on the Preview window.
For the sorting and grouping criterion, select one of the following:
If you search for text in a previewed report, the search only finds the target text if it is visible when you do the search. It does not find data that is hidden in collapsed groups. |
| Line Separator | Select the type of line to print between sort groups on the report. When you preview the report, dotted lines display as lines of short dashes. However, when you print the report, they are dotted lines. |
| Page Break | Use this toggle to turn on () or off () page breaks. Move the toggle to the on position if you want a new report page each time that the sort value changes.
Vantagepoint repeats the sorting group headings on subsequent pages when data for the group spans more than one page.
For example, if you select Office as a sort criterion, you have three offices, and you select Page Break for the office sort criterion, Vantagepoint begins printing the information for each office at the top of a new page. |
| + Manage Grouping | Click this link to display the Select Groupings dialog box, which you use to find and select the grouping options that you want to include on the report. |
Columns Section
Use this grid to add, sort, delete columns that you want to include in the report. The columns that are available for this grid can include both standard fields, user-defined fields, grid columns and user-defined calculations that can vary based on the type of report you selected. Many reports can only include information from one grid. To change the grid columns that are available, use the Grid Type field in the Grouping and Sorting section.
| Field | Description |
|---|---|
| Name | This grid column displays the column name.
The column name is not the column heading for the report. Heading (described below) displays the default column heading. |
| Heading | Enter the heading that is displayed on the report for the column. If you enter a heading that is longer than the space for the heading, you might need to adjust the column width in Width. Headings automatically wrap to 2 lines if they do not fit in the width of the column. |
| Width | Enter the width of the column in either inches or millimeters based on which one you selected in the
Unit of Measure field on the Layout tab.
If you select inches, enter fractions using decimals (for example 1.00, 1.5, and so on). By default, Vantagepoint provides column widths suitable for the default heading text in Heading. If you enter a longer heading, you can adjust the column width. |
| Format | For date, currency, number columns, and memo columns, this field displays the format in which the report presents the column value. To change the format, click in the Format column and select the format that you want to change. |
| Alignment | Specify how you want the data aligned in the column: left justified, centered, or right justified. |
| Type | This grid column displays the type of column:
|
|
This option displays at end of the row when you hover over the row that represents the column in the Columns grid. Click
to remove the column from the report. If you later need to add the column again, use the Select Columns dialog box.
|
|
If the line item is a calculated field, this option displays at the end of the row when you hover over the row that represents the column in the Columns grid. Click
and select any of the following menu options:
|
| + Manage Columns | Click this link to open the Select Columns dialog box to add or remove columns from the grid. See the Select Columns dialog box help topic for detailed information. |
| + New Calculation | Click this link to open the Calculated Fields dialog box to create a new calculated field for the report. See the Calculated Fields dialog box help topic for detailed information. |
Group Options
Use options in this section to apply other formatting options to the groupings that are displayed on the report.
| Field | Description |
|---|---|
| Indent First Column | To indent the first column on the report, enter the size of the indent in this field. Use the corresponding Unit of Measure option on the Layout tab to specify inches or millimeters as the unit of measure for the indent. |
| Indent for Each Group | To indent each group on the report, enter the size of the indent in this field. Use the corresponding Unit of Measure option on the Layout tab to specify inches or millimeters as the unit of measure for the indent. |
| Show Totals on Header | Select this check box to display totals in the header row for each group, rather than at the end of the group. This option is enabled if you are grouping by at least one field. It is particularly useful to show totals on the header if you use collapsible groups on your report. |
| Hide Single Line Totals | Select this check box if you do not want group totals displayed when the group contains only one detail line. This check box is enabled if you are grouping by at least one field and the Show Totals on Header check box is cleared. |
| Hide Document Map | A document map is an outline of the structure of a report, based on the sorting and grouping criteria that you set up for the report. A document map contains a link for each sorting and grouping value.
This option is selected by default, which hides the document map (outline) from the report. To show the document map on the report, clear the check box. If you export the report to Excel, this option controls whether or not the outline is also exported. |
| Show Final Totals | Select this check box to display final totals of all groups and data on the report. |
| Field | Description |
|---|---|
| Show | Select one of the following options to determine the detail displayed for groups:
|