Portlets › Grid Portlets › Determine a Grid Portlet's Columns and Layout

Determine a Grid Portlet's Columns and Layout

Use the following procedure to determine the column sort order of data that appears in a grid portlet. You can specify how columns will be sorted, filter options, and define how virtual columns or rows that are derived from your query data appear on the grid.

To determine the layout of grid portlets

1. With the grid portlet open, click Layout under the List Column Section content menu.

   The layout page appears.

2. In the Column Layout section, select columns to include in the grid by highlighting the columns in the Available Columns list and clicking the right arrow to add them to the Selected Columns list.

   You can use the up and down arrows to place the selected columns in the desired order.

3. Complete the following actions in the Column Sorting section:
   1. Select the order in which columns are sorted by selecting the appropriate field in each column drop-down list.
   2. Click Ascending or Descending to determine how data is sorted within each column.
4. Click Save.

To view and edit the fields that display for a grid portlet

1. With the grid portlet open, click Fields from the List Column Section content menu.

   The fields page appears.

2. Use the Show and Display fields to control what you see in the list by selecting columns, or a combination of both, select the correct option and click Go.
3. To make changes to how a field displays, click the Properties icon located next to the field.

To determine grid display options

1. With the grid portlet open, click Options under the List Column Section content menu.
2. Complete the following fields:

   Secondary Value Display

   Indicates the way that secondary values display in a grid cell. Select Mouseover only to have no secondary value display.

   Select Mouseover and redline to display a secondary value when a user places the pointer over a cell in a grid. This helps you compare values. For example, if you have a column called Cost and another column called Baseline Cost, you might want to display both values in one cell. To show both, you can choose Baseline Cost as the secondary value. The Cost value displays as usual; however, when a user moves the pointer over a cell in the grid, the Baseline Cost also displays.

   Select Show Null Secondary Values to show the secondary value even when there is no number value to show.

   Rows per Page

   Specifies the number of rows per page to display.

   Filter

   Indicates how the results appear initially. Select an option that indicates if you want immediate results or results provided after you set the filter.

   Highlight Row by Attribute

   Specifies the attribute whose row is highlighted when the attribute's value is not zero.

   Display Currency Code in Column

   For money attributes, the currency code is shown in the column. This applies only when a single currency is being used. Select the check box to display the currency code.

   Allow Configuration

   Indicates a user can make changes to the appearance of a portlet. Select the check box to allow configuration.

   Allow Label Configuration

   Indicates a user can make changes to a portlet's labels. Select the check box to allow configuration.

3. Click Save.

More information:

Create a Grid Portlet

Add a Gantt Chart to a Grid Portlet

Add an Image to a Grid Portlet

Add a Progress Bar to a Grid Portlet

Add a Time-Scaled Value to a Grid Portlet

Add an Aggregation Row for a Number Field to a Grid Portlet