Form Designer - Asphalt Lot Report Configurations

Owned by Karl Burkum
Last updated: Nov 04, 2022
Tips

Form Design

Sample Form Settings

Sample forms used for asphalt lot reporting need to have a few settings applied to them. Application of the Asphalt Lots form setting will automatically add the core fields to the sample form design that are necessary for the asphalt lot reporting to work.

Form SettingNotes
Sample Material
  • Designates the form as being used for asphalt material
Asphalt Lots
  • Designates the form as being used to ultimately generate an asphalt lot report - the parent sample to all tests performed on the lot
  • Automatically adds the required Lot Number (AsphaltLotNumber) field
  • Automatically adds the required Supplier (AsphaltSupplier) field
  • Automatically adds the required Plant (AsphaltPlant) field
  • Automatically adds the required Mix Design (AsphaltMixDesign) field
  • All fields added as a result of this setting are added (and required in the design) at the root of the sample form

Duplicate Lot Number values can only be assigned to sample that share the same supplier / mix design within a given project. The system will validate this when completing the form.

Field Mappings - Sample Report Section

Fields reported in the Sample section of the Asphalt Lot report need to be mapped to the form fields.  This is accomplished by applying the Asphalt Lot Report setting to a field on the sample form and selecting (mapping) the form field to the report field applicable to the Sample section of this report.

Test Form Settings - Sieve Report Section

Test forms used for asphalt lot reporting need to be identified and need to have a few settings applied to them. These settings and field mappings are outlined below.

Form SettingNotes

Test Material

  • Designates the material the test form is for
  • Standard on all tests - not unique to lot analysis
Material Specification
  • Designates the the type of material specification used on this report - sieve material specification should be used
Asphalt Lot Test - Sieves
  • Designates that this form can be used as a source of data for the Sieve section of the lot analysis report

Field Mappings - Sieve Report Section

Field mappings are not generally required for the Sieve section of the Asphalt Lot report. Because the target fields are predicable and sourced from the material specification selected on the form form record, the system is able to source the appropriate data dynamically from the form design and material specifications assigned to that form. Any comments you wish to display on the report must be mapped to the Sieve Test Remarks field mapping.

Sourced DataNotes
Sieve Size Columns
  • Dynamic based on the sieve sizes associated with the material specification selected on the form record
  • Sieve sizes reported in metric screen size value (mm)
Percent Passing
  • Dynamic based on the material specification value for the selected material specification on the form record

Test Form Settings - Mix Analysis Report Section

Test forms used for asphalt lot reporting need to be identified and need to have a few settings applied to them. These settings and field mappings are outlined below.

Form SettingNotes
Test Material
  • Designates the material the test form is for
  • Standard on all tests - not unique to lot analysis
Material Specification
  • Designates the the type of material specification used on this report - sieve material specification should be used
Asphalt Lot Test - Mix Analysis
  • Designates that this form can be used as a source of data for the Mix Analysis section of the lot analysis report

Field Mappings - Mix Analysis Report Section

Fields reported in the Mix Analysis section of the Asphalt Lot report need to be mapped to the form fields.  This is accomplished by applying the Asphalt Lot Report setting to a field on the sample form and selecting (mapping) the form field to the report field applicable to the Mix Analysis section of this report. Any comments you wish to display on the report must be mapped to the Mix Analysis Remarks field mapping.

Test Form Settings - Gyrations Report Section

Test forms used for asphalt lot reporting need to be identified and need to have a few settings applied to them. These settings and field mappings are outlined below.

Form SettingNotes
Test Material
  • Designates the material the test form is for
  • Standard on all tests - not unique to lot analysis
Material Specification
  • Designates the the type of material specification used on this report - sieve material specification should be used
Asphalt Lot Test - Gyrations
  • Designates that this form can be used as a source of data for the Gyrations section of the lot analysis report

Field Mappings - Gyrations Report Section

Field mappings are not required for the Gyrations section of the Asphalt Lot report. Because the target fields are predicable and sourced from the material specification selected on the form form record, the system is able to source the appropriate data dynamically from the form design and material specifications assigned to that form. Any comments you wish to display on the report must be mapped to the Gyration Remarks field mapping.

Sourced DataNotes
Gyration Count Columns
  • Dynamic based on the material specification values associated with the material specification selected on the form record
Voids At "X" Gyrations
  • Material specification value for each tested gyration count (voids at "x" gyrations)

Lot Aggregations - Sources of Data

Data appearing under the grids containing data for the multiple tests belonging to a lot is sourced from a variety of areas.

DataNotesExample
Average
  • Simple average of the data above

Formulation
  • Mix design formulation metadata

Measured Deviation
  • Delta between Average and Formulation

Allowable Deviation
  • Allowable deviation threshold defined at the project level (Project Specifications)

Critical Deviation
  • Critical deviation threshold defined at the project level (Project Specifications)

Minimum Requirement
  • Minimum specification value defined in Material Specifications

Maximum Requirement
  • Maximum specification value defined in Material Specifications

Report Design

The Asphalt Lot Sample Report is the report that aggregates the defined sample and test fields together on a single report for a given asphalt lot number within a given project. This report is a hard coded report that is not based on a custom report design within Report Designer.  Administrators can control the report settings of the report, but they can't control the look of the overall report design.

Report Execution

Execution of the Asphalt Lot Sample report is done within Quality Control - Sampling.

  • Select a sample (in the Sample grid) that belongs to the asphalt lot you wish to report on
  • Select the Preview Report / Create Draft Report / Finalize Report button to generate the report
  • The system will find all samples belonging to the same lot number (for that project) in addition to finding all of the related test records for that project that provide data for the various sections (general, sieve, mix analysis, gyrations) of the lot report
  • Finalized reports will be sent to Delivery like other finalized reports