Matching SDS fields to Report Fields

It is necessary to match all fields in the report layout to fields in your SDS database.  The only exception to this rule is the report field “Placeholder”.  If you see this in the report layout, it should remain unmatched.

http://help.schooloffice.com/helpconsole/SDSStudentHelp/images/sr_2.bmp
If a field is not matched, there are three options to complete the matching process. 

1. Match to an Existing Field in your Database.

1.  Click on the Export Design Options button.

2.  Select the appropriate table from the drop box in area #2: Select a table to store data.

3.  Select the appropriate data field from the dropdown box in area #3: Fields in selected Table.

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

4.  Click http://help.schooloffice.com/helpconsole/SDSStudentHelp/images/BlueArrowYellow.png next to the field in the report layout to complete the matching process.

5.  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”.

6.  NOTE:  If the report requires data that has not been entered on all students, you can use the “Default if Blank box next to the field.  For example, code “E” in the report indicates English is a student’s home language and all other languages each have their own code.  Since most students would be “E”, this can be entered in the “Default if Blank” column. 

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.  


3.  Match a field to a default value text box on the screen. 

Follow this link for instructions.