Home > SIX 2013 Documentation > User Guide > Reports > Report Designer > Excel Report Wizard

Excel Report Wizard

Feature

 

The Excel Report Wizard will guide you through creating custom Excel reports.

What are the benefits of this feature?

 

Excel reports created through the Excel Report Wizard can have columns and rows aggregated and totaled.

When to use this feature?

 

When you want to create a custom Excel report.

Details

 

These reports can be created if you are using Excel 2007 or 2010.

 

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

Steps

 

  1. Click Start->Reports->Manage Reports to open the Report Explorer:

 

File:SIX_Guide/008_Reports/004_Report_Designer/Excel_Report_Wizard/manage_reports.jpg

 

  1. Click the [Excel] button in the Create section of the ribbon:

 

File:SIX_Guide/008_Reports/004_Report_Designer/Excel_Report_Wizard/excel_button_on_ribbon.jpg

 

  1. The New Excel Report Wizard will open. Name the report and give it a description. Choose between "Simple" and "Advanced". Click [Next].

 

erw step 1.jpg

 

  1. Depending on what option you chose, Step 2 of the wizard will look like one of the interfaces below. In either case, choose the fields you want to add to the report by using the left and right arrows, then put them in the order you want using the move up/down arrows. Click [Next].

Simple

 

erw step 2.jpg

 

The Simple option list commonly used fields and are organized by the purpose of the fields.

Advanced

 

erw step 2 advanced.jpg

 

The Advanced option lists every field available to you, similar to what you will find in our Standard Report Designer's Data Explorer.

 

  1. On Step 3 of the wizard, you will choose your aggregation and summarization options. Click [Next].

 

erw step 3.jpg

 

None - No aggregation will be performed. Use this if you want all products to list individually, e.g. a wire list report.

Automatic - This is the default selection. SIX will select the fields to aggregate and summarize. We recommend this option.

Advanced - You will select which fields to aggregate and which to summarize.

 

If you choose Advanced, you the next step will allow you to choose which fields to aggregate on on rows and columns, and which fields you want to summarize:

 

erw step 4 advanced.jpg

 

On either of the other two options you will see a summary of what will be aggregated/summarized. In the example, "Automatic" was selected:

 

erw step 4 automatic.jpg

 

  1. Click Finish and you will be prompted whether or not you want to publish your report to your server. If you do not wish to do this, you can always do this later via our Export Reports option.

 

File:SIX_Guide/008_Reports/004_Report_Designer/Excel_Report_Wizard/publish_to_server_prompt.jpg

 

When finished, your report will display in your Excel Reports list:

 

File:SIX_Guide/008_Reports/004_Report_Designer/Excel_Report_Wizard/published_report.jpg

Last modified
16:39, 31 Jul 2014

Tags

This page has no custom tags.

Classifications

This page has no classifications.