I am busy working on customizing a report in Bentley Substation. Currently i have managed to customize the report to output all the parts used in a project, quantity and cost them. Now i am looking to further customize the report to break it down per discipline (i.e. structures, foundations, equipment etc.) - see below.
The problem that i am finding is that it i cannot apply a filter under the field column to select "Discipline". Why is this the case?
All comments or suggestions will be welcomed.
Hi Mohammad. Reports can only be filtered using the fields that are present in the query on which the report template is based. Such fields can be seen in the Field List > Data Fields area of Report Template Designer when the template is open. I would guess that Discipline is not included in the report template/query and so you cannot use that field for Filtering.
To add a field that is not available in the Data Fields area when modifying the template, you would need to create a custom SQL query and base a new template on that custom query. This may or may not be feasible, depending on the field and base query. What existing report template or Predefined Report Type was used as a basis for your custom template?