Note that the Report Generator datapoints are dependent on specific data sets. For example, Catalogue Name will generate catalogue names based on the Vendor SDS Product names for the selected materials in your inventory.
The table below illustrates a worked example for a few selected data-points using the Advanced Tab, where report templates were created to generate the respective data.
| Report Template Name Created | Datapoints Selected | Explanation of Generate Data | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Material Name and Chemwatch Number | Material Name Chemwatch Number | The report generated will display data columns based on Material Name and Chemwatch Number. Note that the data is not duplicated, sourced as per the name of the Chemwatch Material Name based on Chemwatch Number. Example - Six materials have been used to generate the report.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Material Name, Catalogue Name and Chemwatch Number | Material Name Catalogue Name Chemwatch Number | The report generated will display data columns based on Material Name, Catalogue Name and Chemwatch Number. Note that the data is duplicated, sourced as per the name of the Chemwatch Material Name based on Chemwatch Number and Catalogue Name is another set of data that implies the duplication of the Material, which is generated based on mapping both Material Name and Catalogue Name. Note that the Catalogue Name is referenced to the Vendor SDS for that specific Material + Chemwatch Number. Example - Six materials have been used to generate the report, but contains duplicated records due to the number of Vendor SDSs based on the Catalogue Names of the materials. For instance, "Acetone" has seven Vendor SDSs associated with the Chemwatch Material Name.
The report below is generated with another column (datapoint) called Vendor to show the various duplicated Catalogue Names and their associated Vendor for the same material "Acetone" as per the record in the selected folder location in the system. Materials Table (Folder inventory)
Report Generator Selected datapoint fields in the Method Builder Panel
Example - Six materials have been used to generate the report, but contains duplicated records due to the number of Vendor SDSs based on the Catalogue Names of the materials. For instance, "Acetone" has seven Vendor SDSs associated with the Chemwatch Material Name and the Catalogue Names are duplicated (for pure substances) and the Vendor column shows the specific manufacturer.
|
