Page Comparison

After you create a new report or modify an existing report and save it with a new name, you may need to build a new report definition screen.

For this exercise, a staff contact list report has been created (STFCL) and saved in the site folder. This Crystal Report is based on a number of base tables and so the named report definition screen vStaff (which would have been ideal had the report been built from the view vStaff) cannot be used. The following shows how to build a new report definition screen from scratch.

1. Add the new report to the Report Selector screen by clicking on the AnchorO_6615O_6615 Image Removed the 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 AnchorO_26094O_26094 Image Removed the 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.
   

...

1. Image Added
   
   
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 Removed Image Added 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. Click Image Removed Image Added
2. Click Image Added.
3. Highlight the Surname entry in the User Form Designer grid and click Image Removed Image Added 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. Click Image Removed Image Added
2. Click Image Added.
3. Highlight the Preferred entry in the User Form Designer grid and click Image Removed Image Added 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 Added
2. Click Image Removed Image Added.
3. 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.
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 Added
   
   
2. Click Image Removed Image Added.
   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_26093 Image Removed click Image Added 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

...

1. Click Image Removed .
2. Click AnchorO_23841O_23841 Image Removed field to write a SQL Server query to select only three columns from the luYearLevel table to appear in the wwDbLookupCombo control.
   

...

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

...