V2 Menu Crystal Reports

A query is typically performed to filter and pass the record set to the selected Crystal Report template.

If there is a username and password within the Crystal Report template, these are replaced by the current CCLAS database username and password parameters.

  • Whether the complete record set is passed, or just those records that are checked are passed, to the Crystal Report template depends on the ReportCheckedOnly CCLAS_EXPLORER program setting for the specified Explorer group.

If a ScreenFile Program Settings - CCLAS_EXPLORER for the specified Explorer group is defined, and if the following procedures are available, then they are called at the appropriate time.

BeforeCrystalGenerate

Objects and properties exposed include:

  • Crystal Template name
  • clsCrystalReport (this is the class, not the viewer form)
  • The populated RecordSet (as oRS)
  • Form controls (that is, those from the UserForm).
DuringCrystalGenerate

Objects and properties exposed include:

  • Crystal Template name
  • clsCrystalReport (this is the class, not the viewer form)
  • The populated RecordSet (as oRS)
  • Form controls (that is, those from the UserForm).
AfterCrystalGenerate

Objects and properties exposed include:

  • Crystal Template name
  • clsCrystalReport (this is the class, not the viewer form)
  • The populated RecordSet (as oRS)
  • Form controls (that is, those from the UserForm)
  • CrystalReport as frmCrystalReportView.CrystalReport
  • CrystalReportViewer as frmCrystalReportView.CRViewer1
  • CrystalApplication as frmCrystalReportView.CrystalApp
  • Crystal Form as frmCrystalReportView.