How to: Reference: |
The Grid Tool enables you to change the column order, select multiple columns to sort ascending or descending, hide and show columns, add a calculation result to a column, and add subtotals in the active report.
This topic describes how to show the Grid Tool menu option when an active report is run, and how to use the Grid Tool.
The Report Options dialog box opens.
The Format tab of the Report Options dialog box provides options for formatting an active report.
The following image shows the options on the Customize User Interactivity dialog box for a Power user. The Grid Tool check box is located at the lower right of the dialog box. For a Power user, the Grid Tool is selected by default. For an Analytical or Business user, the Grid Tool is deselected by default.
Tip: The Advanced Tools include the Grid Tool, the Pivot Tool, and the Chart/Rollup Tool. The Advanced Tools check box at the lower left of the Customize User Interactivity dialog box controls the display of the menu options for all three tools when an active report is run.
If you selected the check box for the Grid Tool on the Customize User Interactivity dialog box, you will see the Grid Tool option on the menu, as shown in the following image.
The Grid Tool opens, as shown in the image below.
The columns are displayed in the order that they appear in the active report.
Tip: You may left-click and drag the columns in the Column Order section to reorder the list.
By default, the Grid Tool displays Hide icons for the hidden fields (HIDE=ON StyleSheet setting) and NOPRINT fields in the procedure. The Grid Tool displays Show icons for anything else.
There are no calculations set by default.
When columns are added to the Sort Order section, options for sorting ascending or descending appear. The default sort order is ascending, lowest to highest (A to Z). Click the sort order icon to switch to descending, highest to lowest (Z to A).
In the example below, COUNTRY is descending and CAR is ascending.
A Subtotal column appears in the Sort Order section. No subtotals are selected by default.
When Group sort columns is selected, the columns in the report are grouped by the order specified in the Sort Order section. These columns are repositioned to the beginning of the report and override the Column Order list.
In the following example, MODEL and SEATS are hidden, DEALER_COST and RETAIL_COST have a Sum aggregation type, COUNTRY, CAR, MODEL, and SEATS appear in the Sort Order column, Group sort columns is selected, and Subtotal is applied to CAR.
The active report is generated based on the sort fields selected.
In the example below, the subtotal of sum values appear under DEALER_COST and RETAIL_COST by the CAR field. You may select Grid Tool from the column menu to open the Grid Tool again.
The following apply when you use the Grid Tool in active reports:
TYPE=REPORT,OBJECT=CALC-AREA,COLOR=WHITE,BACKCOLOR=BLACK,$
TYPE=TITLE,FONT='GEORGIA',COLOR=RGB(78 137 187),$
WebFOCUS |