Comply Plus includes the standard SDS reports listed below, which show various aspects of your SDS database. This report list includes the following for each report:
● Title and format (Crystal, Quick View, or Telerik; see Reports for details on these report formats);
● A description of the report's purpose and output;
● The available criteria you can use to focus the report output on specific data (like entering search criteria to focus a search on specific data);
● Any available options that alter the appearance, format, or effect of the report output.
For details on running any of these reports, see the following:
● Running a Report: Manually run the report on the whole SDS database. Available for all reports listed below.
● Running Reports on a Collection: Manually run the report, focusing it on a specific SDS collection. Available for most (not all) reports listed below.
● Scheduled Reports: Set the report to run automatically on a regular schedule. Available for most (not all) reports listed below.
This report lists CAS numbers and their “product counts.” A product count is how many times a CAS number is indexed as an SDS ingredient. In the report output, a CAS number lists two separate product counts if it is indexed in both active and archived SDSs.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites in product counts.
● CAS Number: Include this CAS number only.
● Active: Include only active and/or archived SDSs in product counts.
● Product Count: Include only CAS numbers with product counts obeying this criterion.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report lists hazard classification items and the SDSs to which they are assigned. Hazard classification items without SDS assignments also appear in the report. In the report output, click an SDS file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites.
● Class Category: Include only these hazard classifications.
● Class Codes: Include only these hazard classification items.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● SDS State: Include only active, archived, and/or temporary SDSs.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report lists hazard classification items and the SDSs to which they are assigned. Hazard classification items without SDS assignments are omitted from the report output.
Available Criteria:
● Hazard Classifications: Include only these hazard classification items and/or items from these hazard classification categories.
● Common Name: Include only SDSs with common names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Common Name field on the SDS Search Center; for details, see Performing an SDS Search.)
● Manufacturer: Include only SDSs with manufacturer names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Manufacturer field on the SDS Search Center; for details, see Performing an SDS Search.)
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● Document ID: Include only SDSs with document IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Search Corporate: Include SDSs not assigned to the local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● None
This report shows SDSs that have errors or missing data in their ingredients and/or physical data. The report output's Ingredients column shows the status of each ingredient:
● No CAS: Ingredient has no recorded CAS number.
● No Error: Ingredient has no errors (but SDS does have physical property errors; see below).
● No Operator: Ingredient value has no valid operator.
● No Percent High: Ingredient has no valid value.
● Not a Percentage: Ingredient value has no valid unit of measure.
The report output's Physical Properties column shows the status of each SDS's physical properties:
● Error: SDS has no recorded density or specific gravity.
● No Error: SDS has a recorded density and/or specific gravity.
In the report output, click an SDS's file name to open that SDS in a new window (perhaps for the purpose of correcting an error).
Note: It is recommended that you run this report regularly to promptly identify and correct any gaps or errors in SDS data that arise as your product database is updated. For details on setting reports to run automatically on a regular schedule, see Scheduled Reports.
Available Criteria:
● Sites: Include only SDSs assigned to these sites.
● Ingredients: Include only ingredients with these error states.
● Physical Properties: Include only SDSs whose physical properties have this error state.
● Physical State: Include only SDSs of products of this physical state.
● File Name: Include only SDSs with file names obeying this criterion.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Archived: Include only archived or active SDSs.
● CAS: Include only ingredients of this CAS number.
● Ingredient: Include only ingredients with names matching or containing this criterion.
● Contribution: Include only ingredients with contribution values matching or containing this criterion.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report displays ingredients, their CAS numbers, the SDSs that include them, and their contribution amounts in each of those SDSs' products.
Available Criteria:
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Location: Include only SDSs assigned to these locations.
● SDS User-Defined: Include only SDSs with user-defined data obeying these criteria.
● Ingredient User-Defined: Include only ingredients with user-defined data obeying these criteria.
● File Name: Include only SDSs with file names obeying this criterion.
● Ingredient: Include only ingredients with names matching or containing this criterion.
● CAS: Include only ingredients of this CAS number.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● Language: Include only SDSs of this language.
● Format: Include only SDSs of this SDS format.
● Search Corporate: Include SDSs not assigned to the local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● Show 2-Line Display: Show each SDS's file name, language, SDS format, and internal ID on the report output.
This report shows SDSs and their ingredients, including each ingredient's name, CAS number, and contribution amount. On the report output, click an SDS's file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● Language: Include only SDSs of these languages.
● Format: Include only SDSs of these SDS formats.
● File Name: Include only SDSs with file names obeying this criterion.
● CAS: Include only ingredients of this CAS number.
● Ingredient: Include only ingredients with names matching or containing this criterion.
● Low Contribution: Include only ingredients whose minimum contributions obey this criterion. (Applies only to contributions of the Range type, which defines a contribution as a range between a minimum value and a maximum value.)
● High Contribution: Include only ingredients whose maximum contributions obey this criterion. (Applies to contributions of all types.)
● Contribution: Include only ingredients with overall contributions matching or containing this criterion.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
● SDS State: Include only active or archived SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report displays ingredients, their CAS numbers, the SDSs that include them, and their contribution amounts in each of those SDSs' products.
Available Criteria:
● Common Name: Include only SDSs with common names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Common Name field on the SDS Search Center; for details, see Performing an SDS Search.)
● Manufacturer: Include only SDSs with manufacturer names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Manufacturer field on the SDS Search Center; for details, see Performing an SDS Search.)
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Location: Include only SDSs assigned to this location.
● SDS User-Defined: Include only SDSs with user-defined data obeying these criteria.
● Ingredient User-Defined: Include only ingredients with user-defined data obeying these criteria.
● Document ID: Include only SDSs with document IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Ingredient: Include only ingredients with names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Ingredient Name field on the SDS Search Center; for details, see Performing an SDS Search.)
● CAS: Include only ingredients of this CAS number.
● Internal ID: Include only SDSs with internal IDs matching or containing this criterion.
● Language: Include only SDSs of this language.
● Format: Include only SDSs of this SDS format.
● Search Corporate: Include SDSs not assigned to the local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● Show 2-Line Display: Show each SDS's document ID, file name, language, SDS format, and internal ID on the report output.
This report lists all locations (and sub-locations) at your site.
Available Criteria:
● Show Inactive Locations: Include inactive locations.
Available Options:
● None
This report shows the locations at any site(s) you choose. It shows each location’s name, ID, description, cost center, and active/inactive status.
Available Criteria:
● Site Names: Include only locations at these sites.
● Location ID: Include only locations with location IDs matching or containing this criterion.
● Location Description: Include only locations with descriptions matching or containing this criterion.
● Location Cost Center: Include only locations with cost center names matching or containing this criterion.
● Location Name: Include only locations with names matching or containing this criterion.
● Location State: Include only active or inactive locations.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report shows SDSs by file name, including the date when each SDS was created in your system and which hazard ratings have not been entered for it: HMIS, NFPA, both, or neither. In the report output, click any SDS file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites.
● File Name: Include only SDSs with file names obeying this criterion.
● Creation Date: Include only SDSs with creation dates obeying this criterion.
● Missing Ratings: Include only SDSs missing hazard ratings of these types.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report shows how many times per month each user has viewed an SDS. The report’s criteria let you focus the report on a certain year, a certain month, and/or a certain user.
Available Criteria:
● Site Names: Include only SDS views that happened at these sites.
● Year: Include only SDS views that happened during this year.
● Month: Include only SDS views that happened during this month.
● User Name: Include only SDS views by this user.
● View Count: Include only SDS view counts obeying this criterion.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report lists product categories and how many SDSs are assigned to each (not including archived SDSs). Note that in the Product Category list on the report’s Search Criteria page, you may select other sites’ local product categories as criteria.
Available Criteria:
● Site Names: Include only product category assignments made at these sites.
● Product Category: Include only these product categories.
● Category Description: Include only product categories with descriptions matching or containing this criterion.
● Products Assigned: Include only product categories whose counts of assigned SDSs obey this criterion.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report lists product categories and the SDSs assigned to them. In the report output, click an SDS file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only product category assignments made at these sites.
● Product Category: Include only these product categories.
● Product Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Archived: Include only archived or non-archived SDSs.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report lists Corporate and local product categories and the matching criteria defined for each: product name matches, CAS number matches, and ingredient name matches. It also shows whether each criterion is “Absolute and True” (indicating any product obeying the criterion definitely belongs to the category) or “Exclude” (indicating any product obeying the criterion should be excluded from the category). For further details on product category matching criteria, see Administration: Product Categories.
Available Criteria:
● Product Category: Include only these product categories.
● Name Match: Include only product name matching criteria matching or containing this criterion.
● CAS Match: Include only CAS number matching criteria matching or containing this criterion.
● Ingredient Match: Include only CAS number matching criteria matching or containing this criterion.
● Absolute and True: Include only "Absolute and True" matching criteria or non-"Absolute and True" matching criteria.
● Exclude: Include only "Exclude" matching criteria or non-"Exclude" matching criteria.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report lists SDSs and whether each one is assigned to any product categories. In the report output, click an SDS file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites.
● Product Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Categories Assigned: Include only SDSs assigned to categories or SDSs not assigned to any categories.
● Archived: Include only archived or non-archived SDSs.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report shows SDSs that have been archived at your site and the date when each was archived. If you select the Search Corporate criterion (which appears if you have the required access points), then the report output includes SDSs archived by Corporate as well as those archived locally at your site.
Available Criteria:
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Location: Include only SDS assigned to these locations.
● File Name: Include only SDSs with file names obeying this criterion.
● Archive Date: Include only SDSs archived on dates obeying this criterion.
● Internal ID: Include only SDSs with internal IDs matching or containing this criterion.
● Language: Include only SDSs of this language.
● Format: Include only SDSs of this SDS format.
● Search Corporate: Include SDSs archived at Corporate.
● Search Proprietary: Include proprietary SDSs
● Search Hidden: Include proprietary SDSs.
Available Options:
● Show 2-Line Display: Show each SDS's file name, language, SDS format, and internal ID on the report output.
This report lists archived SDSs and their details, including the date when each was archived. On the report output, click any SDS file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Date Archived: Include only SDSs archived on dates obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● Language: Include only SDSs of these languages.
● Format: Include only SDSs of these SDS formats.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report shows SDSs that have been archived at your site and the date when each was archived. If you select the Search Corporate criterion (which appears if you have the required access points), then the report output includes SDSs archived by Corporate as well as those archived locally at your site.
Available Criteria:
● Common Name: Include only SDSs with common names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Common Name field on the SDS Search Center; for details, see Performing an SDS Search.)
● Manufacturer: Include only SDSs with manufacturer names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Manufacturer field on the SDS Search Center; for details, see Performing an SDS Search.)
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Location: Include only SDS assigned to this location.
● Document ID: Include only SDSs with document IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Archive Date: Include only SDSs archived on dates obeying this criterion.
● Internal ID: Include only SDSs with internal IDs matching or containing this criterion.
● Language: Include only SDSs of this language.
● Format: Include only SDSs of this SDS format.
● Search Corporate: Include SDSs archived at Corporate.
● Search Proprietary: Include proprietary SDSs
● Search Hidden: Include proprietary SDSs.
Available Options:
● Show 2-Line Display: Show each SDS's document ID, file name, language, SDS format, and internal ID on the report output.
This report shows a simple list of SDSs sorted by the sites where they are assigned.
Available Criteria:
● Sites: Include only SDSs assigned to these sites.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● 2-Line Display: Show each SDS's file name, language, and internal ID on the report output.
This report shows a simple list of SDSs and their basic details. By default, the report output is sorted by site. In the report output, click an SDS file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● Language: Include only SDSs of these languages.
● Format: Include only SDSs of these SDS formats.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report lists SDSs and the attachments assigned to each, including both product attachments (defined and assigned to specific SDSs using their Attachments pages) and general attachments (defined on the administrative side and assigned to any SDS; see Administration: Attachments.) This report contains the following columns showing attachment data:
● Attachment Site Name: The site where the attachment was assigned to the SDS. Applies to both product attachments and general attachments.
● Product Attachment: The name of the product attachment.
● Original File Name: The name of the product attachment’s file before it was uploaded into Comply Plus. (Shown for uploaded attachments only. Attachments that were not uploaded—but defined as paths instead—show no data in this column.)
● Attachment Path: The path that points Comply Plus to the product attachment file.
● SDS Attachment: The name of the general attachment.
● SDS Attachment Path: The path that points Comply Plus to the general attachment file.
● SDS Attachment Description: The description of the general attachment.
Note: If you supply no attachment-related criteria when running this report, it might include SDSs without any attachments as well as those with attachments.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Language: Include only SDSs of these languages.
● Format: Include only SDSs of these SDS formats.
● File Format: Include only SDSs with SDS files of text format (such as .TXT), image format (such as .PDF), both, or neither. (These files are distinct from attachments.)
● SDS State: Include only active, archived, and/or temporary SDSs.
● Attachment Site Name: Include only SDSs with attachments assigned at these sites.
● Product Attachment: Include only product attachments with names matching or containing this criterion.
● Original File Name: Include only product attachments with original file names matching or containing this criterion.
● Attachment Path: Include only product attachments with file paths matching or containing this criterion.
● SDS Attachment: Include only general attachments with names matching or containing this criterion.
● SDS Attachment Path: Include only general attachments with file paths matching or containing this criterion.
● SDS Attachment Description: Include only general attachments with descriptions matching or containing this criterion.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report lists SDSs and the hazard classification items assigned to each. (SDSs with no assigned classification items are omitted from the report output.) Classification items assigned to an SDS by Corporate are displayed for all sites where the SDS is assigned. In the report output, click any SDS file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● SDS State: Include only active, archived, and/or temporary SDSs.
● Class Category: Include only hazard classification item assignments from these classifications.
● Class Codes: Include only assignments of these hazard classification items.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report lists SDSs and the hazard classification items assigned to each, including both Corporate assignments and assignments made at your local site. These assignments are shown in a two-column list under each SDS:
● Classification Category: The category of classifications to which the assigned classification item belongs (examples: Risk Phrases, SARA Hazards, GHS Pictograms).
● Item: The specific item assigned from the classification category to the SDS.
In the report output, any SDS's common name might show one or two asterisks (*) to indicate an archived and/or proprietary status (depending on whether your criteria include these SDSs):
● Red asterisk (*) = archived SDS
● Blue asterisk (*) = proprietary SDS
SDSs with no assigned classification items are omitted from the report output.
Available Criteria:
● Common Name: Include only SDSs with common names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Common Name field on the SDS Search Center; for details, see Performing an SDS Search.)
● Manufacturer: Include only SDSs with manufacturer names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Manufacturer field on the SDS Search Center; for details, see Performing an SDS Search.)
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● Document ID: Include only SDSs with document IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Hazard Classifications: Include only SDSs with these hazard classification items and/or items from these classification categories assigned. Show only these assignments.
● Search Corporate: Include SDSs not assigned to the local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● Show 2-Line Display: Show each SDS's document ID, file name, language, format, and internal ID on the report output.
This report identifies duplicate SDSs in your system. A duplicate SDS is an SDS that has exactly the same common name, manufacturer, and revision date as another SDS. Along with the basic details of each SDS, the report output shows the date it was created in your system, its current state (Normal, Archived, etc.), and its number (“count”) of duplicates. In the report output, click any SDS file name to open that SDS in a new window.
Note: By default, this report shows SDSs matching your criteria, whether they have duplicates or not. To see only SDSs with at least one duplicate, enter Greater Than or Equal To 1 as the Count of Duplicates criterion.
Available Criteria:
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Language: Include only SDSs of these languages.
● SDS Format: Include only SDSs of these SDS formats.
● Create Date: Include only SDSs with creation dates obeying this criterion.
● SDS State: Include only archived, active ("normal"), and/or temporary ("in-process") SDSs.
● Count of Duplicates: Include only SDSs whose numbers of duplicates match this criterion.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report lists any active SDSs that match one another in both common name and manufacturer. A good practice to keep your SDS database clean and up-to-date is by archiving an outdated SDS when a newer revision exists in the database. Thus if two or more SDSs have the same common name and manufacturer, all SDSs in that set with outdated revision dates might be candidates for archiving.
This report identifies common name matches using “converted common names,” which are common names with all non-alphanumeric characters removed. Thus if two common names are punctuated differently—with parentheses, hyphens, quotation marks, and so forth—but are otherwise alike, they match each other as converted common names.
In the report output, click an SDS file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites.
● Converted Common Name: Include only SDSs with converted (punctuation-free) common names matching or containing this criterion.
● Common Name: Include only SDSs with standard common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report (a Telerik version of the Quick View report above) lists any active SDSs that match one another in both common name and manufacturer. A good practice to keep your SDS database clean and up-to-date is by archiving an outdated SDS when a newer revision exists in the database. Thus if two or more SDSs have the same common name and manufacturer, all SDSs in that set with outdated revision dates might be candidates for archiving.
This report identifies common name matches using “converted common names,” which are common names with all non-alphanumeric characters removed. Thus if two common names are differently spaced or punctuated—with parentheses, hyphens, quotation marks, and so forth—but are otherwise alike, they match each other as converted common names.
Available Criteria:
● Converted Common Name: Include only SDSs with "clean" (punctuation-free) common names matching or containing this criterion.
● Common Name: Include only SDSs with standard common names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Common Name field on the SDS Search Center; for details, see Performing an SDS Search.)
● Manufacturer: Include only SDSs with manufacturer names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Common Name field on the SDS Search Center; for details, see Performing an SDS Search.)
● Document ID: Include only SDSs with document IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Search Proprietary: Include proprietary SDSs.
Available Options:
● None
This report shows SDSs that may be possible candidates for archiving because they lack various data and activities. This is shown in the following columns:
● Has Transactions: Shows whether each SDS has ever undergone any transactions. (See SDS Transactions.)
● Has Parts: Shows whether each SDS is set as a component of any parts. (See Part Components.)
● Has Lots: Shows whether each SDS is set as the component of any lots. (See Lot Component.)
● Has Part Transactions: Shows whether each SDS’s parts (i.e., the parts that would cause a “Yes” in the Has Parts column) have ever undergone any transactions.
● Has Related Parts: Shows whether each SDS has any related parts. (See SDS Related Parts.)
● Is Used: Shows whether an SDS has any of the data/activities indicated by the columns listed above. In other words, if all Has columns show “No,” this column indicates “No,” indicating the SDS may be disused and a candidate for archiving.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
● Is Used: Include only SDSs showing "Yes" in one or more of the Has columns or only SDSs showing "No" in every Has column.
● Has Transactions: Include only SDSs that have recorded transactions or only SDSs without recorded transactions.
● Has Parts: Include only SDSs that are components in parts or only SDSs that are not.
● Has Lots: Include only SDSs that are lot components or only SDSs that are not.
● Has Part Transactions: Include only SDSs that are components in parts with recorded transactions or only SDSs that are not.
● Has Related Parts: Include only SDSs with related parts or only SDSs without related parts.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report shows parts and their related SDSs. If the report shows multiple SDSs in the same language for the same product related to a single part, this may indicate that one or more of those SDSs are obsolete and should be archived. On the report output, click a part number to open that part in a new window. Click an SDS file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only parts and related SDSs assigned to these sites.
● Part Number: Include only parts with part numbers obeying this criterion.
● Product Name: Include only parts with product names matching or containing this criterion.
● SDS File Name: Include only SDSs with file names obeying this criterion.
● SDS Common Name: Include only related SDSs with common names matching or containing this criterion.
● SDS Manufacturer: Include only related SDSs with manufacturer names matching or containing this criterion.
● SDS Revision Date: Include only related SDSs with revision dates obeying this criterion.
● Language: Include only related SDSs of these languages.
● Format: Include only related SDSs of these SDS formats.
● Proprietary SDS: Include only proprietary or non-proprietary related SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report lists SDSs’ hazard ratings in color-coded HMIS and NFPA pictograms.
Available Criteria:
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Location: Include only SDSs assigned to these locations.
● SDS User-Defined: Include only SDSs with user-defined data obeying these criteria.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs matching or containing this criterion.
● Language: Include only SDSs of this language.
● NFPA Health: Include only SDSs with NFPA Health hazard ratings obeying this criterion.
● NFPA Flammability: Include only SDSs with NFPA Flammability hazard ratings obeying this criterion.
● NFPA Reactivity: Include only SDSs with NFPA Reactivity hazard ratings obeying this criterion.
● NFPA Other: Include only SDSs with NFPA Other (Special Hazard) hazard ratings obeying this criterion.
● HMIS Health: Include only SDSs with HMIS Health hazard ratings obeying this criterion.
● HMIS Flammability: Include only SDSs with HMIS Flammability hazard ratings obeying this criterion.
● HMIS Reactivity: Include only SDSs with HMIS Reactivity hazard ratings obeying this criterion.
● HMIS Other: Include only SDSs with HMIS Other (Personal Protective Equipment) hazard ratings obeying this criterion.
● Search Corporate: Include SDSs not assigned to the local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● 2-Line Display: Show each SDS's file name, language, and internal ID on the report output.
This report lists SDSs and the two sets of hazard ratings indexed for each: its global ratings and its local ratings. (See Editing SDS Hazard Ratings for details.) Each set of ratings includes NFPA, HMIS, and HMIS III. Each rating is given its own column, including a Health Chronic column for the asterisk (*) that denotes a chronic health hazard in HMIS III ratings. The Local Hazards column shows whether each SDS has local ratings; to focus the report on SDSs with or without local ratings, select this column’s Yes or No criterion (respectively) before running the report.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● Language: Include only SDSs of these languages.
● Format: Include only SDSs of these SDS formats.
● NFPA Health: Include only SDSs with global NFPA Health hazard ratings matching this criterion.
● NFPA Flammability: Include only SDSs with global NFPA Flammability hazard ratings matching this criterion.
● NFPA Reactivity: Include only SDSs with global NFPA Reactivity hazard ratings matching this criterion.
● NFPA Other: Include only SDSs with global NFPA Other (Special Hazard) hazard ratings matching this criterion.
● HMIS Health: Include only SDSs with global HMIS Health hazard ratings matching this criterion.
● HMIS Flammability: Include only SDSs with global HMIS Flammability hazard ratings matching this criterion.
● HMIS Reactivity: Include only SDSs with global HMIS Reactivity hazard ratings matching this criterion.
● HMIS PPE: Include only SDSs with global HMIS PPE hazard ratings matching this criterion.
● HMIS3 Health: Include only SDSs with global HMIS III Health hazard ratings matching this criterion.
● HMIS3 Health Chronic: Enter an asterisk (*) here to include only SDSs with global HMIS III Health hazard ratings defined as chronic.
● HMIS3 Flammability: Include only SDSs with global HMIS III Flammability hazard ratings matching this criterion.
● HMIS3 Physical: Include only SDSs with global HMIS III Physical hazard ratings matching this criterion.
● HMIS3 PPE: Include only SDSs with global HMIS III PPE hazard ratings matching this criterion.
● NFPA Health Local: Include only SDSs with local NFPA Health hazard ratings matching this criterion.
● NFPA Flammability Local: Include only SDSs with local NFPA Flammability hazard ratings matching this criterion.
● NFPA Reactivity Local: Include only SDSs with local NFPA Reactivity hazard ratings matching this criterion.
● NFPA Other Local: Include only SDSs with local NFPA Other (Special Hazard) hazard ratings matching this criterion.
● HMIS Health Local: Include only SDSs with local HMIS Health hazard ratings matching this criterion.
● HMIS Flammability Local: Include only SDSs with local HMIS Flammability hazard ratings matching this criterion.
● HMIS Reactivity Local: Include only SDSs with local HMIS Reactivity hazard ratings matching this criterion.
● HMIS PPE Local: Include only SDSs with local HMIS PPE hazard ratings matching this criterion.
● HMIS3 Health Local: Include only SDSs with local HMIS III Health hazard ratings matching this criterion.
● HMIS3 Health Chronic Local: Enter an asterisk (*) here to include only SDSs with local HMIS III Health hazard ratings defined as chronic.
● HMIS3 Flammability Local: Include only SDSs with local HMIS III Flammability hazard ratings matching this criterion.
● HMIS3 Physical Local: Include only SDSs with local HMIS III Physical hazard ratings matching this criterion.
● HMIS3 PPE Local: Include only SDSs with local HMIS III PPE hazard ratings matching this criterion.
● Local Hazards: Include only SDSs with or without local hazard ratings.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report shows a simple list of SDSs, including each one’s site, common name, manufacturer, revision date, internal ID, file name, language, SDS format, file format(s), state (active/archived/temporary), temporary SDS number, and proprietary status. In the report output, click an SDS file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● File Name: Include only SDSs with file names matching or containing this criterion.
● Language: Include only SDSs of these languages.
● SDS Format: Include only SDSs of these SDS formats.
● File Format: Include only SDSs with SDS files of text format (such as .TXT), image format (such as .PDF), both, or neither.
● SDS State: Include only active, archived, and/or temporary SDSs.
● Temporary SDS Number: Include only temporary SDSs with temporary SDS numbers obeying this criterion.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report displays a simple list of SDSs, including each one’s common name, manufacturer name, and revision date. If you select the Show 2-Line Display option on the report’s Search Criteria page, it also shows the SDSs’ document IDs, file names, languages, formats, and internal IDs, plus the temporary SDS numbers of any temporary SDSs appearing in the report.
Available Criteria:
● Common Name: Include only SDSs with common names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Common Name field on the SDS Search Center; for details, see Performing an SDS Search.)
● Manufacturer: Include only SDSs with manufacturer names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Manufacturer field on the SDS Search Center; for details, see Performing an SDS Search.)
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Location: Include only SDSs assigned to these locations.
● SDS User-Defined: Include only SDSs with user-defined data obeying these criteria.
● Document ID: Include only SDSs with document IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs matching or containing this criterion.
● Language: Include only SDSs of this language.
● Show Only Temp SDSs: Include only temporary SDSs.
● Format: Include only SDSs of this SDS format.
● Search Corporate: Include SDSs not assigned to the local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● Show Full Common Name: Allow multiple lines for longer SDS common names so they will not be truncated to fit on single lines.
● Show 2-Line Display: Show each SDS's document ID, file name, language, SDS format, and internal ID on the report output. Also show temporary SDS numbers for temporary SDSs.
This report lists sites, the locations within each of those sites, and the SDSs assigned to each of those locations. The report output shows each SDS’s common name, manufacturer, revision date, internal ID, file name, and archived status, along with whether each location is active or not. Click an SDS file name to open that SDS in a new window.
Available Criteria:
● Sites: Include locations from these sites only.
● Location: Include only locations with names obeying this criterion.
● Location Active: Include only active or inactive locations.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● SDS Archived: Include only active or archived SDSs.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report shows SDSs, including the number of sites where each SDS is active and the number of sites where it is archived. On the report output, click an SDS file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Archived: Include only archived or non-archived SDSs.
● Number of Active Sites: Include only SDSs active at a number of sites that obeys this criterion.
● Number of Archived Sites: Include only SDSs archived at a number of sites that obeys this criterion.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report shows SDSs, their ingredients, and the user-defined data assigned to each ingredient. Click Filter on Ingredient User Defined to choose up to three user-defined fields to appear on the report. You may do any of the following for each field you select:
● Enter no criterion for the field. The report output will show this field for each ingredient in the report output, regardless of what (or whether) data is entered for the ingredient.
● Enter no criterion for the field and select its Restrict where [user-defined field name] is assigned option. The report output will show this field for each ingredient in the report output, but will include only ingredients with data entered in this field.
● Enter a criterion for the field. The report output will show this field for each ingredient in the report output, but will include only ingredients with data obeying your criterion entered in this user-defined field.
Note:
When generating this report as a standard Crystal report, select no more
than three user-defined fields. When using the Export to Excel Format
option—which generates the report as a spreadsheet to be exported into
Excel (using the Crystal Report Viewer’s export (.png)
)
icon)—select only one user-defined field.
Available Criteria:
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Ingredient: Include only SDS ingredients with names matching or containing this criterion.
● CAS Number: Include only SDS ingredients with CAS numbers matching this criterion.
● Ingredient User-Defined: Include these ingredient user-defined fields; see above for guidelines on selecting these fields.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● Language: Include only SDSs of this language.
● Search Corporate: Include SDSs not assigned to the local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● Export to Excel Format (1 UDF only): Generate the report output in a format intended to be exported from the Crystal Report Viewer to Excel.
This report shows SDSs, their ingredients, and the user-defined data assigned to each ingredient. On the report’s Search Criteria page, click Filter on Ingredient User Defined to choose up to three user-defined fields to appear on the report. You may do any of the following for each field you select:
● Enter no criterion for the field. The report output will show this field for each ingredient with data in this field, and will not exclude ingredients with no data in this field.
● Enter no criterion for the field and select its Restrict where [user-defined field name] is assigned option. The report output will show this field for each ingredient in the report output, but will include only ingredients with data in this field.
● Enter a criterion for the field. The report output will show this field for each ingredient in the report output, but will include only ingredients with data obeying your criterion in this field.
Available Criteria:
● Common Name: Include only SDSs with common names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Common Name field on the SDS Search Center; for details, see Performing an SDS Search.)
● Manufacturer: Include only SDSs with manufacturer names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Manufacturer field on the SDS Search Center; for details, see Performing an SDS Search.)
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Ingredient: Include only SDS ingredients with names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Ingredient Name field on the SDS Search Center; for details, see Performing an SDS Search.)
● CAS Number: Include only SDS ingredients with CAS numbers matching this criterion.
● Ingredient User-Defined: Include these ingredient user-defined fields; see above for guidelines on selecting these fields.
● Document ID: Include only SDSs with document IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs matching or containing this criterion.
● Language: Include only SDSs of this language.
● Format: Include only SDSs of this SDS format.
● Search Corporate: Include SDSs not assigned to the local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● None
This report shows SDSs, their ingredients, and each ingredient’s CAS number and contribution to its product.
Available Criteria:
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Location: Include only SDSs assigned to these locations.
● SDS User-Defined: Include only SDSs with this user-defined data.
● Ingredient User-Defined: Include only SDS ingredients with this user-defined data.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs matching or containing this criterion.
● Language: Include only SDSs of this language.
● Ingredient: Include only SDS ingredients with names matching or containing this criterion.
● CAS: Include only SDS ingredients with CAS numbers matching this criterion.
● Format: Include only SDSs of this format.
● Search Corporate: Include SDSs not assigned to the local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● 2-Line Display: Show each SDS's file name, language, SDS format, and internal ID on the report output.
This report shows SDSs, their ingredients, and each ingredient’s CAS number and contribution to its product. Any SDS without recorded ingredients is omitted from the report output.
Available Criteria:
● Common Name: Include only SDSs with common names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Common Name field on the SDS Search Center; for details, see Performing an SDS Search.)
● Manufacturer: Include only SDSs with manufacturer names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Manufacturer field on the SDS Search Center; for details, see Performing an SDS Search.)
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Location: Include only SDSs assigned to these locations.
● SDS User-Defined: Include only SDSs with this user-defined data.
● Ingredient User-Defined: Include only SDS ingredients with this user-defined data.
● Document ID: Include only SDSs with document IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs matching or containing this criterion.
● Language: Include only SDSs of this language.
● Ingredient: Include only SDS ingredients with names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Ingredient Name field on the SDS Search Center; for details, see Performing an SDS Search.)
● CAS: Include only SDS ingredients with CAS numbers matching this criterion.
● Format: Include only SDSs of this format.
● Search Corporate: Include SDSs not assigned to the local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● 2-Line Display: Show each SDS's document ID, file name, language, SDS format, and internal ID on the report output.
This report lists SDSs with their ingredients, including each ingredient’s CAS number and contribution to its product. On the report output, click an SDS file name to open that SDS in a new window.
Available Criteria:
● Sites: Include only SDSs assigned to these sites.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Archived: Include only archived or non-archived SDSs.
● CAS: Include only SDS ingredients with CAS numbers matching this criterion.
● Ingredient: Include only SDS ingredients with names matching or containing this criterion.
● Ingredient Contribution: Include only SDS ingredients with contribution amounts matching or containing this criterion.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report lists locations and the number (“count”) of SDSs assigned to each. Separate counts are shown for the active and archived SDSs assigned to each location.
Available Criteria:
● Site Names: Include only locations from these sites.
● Location: Include only these locations.
● Location Active: Include only active or inactive locations.
● Active SDS Count: Include only locations with a number of active SDSs that obeys this criterion.
● Archived SDS Count: Include only locations with a number of archived SDSs that obeys this criterion.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report shows a history of your system’s SDS-to-location assignments and exclusions. For each SDS, the report shows the following location-related actions, including the location involved, when the action was performed, and which user performed it:
● SDS assigned to the location
● SDS un-assigned from the location
● SDS excluded from the location
● SDS un-excluded from the location
For details on these actions, see SDS Location Assignments/Exclusions. On the report output, click an SDS file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only location activity at these sites.
● File Name: Include only SDSs with file names obeying this criterion.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Location: Include only these locations.
● Action Date: Include only location-related actions that occurred on dates obeying this criterion.
● Action: Include only these location-related actions.
● User Name: Include only actions performed by users with user names matching or obeying this criterion.
● Full Name: Include only actions performed by users with full names matching or obeying this criterion.
● User Group: Include only actions performed by users in these user groups.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report lists SDSs and each one's location assignments at your site. SDSs without location assignments are omitted.
Available Criteria:
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Location: Include only SDSs assigned to these locations.
● SDS User-Defined: Include only SDSs with this user-defined data.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● Language: Include only SDSs of this language.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● 2-Line Display: Show each SDS's file name, language, and internal ID on the report output.
This report lists locations and the SDSs assigned to each. In the report output, click an SDS file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only locations from these sites.
● Location: Include only these locations.
● Location Active: Include only active or inactive locations.
● Common Name: Include only assigned SDSs with common names matching or containing this criterion.
● Manufacturer: Include only assigned SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only assigned SDSs with revision dates obeying this criterion.
● File Name: Include only assigned SDSs with file names obeying this criterion.
● SDS Archived: Include only archived or active SDSs.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
Each page of this report's output shows a location and the SDSs assigned to that location. You can also have the output include each SDS's hazard ratings or only SDSs with no recorded hazard ratings; see options below.
Available Criteria:
● Common Name: Include only assigned SDSs with common names matching or containing this criterion.
● Manufacturer: Include only assigned SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only assigned SDSs with revision dates obeying this criterion.
● Locations: Include only these locations.
● SDS User-Defined: Include only assigned SDSs with this user-defined data.
● File Name: Include only assigned SDSs with file names obeying this criterion.
● Filter on Missing Ratings: Include only assigned SDSs that have neither HMIS nor NFPA ratings entered.
● Search Archive: Include assigned SDSs that are archived.
● Search Proprietary: Include assigned SDSs that are proprietary.
● Search Hidden: Include assigned SDSs that are hidden.
Available Options:
● Show HMIS: Show each SDS's HMIS hazard ratings.
● Show NFPA: Show each SDS's NFPA hazard ratings.
● Export Report: Generate the report output as plain data columns without cosmetic elements (such as title and print date), making it easily exported to a spreadsheet format (such as Excel).
This report shows which SDSs in your system have no recorded hazard classifications. Exactly which hazard classifications the SDSs are missing depends on whether you select classifications in the report's criteria (see Hazard Classifications criterion described below).
For details on SDSs and their hazard classifications, see SDS Hazards.
Available Criteria:
● Common Name: Include only SDSs with common names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Common Name field on the SDS Search Center; for details, see Performing an SDS Search.)
● Manufacturer: Include only SDSs with manufacturer names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Manufacturer field on the SDS Search Center; for details, see Performing an SDS Search.)
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● Document ID: Include only SDSs with document IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Hazard Classifications: Include only SDSs that do not have these hazard classifications. Your selection for this criterion has one of the following effects on the report output:
● No selection: Report output shows SDSs that do not have any assigned hazard classifications.
● Hazard classification item: Report output shows SDSs that do not have this item assigned.
● Hazard classification category: Report output shows SDSs that have no items from this category assigned.
● One or more categories and/or items: Report output shows SDSs that do not have one or more of the selected classification assignments.
● Format: Include only SDSs of this SDS format.
● Search Corporate: Include SDSs not assigned to the local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● 2-Line Display: Show each SDS's document ID, file name, internal ID, and format on the report output.
This report lists SDSs that lack certain types of data, such as locations, ingredients, synonyms, and so forth. Use the report's check boxes to select the data types lacked by the SDSs appearing in the report output. Use the Match All Supplied Criteria check box to select whether these SDSs are missing all selected data types or any of the selected data types; see below for details.
Available Criteria:
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Location: Include only SDSs assigned to these locations.
● SDS User-Defined: Include only SDSs with this user-defined data.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs matching or containing this criterion.
● Language: Include only SDSs of this language.
● Match All Supplied Criteria: Include only SDSs missing all of the missing data types selected below. (If you clear this option, the report output includes SDSs missing any of the missing data types selected below.)
● Ingredients: Include SDSs missing ingredients.
● Synonyms: Include SDSs missing synonyms.
● Locations: Include SDSs missing location assignments.
● Parts: Include SDSs missing related parts.
● HMIS Ratings: Include SDSs missing HMIS hazard ratings.
● NFPA Ratings: Include SDSs missing NFPA hazard ratings.
● Search Corporate: Include SDSs not assigned to your local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● Show 2-Line Display: Show each SDS's file name, language, and internal ID on the report output.
This report lists SDSs that lack certain types of data, such as location assignments, ingredients, synonyms, and so forth. Use the report's check boxes to select which data types are missing from the SDSs appearing in the report output. Use the Match All Supplied Criteria check box to select whether these SDSs are missing all selected data types or any of the selected data types; see below for details.
Available Criteria:
● Common Name: Include only SDSs with common names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Common Name field on the SDS Search Center; for details, see Performing an SDS Search.)
● Manufacturer: Include only SDSs with manufacturer names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Manufacturer field on the SDS Search Center; for details, see Performing an SDS Search.)
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Location: Include only SDSs assigned to these locations.
● SDS User-Defined: Include only SDSs with this user-defined data.
● Document ID: Include only SDSs with document IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs matching or containing this criterion.
● Language: Include only SDSs of this language.
● Match All Supplied Criteria: Include only SDSs missing all of the missing data types selected below. (If you clear this option, the report output includes SDSs missing any of the missing data types selected below.)
● Ingredients: Include SDSs missing ingredients.
● Synonyms: Include SDSs missing synonyms.
● Locations: Include SDSs missing location assignments.
● Parts: Include SDSs missing related parts.
● HMIS Ratings: Include SDSs missing HMIS hazard ratings.
● NFPA Ratings: Include SDSs missing NFPA hazard ratings.
● Search Corporate: Include SDSs not assigned to your local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● Show 2-Line Display: Show each SDS's document ID, file name, language, and internal ID on the report output.
This report identifies SDSs missing specific gravity and density data on their Primary Information pages. This is shown by each SDS's value in the report output's Density column:
● OK: SDS has a recorded specific gravity, density, or both.
● Missing: SDS is missing both specific gravity and density data.
On the report output, click an SDS file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Physical State: Include only SDSs with products of this physical state.
● SDS State: Include only active, archived, and/or temporary SDSs.
● Density Status: Include only SDSs missing both specific gravity and density (Missing) or only SDSs with at least one of these recorded (OK).
● Language: Include only SDSs of these languages.
● Format: Include only SDSs of these SDS formats.
● Temporary SDS Num: Include only temporary SDSs with temporary SDS numbers obeying this criterion.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report shows SDSs and each one’s recorded physical state, specific gravity, density, shelf life, VOC, vapor density, and flash point.
Available Criteria:
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Location: Include only SDSs assigned to these locations.
● SDS User-Defined: Include only SDSs with this user-defined data.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs matching or containing this criterion.
● Language: Include only SDSs of this language.
● Physical State: Include only SDSs with products of this physical state: G (Gas), L (Liquid), or S (Solid).
● Specific Gravity High: Include only SDSs with specific gravities (or maximum specific gravities, for values defined as Ranges) obeying this criterion.
● Density High: Include only SDSs with densities (or maximum densities, for values defined as Ranges) obeying this criterion.
● VOC High: Include only SDSs with VOCs (or maximum VOCs, for values defined as Ranges) obeying this criterion.
● Vapor Density High: Include only SDSs with vapor densities (or maximum vapor densities, for values defined as Ranges) obeying this criterion.
● Flash Point: Include only SDSs with flash point values obeying this criterion.
● Flash Point UOM: Include only SDSs with flash points defined by this unit of measure.
● Shelf Life: Include only SDSs with shelf lives (as expressed in days) matching this criterion.
● Search Corporate: Include SDSs not assigned to your local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● 2-Line Display: Show each SDS's file name, language, and internal ID on the report output.
This report shows SDSs and each one’s indexed physical state, specific gravity, density, vapor density, VOC, flash point, and shelf life. In the report output, click an SDS file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites.
● SDS State: Include only active, archived, and/or temporary SDSs.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● Language: Include only SDSs of these languages.
● Format: Include only SDSs of these SDS formats.
● Physical State: Include only SDSs with physical states (Gas, Liquid, or Solid) matching or containing this criterion.
● Specific Gravity: Include only SDSs with specific gravities matching or containing this criterion.
● Density: Include only SDSs with densities matching or containing this criterion.
● Vapor Density: Include only SDSs with vapor densities matching or containing this criterion.
● VOC: Include only SDSs with VOCs matching or containing this criterion.
● Flash Point: Include only SDSs with flash points matching or containing this criterion.
● Shelf Life: Include only SDSs with shelf lives matching or containing this criterion.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report shows SDSs and each one’s recorded physical state, specific gravity, density, shelf life, VOC, vapor density, and flash point.
Available Criteria:
● Common Name: Include only SDSs with common names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Common Name field on the SDS Search Center; for details, see Performing an SDS Search.)
● Manufacturer: Include only SDSs with manufacturer names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Manufacturer field on the SDS Search Center; for details, see Performing an SDS Search.)
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Location: Include only SDSs assigned to this location.
● SDS User-Defined: Include only SDSs with this user-defined data.
● Document ID: Include only SDSs with document IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs matching or containing this criterion.
● Language: Include only SDSs of this language.
● Physical State: Include only SDSs with products of this physical state: G (Gas), L (Liquid), or S (Solid).
● Specific Gravity High: Include only SDSs with specific gravities (or maximum specific gravities, for values defined as Ranges) obeying this criterion.
● Density High: Include only SDSs with densities (or maximum densities, for values defined as Ranges) obeying this criterion.
● VOC High: Include only SDSs with VOCs (or maximum VOCs, for values defined as Ranges) obeying this criterion.
● Vapor Density High: Include only SDSs with vapor densities (or maximum vapor densities, for values defined as Ranges) obeying this criterion.
● Flash Point: Include only SDSs with flash point values obeying this criterion.
● Flash Point UOM: Include only SDSs with flash points defined by this unit of measure.
● Shelf Life: Include only SDSs with shelf lives (as expressed in days) matching this criterion.
● Search Corporate: Include SDSs not assigned to your local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● 2-Line Display: Show each SDS's document ID, file name, language, SDS format, and internal ID on the report output.
This report shows the service histories of multiple SDSs, as you might view individually on an SDS's Service History page. A service history is a record of the major actions involving an SDS, including which user performed the action and when. In the report output, click an SDS file name to open that SDS in a new window. For details on each kind of service history entry, see Viewing an SDS Service History.
Available Criteria:
● Sites: Include only SDSs assigned to these sites.
● File Name: Include only SDSs with file names obeying this criterion.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Language: Include only SDSs of languages matching or containing this criterion.
● SDS Format: Include only SDSs of SDS formats matching or containing this criterion.
● SDS State: Include only SDSs of states (Active, Archived, or Temporary) matching or containing this criterion.
● User Name: Include only service history actions performed by users with user names matching or containing this criterion.
● Description: Include only service history actions with descriptions matching or containing this criterion.
● Action: Include only service history actions of these action types.
● Action Date: Include only service history actions performed on dates obeying this criterion.
● Action Scope: Include only service history actions performed at Corporate (Corporate) or locally (specific site name).
● Replaced by SDS: Include only SDSs archived and replaced by SDSs with file names obeying this criterion.
● Proprietary SDS: Include only proprietary (Yes) or non-proprietary (No) SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report lists how many SDSs are assigned to a site. Each site's SDS count is divided into two columns: active SDSs and archived SDSs.
Available Criteria:
● Company Name: Include only sites in these companies.
● Division Name: Include only sites in these divisions.
● Site Names: Include only these sites.
● Site Active: Include only active or inactive sites.
● Active SDS Count: Include only sites with active SDS counts obeying this criterion.
● Archived SDS Count: Include only sites with archived SDS counts obeying this criterion.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report lists SDSs and the synonyms of each. SDSs without synonyms are omitted.
Available Criteria:
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Location: Include only SDSs assigned to these locations.
● SDS User-Defined: Include only SDSs with this user-defined data.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs matching or containing this criterion.
● Language: Include only SDSs of this language.
● Synonym: Include only SDSs with synonyms matching or containing this criterion.
● Search Corporate: Include SDSs not assigned to your local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● 2-Line Display: Show each SDS's file name, language, and internal ID on the report output.
A Telerik version of the previous report, this report shows SDSs and the synonyms of each. SDSs without synonyms are omitted.
Available Criteria:
● Common Name: Include only SDSs with common names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Common Name field on the SDS Search Center; for details, see Performing an SDS Search.)
● Manufacturer: Include only SDSs with manufacturer names obeying this criterion. (In this field, you can enter the same variety of criterion types you can enter in the Manufacturer field on the SDS Search Center; for details, see Performing an SDS Search.)
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Location: Include only SDSs assigned to these locations.
● SDS User-Defined: Include only SDSs with this user-defined data.
● Document ID: Include only SDSs with document IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs matching or containing this criterion.
● Language: Include only SDSs of this language.
● Synonym: Include only SDSs with synonyms matching or containing this criterion.
● Search Corporate: Include SDSs not assigned to your local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● 2-Line Display: Show each SDS's document ID, file name, language, format, and internal ID on the report output.
This report lists SDS synonyms, including how many SDSs have each as a synonym (“SDS Count”), which specific SDSs have each as a synonym, and whether each of these SDSs has been archived at the site and/or Corporate levels. On the report output, click an SDS file name to open that SDS in a new window.
Available reporting search criteria:
● Sites: Include only SDSs assigned to these sites.
● Synonym: Include only synonyms matching or containing this criterion.
● Languages: Include only SDSs of this language.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● SDS Count: Include only synonyms with SDS counts obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Common Name: Include only SDSs with common names matching or obeying this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or obeying this criterion.
● Site Archived: Include only locally archived SDSs or locally active SDSs.
● Corporate Archived: Include only Corporate-archived SDSs or SDSs active at Corporate.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report shows SDSs that have been viewed and had secondary labels printed for them, including which user performed each action and when. In the report output, click an SDS file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites.
● User Name: Include only SDS actions performed by users with user names matching or containing this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Action: Include only actions with names (View SDS / Print Secondary Label) matching or containing this criterion.
● Action Date: Include only actions occurring on this date.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report shows SDSs and how many lots contain each SDS's product as their component. Each SDS’s lot count is divided into active and inactive lots. In the report output, click an SDS file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Language: Include only SDSs of these languages.
● Format: Include only SDSs of these SDS formats.
● SDS State: Include only active, archived, and/or temporary SDSs.
● Temporary SDS Num: Include only temporary SDSs with temporary SDS numbers obeying this criterion.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
● Active Container Count: Include an SDS only if its number of active lots containing the SDS's product obeys this criterion.
● Inactive Container Count: Include an SDS only if its number of inactive lots containing the SDS's product obeys this criterion.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report lists SDSs and the related parts assigned to each.
Available Criteria:
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Location: Include only SDSs assigned to these locations.
● SDS User-Defined: Include only SDSs with this user-defined data.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs matching or containing this criterion.
● Language: Include only SDSs of this language.
● Part Number: Show only related parts with part numbers matching or containing this criterion.
● Product Name: Show only related parts with product names matching or containing this criterion.
● Show SDSs with no related Parts: Include SDSs that have no related parts.
● Search Corporate: Include SDSs not assigned to your local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● 2-Line Display: Show each SDS's file name, language, and internal ID on the report output.
This report shows SDSs and their related parts. In the report output, click an SDS file name to open that SDS in a new window.
Available Criteria:
● Site Names: Include only SDSs assigned to these sites.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs obeying this criterion.
● Language: Include only SDSs of these languages.
● Format: Include only SDSs of these SDS formats.
● SDS State: Include only active, archived, and/or temporary SDSs.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
● Related Parts Assigned: Include only SDSs with or without related parts.
● Part Number: Include only related parts with part numbers matching or containing this criterion.
● Product Name: Include only related parts with product names matching or containing this criterion.
● Part Description: Include only related parts with descriptions matching or containing this criterion.
● Primary UOM: Include only related parts with primary units of measure matching or containing this criterion.
● Part Scope: Include only Corporate or site parts.
● Part State: Include only related parts that are active at the selected site(s), inactive at the selected site(s), or not assigned to the selected site(s).
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report shows SDSs and their user-defined data. On the report’s Search Criteria page, click Filter on SDS User Defined to choose which user-defined fields appear on the report. You may do any of the following for each field you select:
● Enter no criterion for the field. The report output will show this field for each SDS in the report output, regardless of what (or whether) data is entered for the SDS.
● Enter no criterion for the field and select its Restrict where [user-defined field name] is assigned option. The report output will show this field for each SDS in the report output, but will include only SDSs with data entered in this field.
● Enter a criterion for the field. The report output will show this field for each SDS in the report output, but will include only SDSs with data obeying your criterion entered in this user-defined field.
Note:
When generating this report as a standard Crystal report, select no more
than three user-defined fields. When using the Export to Excel Format
option—which generates the report as a spreadsheet to be exported from
the Crystal Report Viewer into Excel using the Viewer's export () icon—select only one user-defined
field.
Available Criteria:
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● Location: Include only SDSs assigned to these locations.
● SDS User-Defined: Include this user-defined data for the SDSs in the report output and/or include only SDSs with this data assigned. (See above for details.)
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs matching or containing this criterion.
● Language: Include only SDSs of this language.
● Search Corporate: Include SDSs not assigned to your local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● 2-Line Display: Show each SDS's file name, language, and internal ID on the report output.
● Export to Excel Format (1 UDF only): Generate the report output as an spreadsheet designed to be exported to Excel.
● Include Locations: Show the location assignments of each SDS appearing in the report output.
This report lists chosen sites (including with the company and division to which each belongs, if any) and the SDSs assigned to each site, including the date each was assigned to its site, whether it has been archived at its site, whether it has been archived at Corporate, its file formats (text and/or image), and its current state (normal, archived, and so on). In the report output, click an SDS file name to open that SDS in a new window.
Available Criteria:
● Company Name: Include only sites within these companies.
● Division Name: Include only sites within these divisions.
● Site Names: Include only these sites.
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Assigned Date: Include only SDSs assigned to the selected sites on dates obeying this criterion.
● Site Archived: Include only SDSs locally archived at the selected sites or not locally archived at the selected sites.
● Corporate Archived: Include only Corporate-archived SDSs or non-Corporate-archived SDSs.
● File Format: Include only SDSs with SDS files of these types.
● SDS State: Include only SDSs currently in these states.
● Proprietary SDS: Include only proprietary or non-proprietary SDSs.
Available Options:
● Export to Excel: Generate the report output as an Excel file.
● Export as tab delimited file: Generate the report output as a tab-delimited text file.
This report displays a simple list of SDSs and the sites where each is assigned.
Available Criteria:
● Common Name: Include only SDSs with common names matching or containing this criterion.
● Manufacturer: Include only SDSs with manufacturer names matching or containing this criterion.
● Revision Date: Include only SDSs with revision dates obeying this criterion.
● File Name: Include only SDSs with file names obeying this criterion.
● Internal ID: Include only SDSs with internal IDs matching or containing this criterion.
● Language: Include only SDSs of this language.
● Search Corporate: Include SDSs not assigned to your local site.
● Search Archive: Include archived SDSs.
● Search Proprietary: Include proprietary SDSs.
● Search Hidden: Include hidden SDSs.
Available Options:
● 2-Line Display: Show each SDS's file name, language, and internal ID on the report output.
This report shows the user-defined data added to SDSs using user-defined records created at your site. This data includes each user-defined value's record category, record, field name, and value data type (such as String, Numeric, Pick List, and so on).
For details on user-defined records, fields, and pick lists, see Administration: User-Defined Data.
Available Criteria:
● File Name: Include only SDSs with file names matching or containing this criterion.
● Data Category: Include only values entered in user-defined records from categories with names matching or containing this criterion.
● Record Type: Include only values entered in user-defined records with names matching or containing this criterion.
● Field: Include only values entered in user-defined fields with names matching or containing this criterion.
● Value: Include only user-defined values matching or containing this criterion.
Available Options:
● None
