In the Data panel, create a CSV data source named Downtime_by_Site. You can copy the data from the Code Block below to create your own CSV Data Source.
CSV Data Source
In the Design panel, drag a CrossTab componentto your report.
With the CrossTab component still selected, drag-and-drop your Data Key (i.e., Downtime_By_Site) from the Key Browser to the Data Key property in the Property Inspector.
In the Key Browser, set the Show Calculations property to true.
Next, add some data keys to the cells in the CrossTab Table component. From the Key Browser, drag the '@Equipment@' to the top cell, '@Site@' to the leftmost cell, and '@count@' to the remaining cell. This will show the downtime count of each piece of equipment by site. In the Design panel, the CrossTab should look like the following:
Switch to the Preview panel and your CrossTab Table will display the results.
In the Data panel, create a CSV data source named equipment_downtime. You can copy the data from the Code Block below to create your own CSV Data Source.
CSV Data Source
In the Design panel, drag a Simple Table componentto your report.
With the Simple Table component selected, drag and drop your Data key (i.e, equipment_downtime) from the Key Browser to the Data Key property of the Property Inspector.
From the Key Browser, drag the '@equipment@' key to the top row of the Simple Table, and the '@downtime@' key to the second row.
Note: The data keys determine how many columns and rows get created in your table. The Simple Table will add a new column for each value in the 'equipment' key.
It's important to note that the top row of the Simple Table is a Header Row. In the Property Inspector, there is one Header Row, but you can always add more rows by changing the value, or even setting it to '0' to remove the Header Row.
In the Property Inspector, change the number of Rows and Columns to 1. If you need to add or remove columns or rows, you can always change the Column and Row property values.
The Simple Table will look like the following image in the Design panel.
Next, switch to the Preview panel to check out your report. You can always go back to the Design panel to edit your table and update your report format.