IUCLID 6 includes a Report Generator to extract IUCLID data and to present this data in a user-friendly report. Reports are used in a variety of other business processes, both by industry and by authorities. This feature of IUCLID 6 allows you to create a Chemical Safety Report (CSR) in a printable format (RTF or PDF) or, in XML format, as well as a Summary of Product Characteristics (SPC) report in XML format. You can also generate a printable report of Literature References, of Attachments for Mixture/Products and Substances, as well as a list of Confidentiality claims for Mixture/Products (BPR Article 66).

The Report Generator feature also allows you to manage and generate reports which are not by default available in IUCLID 6. See the IUCLID 6 Help Manual for more information on generating and managing reports.

Creating your own reports

The Report Generator allows the possibility to customise your own report templates and to use these with the Report Generator to extract data from IUCLID’s datasets and dossiers. The Report Generator allows you to define what output options are available for each customised report. Common outputs include:

• CSV
• PDF
• RTF
• XML

In the report manager, you can define additional outputs to those listed above.

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 and upload the relevant report template files.
5. Click ‘Save’.
6. When you come to generate a report, based on your selections above, you will see your customised template and the available output types.

In order to use a quick shortcut to upload a report template and generate a report, follow these steps:

1. Choose the dataset or dossier you wish to generate a report for by selecting it from the Navigation Panel.
2. Press Ctrl +Alt + R to launch the Report Generator wizard.
3. Browse for the report template file which you have downloaded from this IUCLID 6 webpage.
4. Once you have selected the template and pressed ‘Save’, click next in the Report Generator wizard.
5. In the next wizard step you can choose where your report will be saved on your local environment.

You will see the same steps above illustrated in a short document, using the example of the generation of the EU Biocidal Product Regulation (BPR) Summary of Product Characteristics (SPC) XML file.

Report templates

Available report templates (compatible with IUCLID 6.2)

EU REACH Chemical Safety Report (CSR) 7 November 2017	Included in IUCLID	Annex III (Mode of action) New section for additional toxicological effects (chapters 5.10.1.4 & 5.10.3) Based on the new section 13.1 (CSR), use information is printed according to the selection made in field ‘Type of CSR’ Readability improvements (for example, removal of labels when not used, table header colouring)
EU Biocidal Products Regulation (BPR) Summary of Product Characteristics (SPC) 7 November 2017	Included in IUCLID
EU BPR - Confidentiality Report (BPR Article 66) in PDF/RTF formats 7 November 2017	Included in IUCLID	Additional column for ECHA assessment remarks Hyperlink to dossier
EU BPR - Confidentiality Report (BPR Article 66) in CSV format 7 November 2017	Included in IUCLID	Generated as a CSV file Convert to Excel (see here how to do this)
Literature References report for substance and mixture/product datasets and dossiers 6 February 2018	Included in IUCLID	Also compatible with IUCLID v6.1 Hyperlink to dossier BPR Annex II/III requirements
List of attachments for mixture/product datasets and dossiers (in RTF format) 7 November 2017	Included in IUCLID	Hyperlink to dossier BPR Annex II/III requirements
List of attachments for substances datasets and dossiers 6 February 2018	Included in IUCLID	Also compatible with IUCLID v6.1
List of attachments for biocidal mixture/product datasets and dossiers (in CSV format) 7 November 2017	Included in IUCLID but still under development	Generated as a CSV file Convert to Excel (see here how to do this)
Classification and Labelling report (IUCLID section 2.1 GHS) 27 November 2017	Available for download	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 tailored stylesheet
List of annotations for mixtures/products 8 March 2018	Now available to upload into the IUCLID report manager. Ensure that all templates are uploaded, including the stylesheet. Known issue (to be fixed in IUCLID v6.3): If a user has no access to an annotation, then the report cannot be generated.	Report can be generated as an RTF or PDF document
List of use information (created for and by DOW Chemicals) 30 August 2018	Available for download	This report is a CSV file which lists on each row, use information for all life-cycle stages: 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
• Modified stylesheet (.xsl) allowing you to convert the Word document into a landscape format and permits various colours to be included inside the main report template.

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.