Stockpile Quality Report
The Stockpile Quality report displays the balance and quality for a number of stockpiles at a point in time.
The report definition is stored in the StockpileQuality.xml file.
Parameters
The Stockpile Quality report contains the following default parameters:
|
Name |
Default Type |
Required |
Description |
|---|---|---|---|
|
Date |
Date/time picker |
Y |
Determines the date at which the balance and quality of the stockpiles are queried. |
|
Area |
Single-select list |
Y |
Determines the items available in the Location drop-down list. |
|
Location |
Multi-select list |
Y |
The locations to report on. |
|
Stockpile |
Multi-select list |
Y |
The stockpiles to report on. The drop-down list only displays stockpiles for the selected locations that are open at the selected date. |
|
Product |
Multi-select list |
Y |
The products to report on. The drop-down list only displays products for the selected stockpiles at the selected date. |
|
Analyte Group |
Single-select list |
Y |
The analyte group to report on. A maximum of 10 columns can be displayed in the report. If an analyte has content data available, the content is also displayed. (This means that that analyte will use two columns in the report.) |
|
Basis |
Single-select list |
Y |
Displays the tonnage in the selected basis. |
Report View
The Stockpile Quality report is made up of three sections:
- Logo
- Parameters
- Main Report
Logo
The logo is retrieved from the organisation or company specified as the Logo Organisation for the BTLogo data table in the report configuration.
If no Logo Organisation is selected, the logo is retrieved from the organisation or company with an Alias2 of 'SITE'. If no such organisation or company exists, or if the organisation or company with Alias2 of 'SITE' does not contain a logo, the Datamine logo displays on the report.
Parameters
A list displays of the report parameters for which a value has been entered.
Note: Parameters can be configured to be hidden in the report header. This can create more space for the rest of the report.
Main Report
The report contains the stockpile balances, grouped by location. Each location group has a total row, with a grand total row at the end.
Location Grouping
Each Location Grouping displays the following columns.
|
Column |
Description |
|---|---|
|
Stockpile |
The name of the stockpile. |
|
Tonnage |
The stockpile’s closing balance at the selected date, in the selected basis. |
|
Product |
The name of the stockpile’s product at the selected date. |
|
<Analytes>, <Analyte Content> |
The remaining columns are the analytes (and analyte content if applicable) in the selected analyte group, up to a maximum of 10 columns. If the stockpile’s closing state contains the analyte, the analyte value displays, rounded to the number of places specified in the analyte definition. If the stockpile does not contain the analyte, a value of zero displays. If the analyte is configured to show the content basis, this displays in a separate column per analyte. The analyte content is in the configured mass unit of measure for that analyte. |
Total Row
The Total row for each location displays the total tonnage for the stockpiles, the weighted average value for each analyte, and the total analyte content, if applicable. Any stockpile analytes with a value of zero are not included in the weighted average calculation.
Grand Total Row
The Grand Total row displays the total tonnage for all stockpiles in the report, the weighted average value for each analyte, and the total analyte content, if applicable. Any stockpile analytes with a value of zero are not included in the weighted average calculation.
