Operating Instructions

Reports

Viewing a Report as a PDF or XLS

Siemens Desigo™ CC Getting Started A6V10415475_en_a_21

Building Technologies 2015-06-30

Excel (XLSX)

You can view and save the report output as an Excel (XLSX) document. An Excel

document contains all of the reporting elements of the Report Definition with output

data and user defined configuration (if applied). Form Controls (if present) in the

report definition are not present in the Excel document. Any special formatting

applied to the Report Definition elements are not retained in the Excel document.

If you have multiple tables or plots in a report definition, then the generated Excel

document displays the details of each table or plot in a separate worksheet. Each

worksheet also displays information on other reporting elements such as keywords

and logos (if present) in the report definition. Each column in the worksheet has a

combo box that corresponds to a table column that enables you to perform analysis

on the table data. In case of an Event Details table the generated Excel document

does not have any combo boxes as the data displays parent and child records.

However, if you remove the child columns from the

Select Columns dialog box, run

the report, and then generate the Excel document, only the parent records display

and the columns display a combo box that enables you to perform data analysis.

In order to perform analysis on a specific set of columns in a table, you can add a

PivotTable or chart to the generated Excel document and set this document as a

template to the report definition having this table. When you run the report and

generate the Excel document, information related to the columns you added to the

PivotTable or chart displays in a separate worksheet.

The PivotTable or chart in the template must have columns of only those tables

that are present in the report definition. For example, if you have a report definition

with an All Logs table, the PivotTable or chart in the Excel document that is set as

a template to this definition must have columns specific to the All Logs table only.

In case of an Event Details table, you must remove all the child columns for the

PivotTable to be displayed.