Create the Report

 

     Complete the Basic Report Information

Click the Basic Report Information button to open the basic information area.

Complete all the boxes with the appropriate information.

Click http://help.schooloffice.com/helpconsole/SDSStudentHelp/images/SaveIcon.png to save any changes made to the basic report information.  This information listed under "Basic Reporting Information Available for this and Other Reports" will be saved and displayed with all other reports that are created.  Note: Entries to the Other Values 1-6 boxes will be saved with each report and selected school location.  This allows you to enter different data in these boxes for each report.   

http://help.schooloffice.com/helpconsole/SDSStudentHelp/images/SR_1231_basic.bmp

     Click the "Save Report Changes" icon. 

This will save everything on the screen, including Other Values and SDS fields matched to report fields, with this report.  If you have a school location selected, the screen entries and field matches will save for the selected report and the selected school location.  Each time a saved report is loaded for the location selected, the Other Values and Field Matches will be loaded.  These can be changed at any time and re-saved. 

http://help.schooloffice.com/helpconsole/SDSStudentHelp/images/SR_save_rpt.bmp

     Select the records you wish to include in your report.

Click the Data Selections Option (A to Z) button at the top of the screen to open the selection screen.

For example, you might need to set up a selection for current year seniors.

§ Choose the Demographics table.

§ Choose the Grade_Year field.

§ Highlight the correct year (i.e. 12).

§ Click the right pointing arrow button to move the value to box #4.

                        http://help.schooloffice.com/helpconsole/SDSStudentHelp/images/sr_5.bmp

§ Choose a Record Selection Option.  For example, “is in list”, means the value must be present in the record for that field to be included.

§ http://help.schooloffice.com/helpconsole/SDSStudentHelp/images/SR_6.bmp

§ Click the button “Add to Sort Definition” to add the selection to the list. 

Set up additional selections as desired.

To include only current students, click the blue link “Adjust Selection to Include Only Active Students”

Click the A to Z button at the top to close the selection screen.

Click http://help.schooloffice.com/helpconsole/SDSStudentHelp/images/SaveIcon.png under “Save Report Changes” to save the selection and display it in the box at the top of the screen.  This selection will be saved for future runs of this report.  You can uncheck “Export Using This Data Selection?” to run the report with no data restriction.       

             http://help.schooloffice.com/helpconsole/SDSStudentHelp/images/SR_7_1.bmp

     Create your export file.

Click the Create Export File button at the top of the screen.

Read the message.  You may have to rename your file and this message will advise you as to the naming requirement. Write down the file name for later use.

                    http://help.schooloffice.com/helpconsole/SDSStudentHelp/images/sr_9.bmp

Click OK on the message and save the file to your desired folder.