# Report Builder on Dashboards: a Report's Total as a Tile

> A dashboard tile or KPI can show the grand total of any Report Builder report, with its fixed conditions and questions as saved. It installs by itself once Report Builder and Dashboard Builder are both there.

- **What it is:** A dashboard tile or KPI can show the grand total of any Report Builder report, with its fixed conditions and questions as saved. It installs by itself once Report Builder and Dashboard Builder are both there.
- **For:** Productivity
- **Odoo versions:** 17.0, 18.0, 19.0, 20.0 - Community and Enterprise
- **Runs on:** Odoo.sh or Odoo you host yourself - not Odoo Online, which accepts no third-party apps
- **Price:** 307 EUR, one-time, on the Odoo Apps Store
- **Technical name:** bambooforge_report_builder_dashboard
- **Not for:** It shows one number, the grand total. It does not show a row, a table or a chart of the report.; It reads the report's standard layout, with the fixed conditions and the answers saved in it. The item's own filter and the dashboard's date filter are not applied.; Compare With Previous Period on a KPI has no earlier figure for a report total: the report is not computed again for the period before.; A chart, a list or a map takes no report total.
- **Manual:** https://docs.bambooforge.dev/bambooforge_report_builder_dashboard/
- **Live demo:** https://demo20.bambooforge.dev/odoo/action-bambooforge_dashboard.dashboard_board_action
- **Store page:** https://apps.odoo.com/apps/modules/20.0/bambooforge_report_builder_dashboard
- **Manual last updated:** 2026-11-10

---
# Report Builder on Dashboards: a Report's Total as a Tile

A report built with Report Builder already holds a number: the records that
count, its fixed conditions, the answers saved with it and its computed
columns. This add-on lets a tile or a KPI of Dashboard Builder show that
number, the grand total of one column of the report. One number, defined
once.

## Overview

**For whom.** Whoever builds boards in Dashboard Builder and already keeps the company's figures as Report Builder reports. Odoo 17 to 20. It needs Report Builder and Dashboard Builder, and installs by itself when both are there.

### What it does

- Adds the choice *A Report Builder total* to the *Data Type* of a dashboard item.
- A tile or a KPI set to it shows the grand total of one column of the report you pick: the first visible column, or the one whose key you give.
- The number is computed with the reader's own access each time the dashboard computes the item. A reader who may not open the report sees 0.
- Picking the report sets the item's *Model* to the model the report reads.

### What it does not do

- It shows one number, the grand total. It does not show a row, a table or a chart of the report.
- It reads the report's standard layout, with the fixed conditions and the answers saved in it. The item's own filter and the dashboard's date filter are not applied.
- *Compare With Previous Period* on a KPI has no earlier figure for a report total: the report is not computed again for the period before.
- A chart, a list or a map takes no report total.

### What it needs

- Report Builder Pro (`bambooforge_report_builder`) and Dashboard Builder (`bambooforge_dashboard`). Dashboard Builder itself needs Sales, CRM, Odoo's Dashboards app and Partners Geolocation.
- No Enterprise module, no extra Python package and no outside service.
- The add-on adds no menu, no group and no access rule. A dashboard administrator sets the item up, and the report decides who gets a number.

## Concepts

**Report total.** The grand total of one column of a Report Builder report: the *Total* row of its total column, in the report's standard layout.

**Column key.** The short name a number or a computed column has in the report's design, such as `revenue`. *Columns Available* lists the keys of the report you picked.

**Dashboard item.** A tile or a KPI on a board of Dashboard Builder. Its *Data Type* says where its number comes from.

## Install and first run

There is nothing to install by hand and no menu to open: the add-on adds one choice and three fields to the form of a dashboard item.

1. Install Report Builder and Dashboard Builder. Expected: this add-on is installed with them. In *Apps*, take the *Apps* filter off the search to see it.
2. Open *Dashboards > Dashboard Pro*, open a board and press **Add the Charts**. The button shows to dashboard administrators: on the user's form, *Dashboard* set to *Admin*. Expected: the form of a new item opens.
3. Give a name, keep the type *Tile* and pick any *Model*. Expected: *Data Type* shows under *Computation*.
4. Set *Data Type* to *A Report Builder total* and pick a *Report*. Expected: *Model* changes to the model the report reads, and *Columns Available* lists the report's visible columns, each as key (label).
5. Leave *Column* empty for the first visible column, or type a key from *Columns Available*. Save. Expected: the tile on the board shows the report's grand total for that column.

## Flows

One screen, the form of a dashboard item, and two kinds of item that use it.

### A tile that shows a report's total

On the item's form, under *Computation*:

- *Data Type*: *A Report Builder total*.
- *Report*: the report the number comes from. You pick an existing report: none can be created from here.
- *Column*: the key of the column whose grand total shows. Empty means the first visible column.
- *Columns Available*: the visible columns of that report, each as key (label).

Saving refuses a key the report does not have, and names the keys it has.

### A KPI on a report's total

Choose the type *KPI* and fill the same four fields. *Enable Target* and *Standard Target* work on the report's total as on any other KPI number.

## How it works

**When the number is computed.** Each time the dashboard computes the item, the report runs in its standard layout, with its fixed conditions and the answers saved in it, and with the access of the person looking. The item shows the *Total* row of the report's total column for the chosen key.

**What a reader without access sees.** 0, not an error. A report the reader may not open, or whose records the reader may not read, gives the item no number.

**Without a reader.** A KPI alert and a scheduled snapshot of Dashboard Builder read the same number as the system, which no access rule limits.

**What is written where.** The item keeps the report and the column key. Deleting the report empties the item's *Report*, and the item shows 0. Nothing is written on the report.

**Uninstalling.** An item set to *A Report Builder total* goes back to *Count*, and the three fields are removed.

### How we make sure it works

Before every release, **6 automated checks** run against this app on Odoo 17, 18, 19 and 20.
Among them:

- A column the report does not have.
- The tile shows the reports total.
- Other tiles are untouched.

The complete list is in the source you receive.

## For managers

This add-on has no analysis, report or printout of its own. Its figure shows on the dashboard: on the tile or the KPI that reads the report, and in the alerts and snapshots Dashboard Builder makes of that item.

## Reference

The complete reference of this add-on, the fields it adds with their help text and the view it extends, is generated from the code on every release and published with this manual at https://docs.bambooforge.dev/bambooforge_report_builder_dashboard/ under *Reference*. It is not written by hand, so it cannot drift from what the module installs.

## Troubleshooting and FAQ

****"... takes its number from a report: pick the report."****

The item's *Data Type* is *A Report Builder total* and no *Report* is chosen. Pick one, or choose another *Data Type*.

****"... has no column ...; it has ..."****

The key under *Column* is not one of the report's. Copy a key from *Columns Available*, or empty the field for the first visible column.

****The tile shows 0.****

The reader may not open the report or read its records, the report was deleted, or the key under *Column* belongs to a number that is hidden in the report's design. Check *Visible To* on the report, and choose a column from *Columns Available*.

****The number does not follow the dashboard's date filter.****

It is the report's own total. Give the report a period in its design, such as *This month*, and save it as standard: the tile then follows the calendar.

****Data Type does not show.****

The form shows it once a *Model* is picked. Pick any model: choosing the report replaces it.

### Support

Write to [support@bambooforge.dev](mailto:support@bambooforge.dev). Questions, bug reports and feature requests are answered by the developers who wrote the module.

## Changelog

Newest first. The same entries are on the app's store page.

### 20.0.1.0.1

- A KPI can take its number from a report: *Report*, *Column* and *Columns
  Available* show under the KPI's *Data Type* as they do under a tile's. They
  stood on the tile's form alone, and a KPI set to *A Report Builder total*
  asked for a report its form did not show.
- The key of a column the report hides is refused, with the keys that can be
  picked. It was accepted, and the tile showed 0.
- *Data Type*, *Report* and *Columns Available* explain themselves in their
  help text.
- The add-on has a manual of its own.

### 20.0.1.0.0

First release: a dashboard tile takes its number from the grand total of a
Report Builder report.


## Reference

Generated from the module's own code (version 20.0.1.0.1, series 20.0) on 2026-11-12; every menu, field, setting, scheduled action, group, rule, report and endpoint below is read from the files, not written by hand.

### Models

#### bambooforge.dashboard.item (extends bambooforge\_dashboard's bambooforge.dashboard.item)

| Field | Technical name | Type | Help | Flags |
|---|---|---|---|---|
| Record Count Type | `record_count_type` | Selection: adds A Report Builder total (bf\_report) | How the item gets its number. Count counts the records, Sum and Average read one field, Python Code computes it with code you write. A Report Builder total takes the grand total of one column of the report picked below; the item's own filter and date filter do not apply to it. |   |
| Report | `bf_report_id` | Many2one to bf.report | The Report Builder report the number comes from. Picking one sets the Model to the report's own and the Data Type to A Report Builder total. A reader who may not open the report sees 0. |   |
| Column | `bf_report_measure` | Char | The key of the report's column whose grand total the tile shows. Empty: the first visible column. |   |
| Columns Available | `bf_report_columns` | Char | The visible columns of the report picked above, each as key (label). Copy a key into Column. | computed |
