Docs › Productivity › Report Builder on Dashboards: a Report's Total as a Tile

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.
bambooforge_report_builder_dashboardKey facts
- 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 last updated
- 2026-11-10
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.
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.
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.
Give a name, keep the type Tile and pick any Model. Expected: Data Type shows under Computation.
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).
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.
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. 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 |