Skip to the main content
×

Network Maintenance will occur from April 25 at 10:30 PM through April 26 at 8:00 PM. During this time, users may experience intermittent interruptions to internet, phones, printing and access to other college services. Services will be restored once work is complete.

SQL Reporting Tool Instructions

Login User Name/Password

  • When you click on a report link, a login pop-up box will appear (see FIG 1.0)
  • Enter your full email address (i.e. joej@pbsc.edu) in the User name field
  • Enter your email/network/PantherNet password in the Password field
  • Click Ok button to log in and open/view the report.

FIG 1.0 Login Pop-up box

sql report - login information

 

Report Parameters

  • Some SQL reports may allow users to select parameter value(s) from a drop down list or by entering parameter value(s) to filter/refine the report data (see FIG 2.0 and 3.0)
  • Some Report outputs can be filtered by using wildcard characters - which, in this tool, is the Percent character %. For an example, if a free form range allows input (rather than a drop down list) and you wanted all student activity accounts (which we know start with Org Numbers 251), you could enter for State Org 251% and then a Qual1 of % and Location of %. This would provide an output for all student activity accounts for the college as a whole. If you wanted Lake Worth related then substitute 10 for the Location and only Lake Worth will output - with the same parameters restricted to location 10 (see FIG 3.0)

FIG 2.0 Select Parameter value from Drop Down List

sql parameters - drop down list

 

FIG 3.0 Enter Parameter value

sql wildcard parameters

 

Expand/Collapse Report

  • Some reports are summarized (or collapsed) and can be ‘expanded' to detail or rolled back up - look for "+" signs or "-" signs, or Expand All ? Yes or No (See FIG 4.0).

FIG 4.0 Expand/Collapse Report

sql reports - expand/collapse

 

Find Text in a Report

  • Find feature can help you locate a search term (word, number, partial phrase, etc.) - especially helpful if an item you're looking for is on a different page of output than you are viewing (see FIG 5.0).

FIG 5.0 Find/Search Term

sql reports - find

 

Export Reports

  • After a report is viewed, you can export it to different formats provided - Excel, PDF, Word, etc. Select the format type from the Export drop down menu (see FIG 6.0).

FIG 6.0 Export a Report

sql reports - export

Print page