Page Comparison

...

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

   Anchor
   O_6615 O_6615

   Image Removed Image Added 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 Removed Image Added.
4. Highlight the new report in the Report Selector grid and click the

   Anchor
   O_26094 O_26094

   Image Removed Image Added 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.
   Image RemovedImage Added
   
   
6. Next insert the following staff database fields into the Optional Selections group box:
   • Surname
   • Preferred
   • ID
   • StaffCode
   • StaffCampus
   • StaffYearLevel.
7. Highlight the GroupBox entry in the User Form Designer grid.
8. Click Image Removed Image Added to create a new entry for Surname.
9. Enter the values for Control & Property Definition and Editable Objects and SQL Syntax as shown in the screen capture below.
   Image RemovedImage Added
10. Click Image Removed Image Added.
11. Highlight the Surname entry in the User Form Designer grid and click Image Removed Image Added to create a new entry for Preferred.
12. Enter the values for Control & Property Definition and Editable Objects and SQL Syntax as shown in the screen capture below.
    Image RemovedImage Added
13. Click Image Removed Image Added.
14. Highlight the Preferred entry in the User Form Designer grid and click Image Removed Image Added to create a new entry for Staff ID.
15. Enter the values for Control & Property Definition and Editable Objects and SQL Syntax as shown in the screen capture below.
    Image RemovedImage Added
16. Click Image Removed Image Added.
17. Highlight the Staff ID entry in the User Form Designer grid and click Image Removed Image Added to create a new entry for Staff Code.
18. 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.
    Image RemovedImage Added
    
19. Click Image Removed Image Added.
    The Additional Properties field has also been used to change the default properties of this control. 
20. Highlight the Staff Code entry in the User Form Designer grid and click Image Removed Image Added to create a new entry for Staff Year Level.
21. 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.
    Image RemovedImage Added
    
22. Click Image Removed Image Added.
23. Click Image Removed Image Added to inspect the newly created report definition screen.

...