1 / 56

Mastering PS Query for Efficient Reporting

Learn how to navigate, create, save, and run queries in PS Query for effective reporting. Discover criteria, sorting, field order, joins, security, and more to streamline your data retrieval process.

tamas
Download Presentation

Mastering PS Query for Efficient Reporting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Using PS Query in the Reporting InstancesApril 25, 2014

  2. Presenter Judith Ullman, CIS Application and Technical Support Manager judith.ullman@cuny.edu 212-541-1028

  3. Agenda • Navigation to Query Manager • Query Manager • Create New Query • Find Enrollment Record • Add Record • Add Fields • Save • Add Criteria • Run • Sort • Field Order • Join Class Info • Add Class Fields • Join Name Info • Add Name Fields • Effective Date Criteria • Security Joins • Add Query to Favorites • Questions

  4. Navigation

  5. Navigation

  6. Navigation

  7. Query Manager

  8. Create New Query

  9. Create New Query: Find Record

  10. Create New Query: Add Record

  11. Create New Query: Add Fields

  12. Create New Query: Save

  13. Create New Query: Save

  14. Create New Query: Criteria

  15. Create New Query: Criteria

  16. Create New Query: Criteria

  17. Create New Query: Criteria

  18. Create New Query: Criteria

  19. Create New Query: Run

  20. Create New Query: Run

  21. Create New Query: Sort

  22. Create New Query: Sort

  23. Create New Query: Sort

  24. Create New Query: Sort

  25. Create New Query: Field Order

  26. Create New Query: Field Order

  27. Create New Query: Field Order

  28. Create New Query: Field Order

  29. Create New Query: Field Order

  30. Create New Query: Field Order

  31. Create New Query: Join Class Info

  32. Create New Query: Join Class Info

  33. Create New Query: Join Class Info

  34. Create New Query: Join Class Info

  35. Create New Query: Join Class Info

  36. Create New Query: Join Class Info

  37. Create New Query: Join Class Info

  38. Create New Query: Join Class Info

  39. Create New Query: Add Class Fields

  40. Create New Query: Add Class Fields

  41. Create New Query: Join Name Info

  42. Create New Query: Join Name Info

  43. Create New Query: Join Name Info

  44. Create New Query: Join Name Info

  45. Create New Query: Join Name Info

  46. Create New Query: Add Name Fields

  47. Create New Query: Add Name Fields

  48. Create New Query: Effective Date

  49. Create New Query: Effective Date

  50. Create New Query: Security Joins

More Related