Page Comparison

...

1. Select Module > System > User Report Form Editor from the Synergetic main menu.
   The Synergetic User Report Form Editor window is displayed. See Using the User_Report Form Editor in the Synergetic System maintenance manual.
2. Create the report you want to display using the Synergetic User Report Form Editor. See Report Form Designer in the Synergetic System maintenance manual.
3. Ensure that the Web Enabled field is selected for the report.
   
4. Click .
5. Select Module > System> Configuration File Maintenance from the Synergetic main menu.
   The Synergetic Configuration File Maintenance window is displayed. See Configuration File Maintenance window in the Synergetic System maintenance manual. 
6. Find the Student:Attendances:HotReports configuration settings.
   
   
   Tip: Type Student|Attendances|HotReports into the search field to find the settings quickly.
    
7. Add the appropriate configuration setting:
   • to create a hot report for the class, see HotReports:Classes configuration setting
   • to create a hot report for each student in the class, see HotReports:Students configuration setting.
   
   Note: Ensure the Key 5 value is unique for each Class or Student hot report configuration setting.
    
8. Type the report code and description, separated by a pipe character ( | ) in the Value field.
   
   Note: You need to modify the RecordSelectionFormula to match the view or other SQL object referenced by the selected report.
    
9. Click .
   The hot report is ready to use. 

Configuring the Crystal Report

When configuring the Hot Report Config Key, just enter the report code and description and the parameters are not required as the application passes these through automatically.

The Crystal Report needs to be based on a stored procedure that takes the following parameters in order:

@FileYear INT,
@FileSemester INT,
@ClassCode VARCHAR(15),
@ID INT,
@ClassCampus VARCHAR(3) = '',
@StaffID int

A sample call for a hot will look as follows:

exec {yourstoredprocname}  {fileyear}, {filesemester}, {classcode}, {studentid}, {classcampus}, {staffid}

--SAMPLE CALL FOR CLASS
exec ucrspStudentProfile 2019, 1, 'PE08A', 0, '', 45647

--SAMPLE CALL FOR STUDENT
exec ucrspStudentProfile 2019, 1, 'PE08A', 12345, '', 45647