Viewing Data in Original Layout Grids

If the number of columns in a grid precludes you from viewing all of the grid data simultaneously without the page being cluttered, developers might design the grid so as to group and separate columns with tabs. This section discusses:

• Grid tabs

• Cell navigation

Grid Tabs

Grid tabs enable you to view groups of data columns simultaneously with little or no scrolling of the entire page to the right.

In this example, you see the Define Personalizations grid and the Definition, Format, and Explanation tabs. Notice the Show All Columns button to the right of the Explanation tab.

Image: Define Personalizations grid showing three tabs

This example illustrates the Define Personalizations grid showing three tabs.

To view all columns without tabs:

1. Click the Show All Columns button just below the navigation header of the grid.

   Showing all columns can expand the width of the web page so that a browser scroll bar appears at the bottom of the browser window.

   Alternatively, some grids may have an Expand All button to the right of the tabs, which enables you to expand the grid columns to the right so that no tabs appear.

2. You use the browser scroll bar to scroll left and right to view the data columns.

   Note: When in the expanded view, you cannot freeze columns because the entire grid moves with the page.

To restore the grid to its original state, click the Show Tabs button.

You can only move and freeze columns by using the Personalize link.

Only application developers can resize columns in an original layout grid by accessing the grid properties in Application Designer.

See Personalizing Grid Column Appearance.

See Inserting and Resizing Grid Controls.

You can change the sort order of a grid column directly on a transaction page. Sorts persist only as long as you are on a page. You can toggle between ascending and descending order by repeatedly clicking the column header. The last column header that you click becomes the primary sort for the grid. Grids enable you to have primary, secondary, and tertiary sorts. Original layout grids have no visual cue to indicate the sort order.

You can also change the sort order by using the Personalize link. This type of sort persists until you change it by using the Personalize link again.

See Personalizing Grids.

See Removing User-Specific Grid Settings.

You can remove user-specific settings such as sorts and column changes, which restores the default grid settings. To remove user-specific grid settings:

1. Click the Personalize link.

2. On the Personalize Column and Sort Order page, click the Delete Settings link.

   Note: If no Delete Settings link is available, click the OK button to restore the default settings.

3. On the Delete Settings page, click the Delete button.

4. On the Personalize Column and Sort Order page, click the OK button to restore the default settings.

Some grids enable you to download grid data to a Microsoft Excel spreadsheet. The download feature extracts all active, non-hidden rows, regardless of whether the rows are visible on your screen.

To download grid data:

1. Click the Download button in the navigation bar of the grid.

   A new browser window opens, showing the data in a spreadsheet-like format.

2. Select File > Save As and save the data as a Microsoft Excel (.xls) file.

   Note: The system downloads all field types (columns) with the exception of images. Hyperlinks and buttons are downloaded as quoted text of the field labels, even though the labels may contain numeric values. If any numeric calculations are to be performed based on hyperlink or button labels, you must convert the text strings to numeric values after downloading.

   Note: If you use Microsoft Office 2007, then when performing a download-to-Excel, you might encounter a Microsoft Office Excel warning message suggesting you verify that the file is not corrupted and that it is from a trusted source before opening it. You should click theYes button in this situation.

You might also encounter grids that you can collapse or expand. Click the right-pointing triangle in front of the grid heading to expand a grid that is hidden from view (collapsed).

These examples show both the collapsed and expanded states of the Component Interfaces grid:

Image: The Component Interfaces grid in the collapsed state

This image illustrates the Component Interfaces grid in the collapsed state.

Image: The Component Interfaces grid in the expanded state

This image illustrates the Component Interfaces grid in the expanded state.

See Using Scroll Areas and Scroll Bars.

Some grids enable you to zoom the grid to a modal window. When you click the Zoom icon, the grid and its data appear in a modal window over the main page, which is grayed out.

While in the modal window, you can work with the grid just as you would if the grid were on the primary page, for example, you can insert and delete rows. You must return to the primary page to save any changes to your data.

To return to the primary page, click the Return button at the bottom of the grid in the modal window.

See Using Grids