Text Only      Search  Home  Login  
Back to PS Financials Main      
How To Menu      
PS Financials Navigation      

Dig for more information using Queries...

  
    Run a Public Query     
    List of Public Queries     
    Share a Query     

How to run a Public Query

NAVIGATION:         Reporting Tools – Query – Query Viewer

 


 

1.      Search for the query by Name or Description.

2.      Enter all or part of the query name or Description.  **You may also change the search operator (e.g. to “Contains”).  For example:  UHS_AP

3.      Click Search.

The Search Results are displayed:


4.      Click either Run to HTML or Run to Excel.

 

The query prompts will display.  You can complete the fields with very specific data or very broad data, use wildcards, or leave them blank to view results.

 


5.      Enter the search criteria:

Business Unit:  00759

Department:  C0064

Entered From:  09/01/2006

Entered To:  09/30/2006

 

6.      Click View Results.  Some public queries may not have this button or may have OK, etc.  Generally, hit enter to view your results either in an HTML or Excel window depending on which RUN you used.

/portal/page/portal/BDG/PS_FIN/How To Main/Run Queries Accessibility Best Viewed Clery Act Compact with Texans Emergency Information Maps & Directions Privacy UH System oragrid7.uhcl.edu
Copyright 2008 University of Houston-Clear Lake 2700 Bay Area Blvd., Houston, TX, 77058 (281) 283-7600Contact: webmaster@uhcl.edu