Solution ID:
26
 
Summary:
Instructions on how to print your class roster in Banner.
 
Solution:
From the Main Menu, you may type in the Banner Report you wish to run directly in the DIRECT ACCESS box: SWRROST


This will take you directly to the GJAPCTL form to run your report:



  1. GJAPCTL Form: This form is used to print banner reports



    1. The name of the report you wish to print is already typed for you: SWRROST– for CLASS ROSTER).

    2. Perform a next block function .

    3. TYPE the word DATABASE to create a file, AND HIT ENTER KEY SO THAT THE WORD DATABASE IS IN ALL CAPS….(some offices may be able to select an appropriate printer instead) - then perform a Next Block function again.

    4. Select the appropriate values for the parameters of the report you are requesting, USING ALL CAPITAL LETTERS ….. or use the FLASHLIGHT BUTTON TO SEARCH FOR APPROPRIATE VALUES LINE BY LINE IF NECESSARY:


      1. TermCode (e.g. Spring 2002 = 200240 (ENTER 200240). Click to next field below.

      2. Subject Course Section e.g. = COM10001 (if you use this, skip 03 CRN)

      3. CRN - Course Registration Number = 12345 (if you do this skip 02)

      4. Faculty ID – If you like, you could skip 02 and 03 above and type the SSN instead to retrieve rosters of a given faculty member.

      5. Addresses – Type Y if you want addresses to appear, or leave blank.

      6. Print Balance Indicator – Type Y if you wish to see if a student has a payment balance. (usually we leave this blank)

      7. Address Preference – Type R during semester to get Residence Hall Addresses if applicable, or M for Mailing Address if you do not care for an on-campus address.

      8. Sort Order – (Usually leave this blank) BUT If you had only selected a dept in 02 e.g. COM, (subject course section, OR requested more than one roster, you could sort by faculty member or by CRN number.


    5. Perform a next block function.

    6. Click on SAVE PARAMETERS AT THE BOTTOM OF THE FORM, AND THEN CLICK THE YELLOW SAVE DISKETTE ICON, and the report will be processed.


    7. Select Review Output from the Options Column .

      PLEASE NOTE…. DUE TO THE NATURE OF WORKING ON A DATA NETWORK, THE REPORT/ROSTER NEEDS TIME TO RUN ACROSS THE NETWORK AND RETURN TO YOU. Unlike the VAX roster program, the roster file will not automatically appear when you first save the file.



    8. The Saved Output Review Form should then appear:


    9. Double-click in the Number field.

    10. The list of Available Files to review will appear on the screen.


    11. Select the .lis filename and click on the OK button.

    12. The report should then appear in the Saved Output window of the Saved Output Review Form:


    13. Select the Save to File option from the Options column.

      ("*Information* Output saved as file: C:\TEMP\SWRROST.lis" should then appear in the Auto Hint/Status line in the lower left corner of the screen.)


    14. Access Microsoft Excel or Microsoft Word programs, and use the File/Open menu command to open the SWRROST.lis file from the C:\TEMP folder.


  2. Exporting YOUR REPORT to Microsoft WORD:


    1. Having WORD open, click on File and select Open. If you are not in the correct directory, change the directory to My document, and select in the Files type box, All Files. Choose the report.lis that you want to export.

    2. After that the Text Wizard will pop up. Click OK which will be your default option.


    3. Then simply edit out the extraneous information.

    4. print and/or save file as needed.