Reporting Tips & Tricks

How to find Banner form and field names

When requesting a report be created or updated it is extremely helpful if the Banner form and field names are provided in the email to the helpdesk.

To find the Banner form and field names:

  1. Log into Banner
  2. Open a Banner Form (ex: SGASTDN)
  3. Enter a Student ID and click Tab
  4. Click Next Block
  5. Put your cursor in the Residence field
  6. Select Help from the top menu bar of SGASTDN
  7. Select Dynamic Help Query from the drop-down menu
  8. A pop-up will appear listing the Form, Block and Field information

Copy the information in the Field block and add this to your email.

An example of a request would be: Please add Residency from SGASTDN (SGBSTDN_RESD_CODE) to my report.

Running Deferred Reports

Have a report that takes forever to run?  Why not run it in deferred mode?

To Run Deferred:

  1. Right-click on the report you wish to run
  2. Select Run Deferred
  3. You will see the Parameters window appear.  Enter your report parameters
  4. After you click Run you will see a Deferred Report Notification window
  5. Close the Notification window as well as the Parameter window

To view your deferred report(s):

  1. Click the Tools link located on the top right-hand corner toolbar in the WebFOCUS Portal
  2. From the drop-down menu select Deferred Status
  3. You will see the Deferred Report Status window.  This list includes all deferred reports you have run or are running in the last 30 days

Important:

Deferred report output is available for 30 days. After 30 days the report will need to be run again. You can run multiple reports in deferred mode.