Report generator

IUCLID 6 includes a Report Generator to extract IUCLID data and to present this data in a user-friendly report format such as PDF or RTF, or in machine-readable format such as CSV or XML. These reports are used in a variety of business processes by industry and assessing authorities. Reports are typically generated from single IUCLID 6 datasets and dossiers.

Many reports are ready to use and made available by default inside IUCLID 6, and can be generated using the Report Generator wizard. The Report Generator also allows you to upload other reports which are not currently available by default, inside of IUCLID 6. See the IUCLID 6 Help Manual for more information on generating and managing reports.

In the table of available report templates below, you will see an indication in the ‘Status’ column if the report template is included by default in the latest version of IUCLID 6. Examples of reports available in IUCLID 6 include the Chemical Safety Report (CSR), which can be generated in RTF or PDF formats as well as in XML format, and a Summary of Product Characteristics (SPC) report which can be generated in XML format and can be uploaded into SPC Editor.

Currently, the IUCLID web user interface only allows the generation of the Chemical Safety Report, but will be extended to include all default reports by April 2019. The Report Manager feature, allowing you to upload your own customised reports, is planned for October 2019. All Report Generator/Manager features continue to be available in the ‘classic’ IUCLID 6 interface.

Creating your own reports

The Report Generator allows you to customise and manage your own report templates and to use these with the Report Generator to extract data from IUCLID’s datasets and dossiers. The IUCLID team can help you to create your own report templates, and provide the necessary technical and business support. Use the IUCLID functional mailbox to contact us with any such request.

Typically, we recommend the creation of customised report templates when:

  • There is a set of structured IUCLID data which you repeatedly have to use in your business processes, such as study summary data, use information, or composition data.
  • You want to regularly send IUCLID data in a readable format to other organisations.
  • There is another IT system which you feed IUCLID data in to and which you wish to have ready in machine-readable format, such as XML or CSV.

In order to upload and manage a report template, follow these steps:

  1. Left-click on the Report generator icon on the IUCLID dashboard.
  2. Click on ‘Manage reports’, which then opens the Manage reports box.
  3. Click ‘Add’ in the bottom left-hand corner of the Manage reports box.
  4. Fill in the various details of your report:
    1. Name of the report
    2. Upload the report templates (assign which template is the ‘main’ template)
    3. Output formats which the report is compatible with
    4. Add a stylesheet if needed
    5. Select if your report is compatible with Substances and/or Mixtures (note that report generation for Categories is not yet supported)
  5. Click ‘Save’.

When you come to generate a report, based on your selections above, you will see your customised template and the available output format types.

Report templates

Available report templates (compatible with IUCLID 6.3)

You can download all report templates that are compatible with IUCLID 6.2 from here.

Report template Date Status Highlights Preview

REACH Chemical Safety Report (CSR)

24.10.2018 Included in IUCLID 6.3
  • Readability improvements
  • The hash sign [#] indicating a link to an Annex has been replaced by a relevant string text.
  • A hyperlink has been made between each study summary linked to an assessment entity and the assessment entity description.
  • Chapter 1: The information related to the physicochemical properties has been reorganised in the related table in order to improve its readability. 
  • Chapter 3: Classification according to GHS is now correctly printed.
  • Chapter 4: The information related to the endpoint summaries 5.3.1 and 5.3.2 is now also reported even if the summary in section 5.3 is not available.
  • Chapter 5: In vitro skin irritation – data waiving information is now correctly displayed when needed.  

EU Biocidal Products Regulation (BPR) Summary of Product Characteristics (SPC)

24.10.2018 Included in IUCLID 6.3  

EU BPR - Confidentiality Report (BPR Article 66) in PDF/RTF formats

24.10.2018 Included in IUCLID 6.3  

EU BPR - Confidentiality Report (BPR Article 66) in CSV format

24.10.2018 Included in IUCLID 6.3  

Literature References report for substance and mixture/product datasets and dossiers

13.11.2018

Included in IUCLID 6.3

(Update available)

  • The Literature reference report can now handle exceptionally large datasets and dossiers, and generate without failure

List of attachments for mixture/product datasets and dossiers (in RTF format)

24.10.2018 Included in IUCLID 6.3
  • The attachment in the dossier header is now included in the report

List of attachments for substances datasets and dossiers

24.10.2018 Included in IUCLID 6.3
  • The attachment in the dossier header is now included in the report

List of attachments for mixture/product datasets and dossiers (in CSV format)

24.10.2018 Included in IUCLID 6.3
  • The attachment in the dossier header is now included in the report
  • The occurrence of line breaks has been fixed and the report now generates without line breaks

Classification and Labelling report (IUCLID section 2.1 GHS)

24.10.2018 Included in IUCLID 6.3 (New)
  • Includes a tailored stylesheet
  • Includes all C&L information, in addition to:
    • Substance identity information
    • An indication of whether the linked composition has impurities or additives which are relevant for the classification and labelling of the substance

List of annotations

24.10.2018

Included in IUCLID 6.3 (New)

  • Report can be generated as an RTF or PDF document
  • Report can only be generated from a Mixture/Product, and includes all linked Substances, e.g. active substances

List of use information (created for and by DOW Chemicals)

30.08.2018 Available for download only
  • A CSV file which lists on each row, information about the use life cycle:
    • Manufacture use
    • Formulation or re-packing use
    • Use at industrial sites
    • Use by professional workers
    • Consumer use
    • Article service life
  • The report also includes substance identifiers (CAS number, EC number), as well as the UUID of each use document.
  • This CSV file is designed to be uploaded into another system so the use of substances (alone or in products), can be tracked and monitored.

Creating your own report templates

IT developers, or users with a certain level of IT skills, can create their own report templates in order to generate reports based on IUCLID data, using the IUCLID 6 Report Generator.

Basic instructions are made available together with a few examples:

  • DocBook report template example (.ftl)
  • XML report template example (.ftl)
  • Test IUCLID 6 dataset (.i6z)

Stylesheets

When creating your own report templates, you can also upload your own stylesheet (.xsl) file into the Report Generator which adds extra formatting conditions to the .rtf output. Here are two stylesheets which you can use as a basis for creating your own stylesheets:

  • Default IUCLID stylesheet (.xsl) used with the CSR report
  • Two modified stylesheets (landscape and portrait in .xsl) which converts a RTF or PDF document into a landscape or portrait format accordingly, as well as permitting different text colours and table cell colours.

Sharing your report templates

If you wish to share the templates you have customised and potentially have these published on the IUCLID 6 website, please contact ECHA through the IUCLID functional mailbox.

Categories Display