A Custom Report is a customised Microsoft Excel report template. You can use this to generate your own reports on the data in your InfoWorks WS Pro database.
Simulation results can also be exported to Excel via the Custom Report.
Custom Reports are managed in the same way as many other objects in the On-premise and Cloud Database. A Custom Report is stored in a Custom Report Group, so you must create a group first.
The Custom Report is based on a Microsoft Excel file. When the report is first created it must be associated with an existing template. There is a basic example included in the Template directory (below your InfoWorks WS Pro install directory) for this purpose. Files of type .xls, .xlsx or .xlsm may be used as a template. When using versions of Excel 2007 and later: .xls and .xlsx report templates will generate .xlsx reports and .xlsm templates will generate .xlsm reports.
Once the Excel file is associated with a Custom Report, a copy is saved in the Database and you can work with this copy from then on. This makes the reports fully portable.
New reports can be created by:
It is beyond the scope of this guide to explain how to customise the Excel template. When a report is created, the InfoWorks WS Pro data is exported to Excel in a standard format. The best way to see this is to create a simple report and view the results. It is up to you to set up the template to carry out whatever analysis is required on this data. The possibilities are only limited by the features of Excel and your skill in using them.
You can create a new custom report by using the Database tools to copy an existing custom report.
To create a report from scratch you need an Excel file to base it on. A simple example is included in your InfoWorks WS Pro installation.
To generate a custom report:
If you drag the custom report into a network with simulation results, the results will also be exported to the report file. An extra worksheet containing simulation results will be included in the Excel spreadsheet for each type of object.