This blog post i will share & discuss about, how to create excel report using SQR. For generating excel files i have created a sample query to fetch from job data like employee id , name , business unit , … Continue Reading
As Other Programming languages PeopleSoft SQR also contains date related functions, for example strtodate() – convert a string to date datetostr() – convert a date to a string dateadd() – add to a date datediff() – subtract dates datenow() – … Continue Reading
I was working on SQR code that will read CSV file with SQR Code and Insert data into Staging Table.This blog post will help you to understand How to do Read file with SQR.I hope you are aware of SQR … Continue Reading
From last couple of days i was working on SQR Master Details report and also contains requirements to create a more than one report simultaneously based on the common data.After searching on Peoplebook as well Hyperion SQR Manual i found … Continue Reading
When i was working on reportlog.sqc Projects then i have found really interesting tips that is Getting Process Name by process instance. So lets tell the procedure.We all know the all process related information PeopleSoft Stored on PSPRCSRQST table. You … Continue Reading