Main Help Menu      Return to Reports Menu      General Reporting Procedures      Quick  Instructions      Sample Report

 

SIS 2000+ Locker Listing Report Detailed Instructions Last update: 1/25/2001 jmm

This report provides a list of student lockers for the logged on school site. Included are the names of students assigned to each locker plus most of the locker attributes as defined in the Locker Editor application, such as locker ID#, locker type, combinations, maximum occupancy, etc. Options will allow the user to filter the listing in a variety of ways.

See Locker Editor for more information on how student lockers are defined. See Student Lockers for more information on how students are assigned to lockers.
 

1. Open the report
From the SIS 2000+ Main Menu, open the Enrollment program module. From the Enrollment Menu, click on the Reports icon button. Select the report's title from the list menu that appears. See General Reporting Procedures, Step 1 for more information on finding and opening a report.

Fig. 1 - opening screen, default Options
 

2. Define Parameters
The opening screen of this report (Fig. 1) contains three information screens: 'Options', 'Select', and 'Sort'. Click on each tab to view and define various parameters for the report, or continue to the Step 3 for viewing and/or printing the reports using the default parameters.

2.1 Choose Options
Click on the 'Options' tab (Fig. 2). Choose options as follows:

Fig. 2 - sample user-defined options
 
• Title -

The default title for this report is "Locker Listing". The title may be edited by the user.
• Lockers to include in the list -

A locker may have more than one student assigned to it. The list may be filtered based on the assignment status of lockers, i.e., how many students have been assigned to a locker vs. the maximum occupancy of the locker. The maximum occupancy of a locker is defined in the Locker Editor application. Students are assigned to lockers via the Student Lockers program.
• All -

Check this option to show all lockers in the school's database, whether fully assigned, partially assigned, or not assigned (Default selection).
• Fully Assigned -

Checking this option will show only those lockers that have been assigned to their maximum capacity.
• Fully/Partially Assigned -

This option will list lockers that are assigned to their maximum capacity and lockers that have at least one student assigned but are not yet assigned to maximum capacity.
• Partially/Not Assigned -

This option will list lockers that have at least one student assigned but are not yet assigned to maximum capacity and lockers that have no students assigned to them.
• Not Assigned -

This option will list only those lockers that have no students assigned to them.
 
• Show All Lock Combinations -

Check this option to display all locker combinations recorded for each locker listed. The active combination will be flagged by an asterisk (*).
• Show Assigned Students -

Check this option to list the names of the students assigned to each locker. When this option is "On" the following three sub-options will be enabled:
• Show Student Ethnicity -

Student's ethnicity code will be displayed
• Show Student Home Phone -
• Print One Locker Per Page -

Page break inserted between each locker entry.
 
 


Click on the Reset command button to restore all Options to their default selections (Fig. 1).
 

2.2 Apply Select queries
SIS 2000+ reports can be instructed to print specific sets of records through the application of  queries. A query is essentially a data filter. By defining criteria (parameters) for selected data fields, specific records or sets of records can be retrieved.

Click on the 'Select' tab. A list of data fields is displayed (Fig. 3). These are the data fields that will available for querying. The default criteria is "All" for each data field. To apply a select query to any data field, continue with Step 2.2.1. If no queries are needed, continue to the sorting procedure in Step 2.3.


Fig. 3
 

2.2.1 Select data fields and apply queries
Select a data field in the list until it is highlighted in gray (Fig. 3). Then click on the Edit command button. A criteria selection screen will open that is specifically designed for the selected data field. The sample in Fig. 4 shows the criteria selection screen for the Out of Service data field with the "Yes" logical value selected. The Out of Service data field is a Yes/No logical field from the locker attributes in the Locker Editor database. By selecting the "Yes" value, the report will retrieve only those lockers that are out of service.


Fig. 4 - sample criteria selection screen, Query Type 1

There are several possible types of queries, depending on the data field selected. Instructions on how to select and apply each type of query are found in the document titled General Reporting Procedures.
 

• Location = Query Type 3. All lockers must be assigned a "location" in the Locker Editor database. A specific location or set of locations may be selected. If none are selected, then "All" will be reported.
• Locker Type = Query Type 1. A locker type is assigned to each locker defined in the Locker Editor database, such as 'book locker', 'band locker', etc. A specific locker type or set of locker types may be selected. If none are selected, then "All" will be reported.
• Locker Level = Query Type 1. Select a numeric value representing a user-defined locker level in the Locker Editor database. A specific locker level or set of locker levels may be selected for reporting. If none are selected, then "All" will be reported.
• Max Occupants = Query Type 1. Select a numerical value representing the maximum number of students that can share a locker. A specific occupancy value or set of occupancy values may be selected for reporting. If none are selected, then "All" will be reported.
• Out of Service = Query Type 1. If a locker has been flagged as 'out of service' in the Locker Editor database it will have the attribute of True (Yes) or "1" in the Out of Service field. Otherwise that field will contain the default value of False (No) or "0", which signifies that the locker is in service. Select a service status or True or False to report (Fig. 4). If neither is selected, then both statuses will be reported.
 

Define criteria for the above queries and apply the query by clicking on the Done command button within each query screen.
 

Note on Query results:  Use caution when making multiple queries across data fields. Only records that satisfy all queries will be reported. Some queries may be mutually exclusive causing the report to yield no records. In this type of situation there will be no pages to preview or print for the body of the report. This status will be indicated by the following error message appearing at the bottom of the cover sheet:  ***** NO RECORDS SELECTED FOR REPORT *****

 

2.2.2 Review selected parameters
After parameters are set and queries applied as needed, the view will return to the 'Select' screen. Each data field in the list will display a code after its name signifying the parameters currently applied. In the example below (Fig. 5), the queries applied will retrieve only Out of Service lockers of Type B that have a maximum occupancy of 2. Review the parameters. If all are satisfactory, continue to the sorting procedure in Step 2.3. If editing is required, repeat Step 2.2.1.


Fig. 5 - sample review



To restore a field's parameters to its default selection, highlight the field name in the 'Select' screen and click on the Reset command button.
 

2.3 Define the Sort order
Click on the 'Sort' tab. The 'Sort' screen (Fig. 6) displays the data fields used for sorting the locker records. The default sorting order is:
 
Type (locker type) = primary sort field
Locker ID = secondary sort field


Fig. 6 - default sorting order

Sort Commands:
 

• Additional sorting fields may be added via the Add command button. Added fields will be placed at the end of the list by default.
• A sorting field may be deleted by first selecting it in the list and then clicking on the Delete command button.
• The default sorting order may be changed by clicking on a field to activate mover bar and then dragging and dropping the field to another position in the list. All other fields will be moved down one position accordingly.
• The default sorting direction of all fields is Ascending. The direction of a sort field may be edited by selecting the sort field from the list, executing the Edit command, and selecting the desired sorting direction (Ascending or Descending) from the 'Edit Sort Field' dialog (Fig. 7). Click on Done to save the sort direction, or Cancel to abort.


Fig. 7 - the sorting direction of the Location field has been changed to Descending
 

In the example below (Fig. 8) the Lock ID and the Location fields were added to the end of the list. Then the Lock ID field was moved to the position of primary sort field by dragging it to the top of the list with the mover bar. All other fields were subsequently moved down one position. The sorting direction of the Location field was then changed from its default Ascending to Descending.


Fig. 8 - sample customized sort order

For further instructions on defining the sort order of a report see General Reporting Procedures, Steps 2.3-2.3.4

2.4 Resetting global defaults



Global default parameters for all the screens can be reset by clicking on the Reset All command button at the bottom of the main screen.
 
 

The customized or default report can be previewed at any time before actual printing by clicking on the Preview command button. An option to print the report is available when the Preview is exited. For further instructions on previewing reports, see General Reporting Procedures, Step 3
 

4. Print the report to printer or to a file

Click on the Print command button to print the report to a printer or to a file without previewing it. For further instructions on printing reports, see General Reporting Procedures, Step 4
 

5. Exit report

Click on the Quit command button to exit the report screen at any time.

Main Help Menu      Return to Reports Menu      General Reporting Procedures      Quick  Instructions      Sample Report