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 App Designer
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 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
PeopleSoft Grid Properties Main Record
Very useful. Thanks.
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!
Glad that it was helpful.
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.
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?
Hi Rakesh,
While using Grid is there a way to transpose columns to rows?
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.??
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.
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