C1 Grid Properties
Grid controls resemble and behave like an embedded spreadsheet with column headings, rows, and cells. The cells are generally equivalent to regular edit boxes and let you enter data as if you were in a spreadsheet program.
To navigate through the data in the grid, use the buttons and links in the navigation header.
Customize Link
The Customize Link on the grid takes you to the customization page for that grid. Using the left box on this page, you can reorder, hide, and freeze columns. The box on the right controls the sort order for sorting by column. Any personalizations that you make remain for that grid until you change them.
To Change the Column Order in the grid personalization page, select the column you want to move. To select multiple columns in succession, simply click and drag over the columns you wish to select. To select multiple columns that are separated from each other, hold the Ctrl key as you click on each column you want to select. Use the up and down arrows to change the order.
To Hide a Column, select the column you want to hide and click the
Hidden check box. Selecting multiple columns works the same as described above for changing the order of columns. Note that when you use the Find feature in the grid, the system does not search any columns that are set as hidden.
To Freeze a column, select the column you want to freeze and then select the Frozen check box. The system automatically freezes all columns above it in the Column Order grid. If you move a frozen column after an unfrozen column, the system turns off the frozen setting.
Be sure to click the OK button to save your changes and to return to the transaction page.
Manipulating Grid Column Sort Order
You can alter the sort order of grid columns in the Sort Order grid on the personalize page for that grid. When you save the personalization settings your sort remains every time you access that grid, even if you log off the PeopleSoft system and log in again later.
To specify a persistent sort order for the grid, use the Column Order grid of the grid personalization's page to select the column you want to sort. Click the right arrow to display that column in the Sort Order grid. Use the up and down arrow buttons to alter the sort hierarchy.
You can sort multiple columns at once. The system considers the first column in the list the primary sort, the second the secondary sort, and so on. Any columns you move to the sort order grid are sorted in ascending order. To sort in descending order, select the
Descending check box for the highlighted column. The system applies the (desc) text next to the column name to indicate the columns that are in descending sort order.
Find Link
The Find link represents the find feature in the navigation bar of your grid. When you click the Find link, a dialog box appears, prompting you to enter your search word or phrase. The find feature searches through all rows of data in the buffer and brings the first occurrence in your search string to the top of the row list in the grid.
View All Link
The View All Link allows you to view all of the rows of a grid, scroll area, or search page results list.
Downloading Grid Data
Some grids enable you to download the grid data to a Microsoft Excel spreadsheet. To download all the rows in the buffer, click View All and then click the download icon.
To download grid data, select the Download link in the grid. The File Download dialog box opens. Select
Save this File to Disk, and enter the directory in which you want to store the grid data. You can then use Excel to view and/or manipulate the data.
Created by the PeopleSoft Knowledge Management Team.
Copyright © 2002
All rights reserved.
Created: amq 12/01/2002