Reporting Subscribe to Reporting
PeopleSoft Query Tables – The Complete List with Explanations
As PeopleSoft is a metadata-driven application, all the building blocks including PeopleCode are stored within database tables. And PS Query is no exception to this. Knowing the tables underlying PS… Read more
PeopleSoft Query Security – The Ultimate Guide
Learn how to secure your PeopleSoft Queries using Query Access Group Trees, Query Profiles and Query Security Records (Row-level Security).
You Don’t Have to Write PeopleCode to Create an XML / BI Publisher Report using PS Query!
This post will help you create your first XML Publisher report using Query as a data source. If you are a business user or a functional consultant trying to learn this reporting tool, you have come to the right place.
Getting Ready to Generate XML / BI Publisher Reports
Looking to learn XML / BI Publisher? This is the first post in the XML / BI Publisher tutorial series and will help get the ground work done before you start using this powerful reporting tool.
Concatenating Rows in SQL Server
Have you ever felt the need to concatenate multiple rows against a particular field into a single row? We can do this sort of row concatenation right within SQL Server rather than bringing the output into Excel and then doing it. Here’s how!
Calling UNIX scripts from SQR
It often requires us to invoke OS commands from within an SQR. Today we will see how to use the call system command from within the SQR to invoke a UNIX script.
Arrays in SQR
An Array, like a database record, is organized as rows and columns. But unlike a database record, Arrays exists only in memory and NOT in the disk. This post discusses the arrays in SQR in detail
Load-Lookup in SQR
It’s common to join tables within SQRs to retrieve data from normalized tables. As SQL statements consume significant computing resources, such joins may be a hindrance to performance of the SQR. Further, as the number of tables that are used in the join increases, the performance decreases.
Multiple Reports in SQR
Generating multiple reports in SQR is common these days. Writing SQRs that produce multiple reports have many advantages over the other approach of having multiple SQRs do this job. This post discusses how to generate multiple reports in SQR.
Comments in SQR
It’s always a good practice to comment your code. By doing this, your code become more understandable and thus maintainable. This holds good for all programming languages and SQR is no exception.