{ DBTutor }

Tips for Those Who Want to Learn

Main menu

Skip to content
  • PeopleSoft FAQ
    • PeopleCode FAQ
    • App Engine FAQ
    • CI FAQ
    • SQR FAQ
    • BI Publisher FAQ
  • PeopleSoft Meta Data SQL
    • SQL Query Collection
  • PeopleSoft Difference Between
    • Difference Between Tutorials
  • Database Server
    • MySQL
      • Date and Time
  • Skill Test
    • PeopleSoft HRMS Functional
      • HR Foundation Quiz
      • HR Functional Quiz
      • HR Functional Quiz 2
    • PeopleSoft PeopleTools
      • PeopleTools Quiz
      • PeopleTools Quiz 2
      • PeopleTools Quiz 3
    • PeopleSoft Administration
    • PeopleSoft with Oracle Database
    • View Leaderboard
  • About DBTutor
    • About
    • Say Hello
    • Feedback
Learn PeopleSoft Meta-data Table Reference

Category: SQR

PeopleSoft Structured Query Report

SQR (Hyperion SQR Production Reporting, Part of OBIEE) is a programming language designed for generating reports from database management systems. The name is an acronym of Structured Query Reporter, which suggests its relationship to SQL (Structured Query Language). Any SQL statement can be embedded in an SQR program. We will discuss about PeopleSoft Version of SQR

generate-excel-report-from-peoplesoft-sqr

Generate Excel Report From PeopleSoft SQR

13

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 →

In SQR | By Nayan | Publish On December 3, 2014
working-with-date-calculation-and-manipulation-in-peoplesoft-sqr

Working with Date Calculation and Manipulation in PeopleSoft SQR

1

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 →

In SQR | By Nayan | Publish On November 4, 2013
read-file-using-sqr-and-insert-data-into-table-peoplesoft

Read File Using SQR and Insert data into Table PeopleSoft

5

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 →

In SQR | By Nayan | Publish On November 4, 2013
generate-multiple-report-with-unique-name-in-peoplesoft-sqr

Generate Multiple Report with Unique Name in PeopleSoft SQR

14

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 →

In SQR | By Nayan | Publish On October 4, 2013
how-to-get-process-name-by-process-instance-using-peoplesoft-sqr

How to Get Process Name by Process Instance Using PeopleSoft SQR

2

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 →

In SQR | By Nayan | Publish On October 1, 2013
Page 1 of 212»

Poll – Opinion Matters

Which PeopleTools Version You Are Using In Production ?

View Results

Loading ... Loading ...

Recent Comments

  • Nilavra Sarkar on PeopleSoft Component Interface Frequently Asked Question
  • Nayan on Create A Simple AWE PeopleSoft Part – 2
  • Nilavra Sarkar on Create A Simple AWE PeopleSoft Part – 2
  • TOUFIQUE KHAN on Create A Simple AWE PeopleSoft Part – 4
  • Nayan Paul on PeopleSoft Component Interface Frequently Asked Question

Monthly Archives

Tags Redefine

  • SQR   4
  • PeopleSoft SQR   2
  • MySQL Date & Time Functions   1
  • AppEngine   1
  • PeopleSoft SQL   1
  • SQR Error   1
  • PeopleSoft SQR Code   1
  • SQR Multiple Report   1
  • SQR Date   1
  • PeopleSoft SMTP   1
  • Peoplecode MCF   1
  • Excel SQR   1
  • PeopleSoft XML Publisher   1
  • XML Publisher Report   1
  • Simple Report Using XMLP   1
Copyright © 2012–2025 DBTutor.
ML Platform DBTutor PeopleSoft Skill DBTutor Hosted at Oracle Cloud Infrastructure (OCI)