I would like to create dynamically changing reports from different models using the pivot view and insert them into spreadsheets, is that possible?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Kirjanpito
- Varastointi
- PoS
- Projekti
- MRP
Tämä kysymys on merkitty
3
Vastaukset
7662
Näkymät
In Odoo 17.4 you have the option to insert a dynamically changing pivot table into a spreadsheet and you could also convert it into a static table following these steps:
- After you create your report you can insert it into a spreadsheet:
2. By default pivot tables inserted in spreadsheets will be dynamic. So if I create a new sales order the pivot table will be updated:
3. If you would like to convert it into a static table, then you can highlight the table, right click, and then click on "convert to individual formulas":
4. Now, the table won't be updated dynamically:
Odoo by default creates a dynamic report in spreadsheet. But if any new rows are added in data, it will not be updated.
For this you will have to reinsert the dynamic pivot from data tab in spreadsheet.
Is there any way to directly insert dynamic pivot?
See this movie https://www.youtube.com/live/kpG5WfpSfnE on 8:30.
Works also in V17.
Nautitko keskustelusta? Älä vain lue, vaan osallistu!
Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!
Rekisteröidy| Aiheeseen liittyviä artikkeleita | Vastaukset | Näkymät | Toimenpide | |
|---|---|---|---|---|
|
|
1
marrask. 25
|
3459 | ||
|
2
lokak. 25
|
4601 | ||
|
3
kesäk. 25
|
3150 | ||
|
2
toukok. 25
|
1666 | ||
|
3
huhtik. 25
|
2877 |
