Page Comparison

...

1. Add the new report to the Report Selector screen by clicking on the

   Anchor
   O_6615 O_6615

   Image Modified button.
2. Enter the correct details for the Report Code (STFCL), Module (REP), View (blank), Description (Staff Contact List) and the Resource Type (Site).
3. Click Image Modified .
4. Highlight the new report in the Report Selector grid and click the

   Anchor
   O_26094 O_26094

   Image Modified button.
   No report definition screen exists for this report yet.
5. Add an Optional Selections group box to the form as the first control object to contain the remaining selection fields. Refer to the screen capture below for assistance.
   

...

1. Image Modified
   
   
2. Next insert the following staff database fields into the Optional Selections group box:
   • Surname
   • Preferred
   • ID
   • StaffCode
   • StaffCampus
   • StaffYearLevel.
3. Highlight the GroupBox entry in the User Form Designer grid.
4. Click Image Modified to create a new entry for Surname.
5. Enter the values for Control & Property Definition and Editable Objects and SQL Syntax as shown in the screen capture below.

...

1. 
   Image Modified
2. Click Image Modified .
3. Highlight the Surname entry in the User Form Designer grid and click Image Modified to create a new entry for Preferred.
4. Enter the values for Control & Property Definition and Editable Objects and SQL Syntax as shown in the screen capture below.

...

1. 
   Image Modified
2. Click Image Modified .
3. Highlight the Preferred entry in the User Form Designer grid and click Image Modified to create a new entry for Staff ID.
4. Enter the values for Control & Property Definition and Editable Objects and SQL Syntax as shown in the screen capture below.

...

1. 
   Image Modified
2. Click Image Modified .
3. Highlight the Staff ID entry in the User Form Designer grid and click Image Modified to create a new entry for Staff Code.
4. Enter the values for Control & Property Definition and Editable Objects and SQL Syntax as shown in the screen capture below.
   Note: We are using the luSQL field to write a SQL Server query to populate a wwDbLookupCombo.
   

...

1. Image Modified
   
2. Click Image Modified .
   The Additional Properties field has also been used to change the default properties of this control. 
3. Highlight the Staff Code entry in the User Form Designer grid and click AnchorO_26093O_26093click Image Modified to create a new entry for Staff Year Level.
4. Enter the values for Control & Property Definition and Editable Objects and SQL Syntax as shown in the screen capture below.
   Note: We are using the luSQL field to write a SQL Server query to select only three columns from the luYearLevel table to appear in the wwDbLookupCombo control.
   

...

1. Image Modified
   
2. Click Image Modified .Click
3. AnchorO_23841O_23841Click Image Modified to inspect the newly created report definition screen.