PeopleSoft Pivot Grid error
Hi,
I got the following error message when creating pivot grid report using Pivot Grid Wizard:
"Generic error while executing the Query datasource. (268,91) PT_PGPACKAGE.PT_PGInformation.OnExecute Name:ExecuteChart PCPC:60715 Statement:1031
Called from:PTPG_WIZ_DISP.Activate Statement:352"
the PS query for this Pivot Grid report has information such as Student ID, Term, Application Date, etc that from 3 records (tables) by inner join.
I also tried to create another PS query which Only used One record (table), and then the Pivot Grid works, I am not sure the problem caused by multiple tables join in my PS query?
Appreciate very much for your help!