Custom Report Configuration
This article will help you with creating more meaningful and presentable reports to help support you during the decision-making process on projects. The Report Designer allows for grouping, sorting and using charts to be able to display model data concisely and accurately. As an example, we will look at creating a basic multi-level grouped report.
In the example picture of the model, a MEP component is selected along with the relevant data tab showing the Component Item and the Level Location. These will be our main properties to group by to produce a report listing quantities of Components for each Level Location.
Sample item selected showing data to report by.
Go to General Configuration tab in the iConstruct menu and click Export Configuration button.
Select an item in the background and click Get NW Props icon to pull in the data.
Select Object Type to read data from the model (Link Items with Groups in our example).
Choose Report as a Template Type from drop-down menu.
Select properties from Fields to Add to Export.
Save the Template.
Run Report Designer. The default report prototype will appear.
To set the initial logo (if not selected in the Template editor) click the top left image box, then click the Image property under Data and select an image.
In its initial form, the report will just output each item as a separate row (example below). To add a group, or to sort by a specific field click on the Add a Group or Add a Sort buttons. When Add a Group is clicked, a sub-menu showing the available fields to Group By is displayed, in this case ‘Level Location’ is clicked and the Grouping level is displayed.
At this time a GroupHeader1 band is also added to the report – this can be switched off/on or add a footer using the Show Header or Show Footer checkboxes.
Note: the original fields are still all in the detailBand1.
To create a group header, drag and drop the relevant header field from detail band into the group header (in this case Level Location). This will group the report by Level Location, which is acceptable for some reports but in this case the report is to sum quantities by Furniture Group, so in this case an additional grouping level is added for Component Group and both fields are moved from detail band to the new group header.
Tip: Use Preview to check the report with values.
Also Component Group is copied for us to change the Sum field for. To sum by group, first click the field box then the > box that appears above it. Then click the Summary Running and change to Group. Next change the Summary Func to Count as the intent is number of (if for total mass SUM would be the chosen function).
The final report, after minor formatting change to highlight the groups (select field and change the Background Color).
Note: this report picks up items not categorized by a Level Location, hence the empty first header row.
Save the changes.
Go to General Configuration tab ➤ Click Export Configuration ➤ Select an item in the background ➤ Click Get NW Props ➤ Select Object Type ➤ Choose Template Type ➤ Select Fields to Add to Export ➤ Save the tempalte ➤ Run Report Designer ➤ Create the Report ➤ Save