You are currently reviewing an older revision of this page.
Is it possible to create a report for multiple elements instead of individually?
Because of the way the database is set up, there is no direct way of doing this. There is a feature request in to allow for something like this. For now, you may be able to use ModelBuilder to try to have the fields you want reported exported into the same file.
ModelBuilder has a Sync Out function that can be used to export data back into a source file, such as an Excel spreadsheet.
To use this, you would need to create an Excel spreadsheet with the formatting would like. For instance, you would need to have a worksheet for each element type. In each worksheet, you would set up columns for each of the fields in the element flextables and place the name in of the field in the first cell. You can also create worksheets for each element types, such as junction, pipes, etc.
Next, you would need to create a Modelbuilder connection to this spreadsheet. There is a TechNote created that already covers these steps. This TechNote can be found at the following link:
http://communities.bentley.com/products/hydraulics___hydrology/w/hydraulics_and_hydrology__wiki/2822.aspx
The TechNote uses a specific data source type as an example, but the steps will be similar for an Excel spreadsheet. You would select the spreadsheet as the data source type.
You can follow the steps in the TechNote above until you get to the Field Mapping Section.
Once you get to the Field Mapping step, you will need to assign the Key Field as the element label column and assign the appropriate element properties to the correct columns in the spreadsheet in the section on the lower left.
Assuming that you create use a worksheet for each element type, you will need to do this for each worksheet. You will see a list of worksheets in the Excel spreadsheet on the left side of the Modelbuilder dialog.
NOTE: Excel spreadsheets have a default of three active worksheets. If you are syncing out less than three element types, you will need to remove the extra worksheet(s) from the spreadsheet or deselect the worksheets in the first step of Modelbuilder.
Once you have select all of the properties you want to export for all the element types, click Next. Select "No" for the selection about building the model. Then click "Finish."
Once this is done, you will be back at the Modelbuilder manager. Click the Sync Out button and the Excel spreadsheet should be populated with the the data from the model file.
Updating Source File Using Model Builder [TN]