There are no canned reports related to waste management records. Use Report Writer subqueries to create metrics that can be analyzed in the Data Cube, as follows:
Create the subquery - use the provided Waste Metrics Subquery or clone it to create your own. If you are creating a subquery for use in a custom measure:
- the first column must be a number field (e.g. Amount)
- the second column must be a date/time field
- subsequent columns must be the GDDLOFB ID fields, in that order)
Note that the Subquery field is not available on default custom measure layouts.
For more information about creating Report Writer queries, see Editing or Creating an Ad Hoc Report in Report Writer.
Create a custom layout for custom measures to add the Subquery field. For more information, see Defining Form Layouts.
Associate the subquery to a new or existing custom measure. For more information, see Setting Up Custom Metrics.
When the custom measure is linked to the subquery and saved, individual metrics records are created from the waste management record and listed on the Completion/History tab.
The custom measure is available for use in the Data Cube as usual. For more information, see Using the Data Cube.