Troubleshooting
What goes wrong with Advanced Report Builder, how to recognise it, and what to do.
"You do not have access to X, so this report has nothing to show you"
The person running it cannot read the model. That is Odoo's answer, not the module's - give them access to the model in Odoo, or run the report as somebody who has it.
A colleague sees more rows than I do
That is the module working. Reports are read with each person's own rights.
"%(field)s is not a field on %(model)s"
A column, sort or group-by names something that does not exist on the model, or is not stored. Computed non-stored fields cannot be sorted or grouped by.
"X is not a number, so it cannot be totalled"
Totals apply to integer, float and monetary fields only.
The scheduled report never arrives
Check in this order:
- Last result on the schedule. It says what happened.
- Did it find rows? Empty reports are not sent unless you ask for them.
- Do the recipients have email addresses? A partner with none is skipped, and a schedule with no addressable recipient records that.
- Is Odoo's outgoing mail server working? Try any other Odoo email.
- Is the scheduled action Report Builder: send scheduled reports active?
The report is missing recent records
Check the definition's Filter and Row limit. If the result was truncated the viewer says so.
A relation column shows nothing
The far record may be one the reader cannot see. The read goes through the ORM as them, so an unreadable related record yields an empty cell rather than an error.
Excel shows my numbers as text
It should not - the file receives raw numbers. If you copied from the on-screen table instead of downloading the spreadsheet, you copied the formatted version. Use Download spreadsheet.
Accents are wrong in the CSV
The file is UTF-8 with a byte-order mark, which is what Excel needs. If you are feeding it to a script, strip the BOM or open it as utf-8-sig.
The spreadsheet has an apostrophe in front of some cells
Deliberate. Those cells began with =, +, - or @, which Excel would execute. The apostrophe is invisible in the cell.