This article gives specific steps to add a grand total to the Asset by Location Report, following the instructions in the AssetCloud Custom Report FAQ linked below.
- Reports, All Reports, Asset Reports, Asset by Location Report
- Design Report
- From the Insert tab's toolbar, drag a Footer down between FooterBand1 and the next darker band. A new band called FooterBand2 appears.
- From the Insert tab's toolbar, drag a Text object onto the report into FooterBand2.
- In the Text design window that appears, click on Summary at the right. Skip over the large text field, and set these values in the next 3 lines:
Summary Function: Sum
Data Band: Section 8
Data Column: Click in the box. Expand SpAssetInfo, double-click asset_inv_quantity. This will show as SpAssetInfo.asset_inv_quantity in the field.
If desired, position the text object, and use the Properties pane at the left to adjust formatting. By default, the value on the report will show 4 decimal places. To change that, in Text Format, click the ... button next to General, then Number, check the box for Decimal Digits, set the value to something like 2 or 0, OK.
When you're done editing, click File, Save. Click into the browser tab called Reports, and click Run Report. On the last page, there is a grand total of all the Quantity that appears in the report.