Report Layout and Field Match
Steps for Report Creation
1. Match fields in the report with fields in the database.
Revised: 11/21/18
This file format pertains to the data submitted to ISBE SIS Early Childhood.
If this is the first time you are running a state report,
review the general information provided in this document before proceeding with
the reporting process.
Report
Layout and Field Match
Steps for Report
Creation
1. Match fields in the report with fields in
the database.
•Click on the Export Design Options button.
•Select the appropriate table from the drop box in area #2: Select a table to store data.
•Select the appropriate data field from the dropdown box in area #3: Fields in selected Table.
•Click 
next to the field in the report layout
to complete the matching process.
•The field from SDS will be listed in the column “SDS field name” and the source table will be listed in the column “SDS table name”.
•In the column “Default if Blank”, optionally enter a value to be exported for any students who have no data in the selected field.
2. Create a new
field(s) in your database to enter required data and match those fields in the
report.
Follow this link for instructions:
http://help.schooloffice.com/StudentHelp/#!Documents/creatingnewfieldsforstatereporting.htm
3. Match a field to a default value text box on the screen.
Follow this link for instructions:
4. Create and Save the report for upload to State/Agency.
Follow these links for instructions:
http://help.schooloffice.com/StudentHelp/#!Documents/createthereport.htm
http://help.schooloffice.com/StudentHelp/#!Documents/savethereport.htm