Configuring attendance hot reports

Attendance hot reports are available in both SynWeb and Synergetic. You can configure them to be available from a single class or for each student in the class.
Attendance hot reports are configured through Synergetic using:

  • User Report Form Editor
  • Configuration File Maintenance.

Configuring an attendance hot report
To configure an attendance hot report:

  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.

    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.

    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),
@ClassCampus VARCHAR(3) = '',
@StaffID int

A sample call for a hot will look as follows:

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

exec ucrspStudentProfile 2019, 1, 'PE08A', 0, '', 45647

exec ucrspStudentProfile 2019, 1, 'PE08A', 12345, '', 45647