Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. beckyzoole

    PS Query Work-Arounds

    Thanks for the comment, wing2x. You are absolutely right here: if there is no match on the right table, your query might output NULL in the count columns instead of zero. That is why I made my count columns SUM instead of COUNT. When I used COUNT, I did get a NULL. But I have run it now against...
  2. beckyzoole

    PS Query Work-Arounds

    I am working as a contractor who specializes in Crystal Reports, and was intrigued at my current assignment to find that I would have to work with PeopleSoft Query 8.44, which I had never used before. My excitement at learning how to use this tool turned to dismay when I discovered its...
  3. beckyzoole

    Pivot or Crosstab in PS Query?

    Please help me!! Can I create a pivot or crosstab table in Peoplesoft, whether using PS Query or in Application Mgr? I need to obtain a count of applicants by various applicant status-codes per Job Requisition. The final report will look like this: JOB APPLIED REVIEWED SCREENED...

Part and Inventory Search

Back
Top