Configuring the Status Application

Forms	See also
STATREP—StatRep Form

Overview

After the analytical process is completed, analytical reports, or certificates, are generated for jobs and sent to the client.

This process is pertinent to LIMS and laboratory managers who configure the LIMS, job report templates and reporting sessions in particular.

Process

Configuring Access to the Status Application

Ensure the StatRep.exe file is located in the folder defined by the ExeDirectory Program Settings—GLOBALSETTINGS for CCLASMGR. Give users, or users with specific roles, access to the application by setting the AccessLevel Program Settings - STATREP.. Once a user has sufficient access rights, they can run the Status application either from the Status Reports node on the CCLAS menu or directly from the CCLAS Exe folder.

To display tips to users upon start up of the Status application, enable the ShowTipOfTheDay Program Settings - STATREP, and enter the tips, with one tip per line, in a file, place the file in a folder under the CCLAS root folder defined by the CCLASRootDirectory Program Settings—GLOBALSETTINGS for CCLASMGR, then set the TipofTheDayFile Program Settings - STATREP to the folder and file name, for example %CCLASRootDirectory%TIPS\STATREP.TIP.

To maintain the window size and position between closing and launching the Status application, set the Window Program Settings - STATREP.

Configuring Job Status Search

To present the list-view panel with grid lines, enable the MainListViewGrid Program Settings - STATREP.

To filter jobs for a status report based on field criteria:

• Set the Criterian Program Settings - STATREP to specify the column filtering properties using the PROFJOB table, and set the CurrentCriteria Program Settings - STATREP to hold the current criteria.
• To enable the Properties main menu option to allow users to update the criteria, enable the AllowProperties Program Settings - STATREP.

To filter by client, set the ClientReportLookupColumns Program Settings - STATREP to the columns of CLIENT details on display in the grid when report clients are filtered on the General tab using the F2 function key and a client grid displays, and set the ClientReportLookupField Program Settings - STATREP to the field from the CLIENT table that is returned from the lookup function.

Set the MainListViewColumnn Program Settings - STATREP to specify which columns from the PROFJOB table are presented in the Jobs grid.

Configuring Job Status Reporting

Place all job status report templates in the folder defined by the TemplateDirectoryProgram Settings - STATREP.

The DefaultTemplate Program Settings - STATREP defines the default template for job status reports.

The DefaultViewMode Program Settings - STATREP defines the default view mode of report generation. View none means that the job status report is not presented to the user at all, View creating shows the generation as it occurs and presents the report to the user at the end of generation, and View at end shows no generation details and only presents the job status report to the user at the end of generation.

The SummaryBand1BackgroundColour Program Settings - STATREP defines the background colour of the client group in a job summary report spreadsheet generated in Microsoft™ Excel.

The SummaryBand2BackgroundColour Program Settings - STATREP defines the background colour of the client project group in a job summary report spreadsheet generated in Microsoft™ Excel.

The SummaryBand3BackgroundColour Program Settings - STATREP defines the background colour of the job group in a job summary report spreadsheet generated in Microsoft™ Excel.

Enable the SummaryExpandAll Program Settings - STATREP so that job summary report spreadsheets generated in Microsoft™ Excel contain a detailed summary.

The SummaryFixedColumns Program Settings - STATREP defines the number of fixed columns contained in a job summary report spreadsheet generated in Microsoft™ Excel.

Job status report details can be saved to a script for later use. Refer to Configuring Reports.

Customising Job Status Reporting

Where the StatUDF.VBS VBScript file is located in the folder defined by the ConfigDirectory Program Settings—GLOBALSETTINGS for CCLASMGR and:

• The PRepUDF1 subroutine exists within the script file, before the job status report is created in Microsoft Excel™, then it is run to perform custom logic.

• The RepUDF2 subroutine exists within the script file, after the job status report is created in Microsoft Excel™, then it is run to perform custom logic.

• The BeforeCrystalGenerate subroutine exists within the script file, before the job status report is generated using Crystal Reports™, then it is run to perform custom logic.

• The DuringCrystalGenerate subroutine exists within the script file, after the clsCrystalReport object is generated but before the Crystal Report™ is actually generated, then it is run to perform custom logic.

• The AfterCrystalGenerate subroutine exists within the script file, after the job status report is created using Crystal Reports™, then it is run to perform custom logic.
  

Related Topic

Generating Job Reports