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
12 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?

  6. Hi, Can you please give me your mail ID? I have few queries regarding the issue. I did everything you mentioned. But I am still getting the error. Can you help.??

  7. Hi Rakesh how we can enable Excel sheet in grid properties to download grid data into excel in Peoplesoft?

    • @Ram – This should be enabled by default.

      If you do not see the “download to excel” icon on the Grid header, within App Designer check the header navigation bar properties within the Grid properties to see if this has been made invisible.

      Header Navigation Bar Properties

  8. Hi rakesh
    i have a problem in viewing multiple rows of data in grid
    in database it has multiple rows of data but in frontend its showing only one row in the grid
    what should i do for that

Leave a Reply

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

*
*