User Guide

Reports
9
Creating and Viewing a Report as a PDF or Excel
289
Siemens User Guide Version 2.1
A6V10415471_en_a_21
Building Technologies 2015-07-15
9.15.2.2 Generating an Excel Document with a Template
 You have created a report definition, run it, and it displays in the Run mode.
 Microsoft Excel 2007 or later is installed on your system.
1. In the Reports toolbar, click Create and view Excel .
 An Excel file is created and stored at the following temporary location on
your machine
[Drive]:\Users\[UserID]\AppData\Local\Temp\temp\GMS. A
dialog box displays asking you to save a copy of this file on your machine,
open the file from the temporary location, or cancel the procedure to open
or save the file.
2. Open the Excel file by clicking Open in the dialog box. If you have Internet
Explorer 10.0 or higher on your machine the Excel file opens outside the
Reports Workspace. However, in systems having lower versions of Internet
Explorer, the Excel file opens in the Reports Workspace. In such cases, you
must open the Excel file by navigating to the temporary location of your
machine. You can also open the saved copy of the Excel file from your
machine.
NOTE:
If you are opening the file from the temporary location, you must first ensure
that you save a copy of this file at a different location on your machine and
proceed with the further steps on the saved copy.
3. Open the worksheet with the table information in the saved copy of the Excel
file and select a row with data.
4. From the Insert menu, select the PivotTable option.
 The Create PivotTable dialog box displays.
5. Select the Select a table or range option and specify the table details.
6. Select the New Worksheet option in the Choose where you want the
PivotTable report to be placed and click OK.
 A new worksheet is added to the Excel document with the PivotTable
options.
7. From the PivotTable Field List, select the columns to be added to the
PivotTable.
 The selected columns are added to the worksheet.
8. (Optional) Re-organize the columns as per your requirement in the Drag fields
between areas below section in the PivotTable Field List.
 Any changes you make in this section, reflect in the worksheet.
9. Select any row from the PivotTable, right click, and then select PivotTable
Options.
 The PivotTable Options dialog box displays.
10. Select the Data tab.
11. In the PivotTable Data section, clear the Save source data with file check box
and select the Refresh data when opening the file check box.
12. Click OK.
13. Delete all the sheets in the Excel document, except the sheet having the
PivotTable configuration.
14. Save the Excel document.