Home > SI 2018 Documentation > User Guide > Reports > Report Designers > Excel Report Wizard > Manually Create Excel Reports

Manually Create Excel Reports

Table of contents

SI 2018 Page.png

Details

 

These reports can be created in Excel 2016, 2013, or 2010. These instructions are written for Excel 2010.

 

Excel reports can be run for up to five Projects at a time.

 

These reports can not be set to automatically aggregate or total. If you want these features, use the Excel Report Wizard.

Steps

 

  1. Open Excel and verify that you have the Developer tab in the ribbon displayed. To turn this on, click File->Options then check the Developer option:

 

developer option.jpg

 

  1. Click the Developer tab and then click Source:

 

File:SIX_Guide/008_Reports/004_Report_Designer/Excel_Report_Wizard/Excel_Reports/source.jpg

 

  1. In the XML Source window, click [XML Maps...]:

 

File:SIX_Guide/008_Reports/004_Report_Designer/Excel_Report_Wizard/Excel_Reports/xml_maps.jpg

 

  1. In the XML Maps window, click [Add...]:

 

File:SIX_Guide/008_Reports/004_Report_Designer/Excel_Report_Wizard/Excel_Reports/xml_maps_form.jpg

 

  1. In the Select XML Source window, copy and past the following in the "File name" field and click [Open]:

 

 

http://downloads.d-tools.com/SIX/Reports/Schemas/DToolsReport2010.xsd

 

 

File:SIX_Guide/008_Reports/004_Report_Designer/Excel_Report_Wizard/Excel_Reports/select_xml_source.jpg

 

  1. In the Multiple Roots window, select "DToolsReport" and click [OK]:

 

File:SIX_Guide/008_Reports/004_Report_Designer/Excel_Report_Wizard/Excel_Reports/multiple_roots.jpg

 

  1. Click [OK] on the XML Maps form:

 

File:SIX_Guide/008_Reports/004_Report_Designer/Excel_Report_Wizard/Excel_Reports/xml_maps_form_2.jpg

 

  1. The XML Source window will now be populated with all of the fields available to you for your report:

 

File:SIX_Guide/008_Reports/004_Report_Designer/Excel_Report_Wizard/Excel_Reports/xml_source_populated.jpg

 

  1. Drag over the desired fields to Excel cells:

 

File:SIX_Guide/008_Reports/004_Report_Designer/Excel_Report_Wizard/Excel_Reports/drag_xml_nodes.jpg

 

  1. When done, Save and name the Excel file:

 

save excel report.jpg

 

  1. In the Report Explorer, click the Excel button on the Ribbon:

 

import excel button.png

 

  1. On the Add Report form, fill in a Name, Description, select a Category, and Browse to where you saved your Excel file, then click [OK]:

 

import excel report form.png

 

The Excel Report will display in the Category you selected:

 

report in list.png

Last modified

Tags

This page has no custom tags.

Classifications

This page has no classifications.