PeopleSoft Grid

PeopleSoft, by default, provide options to sort and search contents of the grid. Users can add / remove data from the grid when these features are enabled by the developer.

Peoplesoft Grid PIA

Peoplesoft Grid PIA

Peoplesoft Grid App Designer

Peoplesoft Grid App Designer

Peoplesoft Grid Levels

Peoplesoft Grid Levels

A major differentiation of PeopleSoft Grids from other objects on a PeopleSoft page is that a table or view needs to be associated with them for the definition to be complete. In short, you may not place a grid with the main record as a Derived / Work record on a page.

PeopleSoft no data for scroll

PeopleSoft Error: no data for scroll

If the Main Record provided is a Derived / Work record, PeopleSoft Application Designer would throw an error stating “No data for scroll”.

In such a case, the best alternative would be to use a Dynamic view with SQL Definition left blank as the main record and check the No Auto Select and No Auto Update on the Use tab of the Grid properties. You can then populate the grid using PeopleCode

Grid Properties

Grid Properties

Peoplesoft Grid Properties Main Record

PeopleSoft Grid Properties Main Record

Tags: 
Subscribe to Comments RSS Feed in this post
8 Responses
  1. Very useful. Thanks.

  2. Very helpful. I noticed that your screen shot shows that you ALSO have to check No Row Insert and No Row Delete for the dynamic view grid to work, but those fields were not described in the explanatory text as needing to be checked.

    At any rate, it’s just what I needed! Thanks!

  3. Hi Rakesh,
    I’ve doubt in Grid. How to use the two records withing Grid?

    Thanks
    Ganapathy

    • Hi Ganapathy,

      You cannot normally have two physical records on a grid. The only possibility is when the fields from the second one are display-only or related fields of the first.

      That said, you can use derived / work record fields apart from the fields in the primary record. You can then write code to save the contents of the derived / work record fields into a physical table at save time. The reverse logic can be employed to populate the content from the physical record into the derived / work record fields during RowInit / Activate.

      Hope I answered your question.

  4. Hi Rakesh,

    Can we have two check boxes in single grid column?

    • Hi Amy,

      Interested in knowing the reason for having two checkboxes in a column. Btw, can’t you keep two columns close together to achieve something close?

  5. Hi Rakesh,
    While using Grid is there a way to transpose columns to rows?

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

Read previous post:
PeopleSoft Journal Uploader
PeopleSoft Journal Import Error – User-defined type not defined

Close