[Skip to content](#main)

[→](/)

[![Avunu](/brand/avunu-logo.svg)![Avunu](/brand/avunu-logo-light.svg)](/)[Services](/services/)[Consulting](/services/consulting/)[ERP](/services/erp/)[Odoo](/services/erp/odoo/)[ERPNext](/services/erp/erpnext/)[Custom software](/services/custom-software/)[Devices & IoT](/services/devices-iot/)[Websites](/services/websites/)[Infrastructure](/services/infrastructure/)[Partners](/partners/)

[Work](/work/)[Open source](/open-source/)[Knowledge base](/kb/)[About](/about/)

[About Avunu](/about/)[Team](/about/team/)[Insights](/insights/)[Contact](/contact/)

[Client portal](https://erp.avunu.net/projects)[Start a project](/start/)

- [Services](/services/)[Consulting](/services/consulting/)
- [ERP](/services/erp/)
- [Odoo](/services/erp/odoo/)
- [ERPNext](/services/erp/erpnext/)
- [Custom software](/services/custom-software/)
- [Devices & IoT](/services/devices-iot/)
- [Websites](/services/websites/)
- [Infrastructure](/services/infrastructure/)
- [Partners](/partners/)

[Work](/work/)[Open source](/open-source/)[Knowledge base](/kb/)[About](/about/)

- [About Avunu](/about/)
- [Team](/about/team/)
- [Insights](/insights/)
- [Contact](/contact/)

[Client portal](https://erp.avunu.net/projects)[Start a project](/start/)

[Knowledge base](/kb/)[Frappe](/kb/frappe/)Script Reports

Search the knowledge basePress/

ESC

Jump to

[Browse the knowledge base](/kb/)[Frappe](/kb/frappe/)[ERPNext](/kb/erpnext/)[Odoo](/kb/odoo/)[WordPress](/kb/wordpress/)[NixOS](/kb/nixos/)[Email](/kb/email/)[Linux](/kb/linux/)[Databases](/kb/databases/)[Containers](/kb/containers/)[Proxmox](/kb/proxmox/)[Git & Dev Tools](/kb/git-and-dev-tools/)

↵select↑↓navigateescclose

Search the knowledge base

[Skip to the article](#kb-article)[Frappe](/kb/frappe/)20 articles

- [Overview](/kb/frappe/)
- [Bench Operations](/kb/frappe/bench-operations/)
- [Builder Page Scripts](/kb/frappe/builder-page-scripts/)
- [Client-Side Recipes](/kb/frappe/client-side-recipes/)
- [Common Query Patterns](/kb/frappe/common-query-patterns/)
- [Custom Field Controllers](/kb/frappe/custom-field-controllers/)
- [Custom Pages](/kb/frappe/custom-pages/)
- [Custom Views](/kb/frappe/custom-views/)
- [Customizations API](/kb/frappe/customizations-api/)
- [Customizing Grid Columns for Child Tables](/kb/frappe/customizing-grid-columns-child-tables/)
- [Doctype States & Status Fields](/kb/frappe/doctype-states-status-fields/)
- [Grandchild Table Fields](/kb/frappe/grandchild-table-fields/)
- [Portal Views](/kb/frappe/portal-views/)
- [Project Structure & Hooks](/kb/frappe/project-structure-hooks/)
- [Query Builder & PyPika Extensions](/kb/frappe/query-builder-pypika/)
- [Quick Entry Forms](/kb/frappe/quick-entry-forms/)
- [Script Reports](/kb/frappe/script-reports/)
- [Testing on Live Databases](/kb/frappe/testing-live-databases/)
- [Type Annotations & Controller Overrides](/kb/frappe/type-annotations-controller-overrides/)
- [Vite & TypeScript Compilation](/kb/frappe/vite-typescript-compilation/)
- [Web Forms](/kb/frappe/web-forms/)

Other sections[ERPNext](/kb/erpnext/)[Odoo](/kb/odoo/)[WordPress](/kb/wordpress/)[NixOS](/kb/nixos/)[Email](/kb/email/)[Linux](/kb/linux/)[Databases](/kb/databases/)[Containers](/kb/containers/)[Proxmox](/kb/proxmox/)[Git & Dev Tools](/kb/git-and-dev-tools/)

In Frappe: 20 articles

[Overview](/kb/frappe/)[Bench Operations](/kb/frappe/bench-operations/)[Builder Page Scripts](/kb/frappe/builder-page-scripts/)[Client-Side Recipes](/kb/frappe/client-side-recipes/)[Common Query Patterns](/kb/frappe/common-query-patterns/)[Custom Field Controllers](/kb/frappe/custom-field-controllers/)[Custom Pages](/kb/frappe/custom-pages/)[Custom Views](/kb/frappe/custom-views/)[Customizations API](/kb/frappe/customizations-api/)[Customizing Grid Columns for Child Tables](/kb/frappe/customizing-grid-columns-child-tables/)[Doctype States & Status Fields](/kb/frappe/doctype-states-status-fields/)[Grandchild Table Fields](/kb/frappe/grandchild-table-fields/)[Portal Views](/kb/frappe/portal-views/)[Project Structure & Hooks](/kb/frappe/project-structure-hooks/)[Query Builder & PyPika Extensions](/kb/frappe/query-builder-pypika/)[Quick Entry Forms](/kb/frappe/quick-entry-forms/)[Script Reports](/kb/frappe/script-reports/)[Testing on Live Databases](/kb/frappe/testing-live-databases/)[Type Annotations & Controller Overrides](/kb/frappe/type-annotations-controller-overrides/)[Vite & TypeScript Compilation](/kb/frappe/vite-typescript-compilation/)[Web Forms](/kb/frappe/web-forms/)

Other sections[ERPNext](/kb/erpnext/)[Odoo](/kb/odoo/)[WordPress](/kb/wordpress/)[NixOS](/kb/nixos/)[Email](/kb/email/)[Linux](/kb/linux/)[Databases](/kb/databases/)[Containers](/kb/containers/)[Proxmox](/kb/proxmox/)[Git & Dev Tools](/kb/git-and-dev-tools/)

FrappeScript Reports

Build Script Reports with tree data, editable cells, charts, conditional formatting, external SQL, and toolbar actions.

UpdatedMar 13, 2026

Tagsfrappereportspythonjavascript

Reading time6 min

On this page[File Structure](#file-structure)[Report JSON Definition](#report-json-definition)[Python: The execute() Function](#python-the-execute-function)[Basic Pattern](#basic-pattern)[Full Return Signature](#full-return-signature)[External Columns from JSON](#external-columns-from-json)[External SQL](#external-sql)[Chart Data](#chart-data)[Typed Filters](#typed-filters)[JavaScript: Client-Side Configuration](#javascript-client-side-configuration)[Filters](#filters)[Tree Reports](#tree-reports)[Custom Formatters](#custom-formatters)[Conditional Row Coloring](#conditional-row-coloring)[Datatable Options](#datatable-options)[Inline Editors](#inline-editors)[Cross-Column Recalculation](#cross-column-recalculation)[LocalStorage Persistence](#localstorage-persistence)[Custom Toolbar Buttons](#custom-toolbar-buttons)[Column Totals](#column-totals)[Column Background Colors](#column-background-colors)[Server-Side Whitelisted Endpoints for Reports](#server-side-whitelisted-endpoints-for-reports)[CSS for Full-Width Reports](#css-for-full-width-reports)

Script Reports provide far more flexibility than standard Query Reports. They support tree hierarchies, editable cells, custom charts, conditional formatting, external SQL, toolbar actions, and localStorage persistence.

## File Structure

```text
mymodule/report/my_report/
├── my_report.json         # Report definition (ref_doctype, roles, report_type)
├── my_report.py           # Server-side execute() function
├── my_report.js           # Client-side filters, formatters, editors, hooks
├── my_report.sql          # External SQL query (optional)
├── my_report.css          # Custom styles (optional)
└── columns.json           # External column definitions (optional)
```

## Report JSON Definition

```
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">{</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"doctype"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Report"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"report_type"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Script Report"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"ref_doctype"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Item"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"is_standard"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Yes"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"module"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"MyModule"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"name"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"My Report"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"report_name"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"My Report"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"roles"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: [</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        {</span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"role"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Stock Manager"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">},</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        {</span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"role"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Item Manager"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">}</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    ]</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">}</span>
```

## Python: The `execute()` Function

### Basic Pattern

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">def</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">execute</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(filters</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">):</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    columns </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> get_columns()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    data </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> get_data(filters)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> columns, data</span>
```

### Full Return Signature

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">def</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">execute</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(filters</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">):</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> columns, data, message, chart</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">#      list     list   str|None  dict|None</span>
```

### External Columns from JSON

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">import</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> json</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">from</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> pathlib </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">import</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> Path</span>

<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">def</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">execute</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(filters</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">):</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    columns </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> json.loads((Path(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">__file__</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">).parent </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">/</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"columns.json"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">).read_text())</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">...</span>
```

### External SQL

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">def</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">execute</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(filters</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">):</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    query </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (Path(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">__file__</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">).parent </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">/</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"my_report.sql"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">).read_text()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    data </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.db.sql(query, {</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"param"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: value}, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">as_dict</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">True</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">...</span>
```

### Chart Data

```
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">chart </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"type"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"line"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,  </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781"># or "bar", "pie", "donut", "percentage"</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"data"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"labels"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: [</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Project A"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Project B"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">],</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"datasets"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: [</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            {</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"name"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Quoted Hours"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"values"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: [</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">10.0</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">20.0</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">]},</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            {</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"name"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Actual Hours"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"values"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: [</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">12.0</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">18.0</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">]},</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        ],</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"axisOptions"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: {</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"xAxisMode"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"tick"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"shortenYAxisNumbers"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">},</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">}</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> columns, data, </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, chart</span>
```

### Typed Filters

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">from</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> typing </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">import</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> TypedDict</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">from</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.types </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">import</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">DF</span>

<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">class</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">Filters</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">TypedDict</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">total</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">False</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">):</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    item_group: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">DF</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.Link </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">|</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">None</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    date_range: tuple[</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">str</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">str</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">]</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    status: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">DF</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.Literal[</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Open"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Completed"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Cancelled"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">]</span>
```

## JavaScript: Client-Side Configuration

### Filters

```
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">frappe.query_reports[</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"My Report"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">] </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    filters: [</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            fieldname: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"item_group"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            label: </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">__</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Item Group"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">),</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            fieldtype: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Link"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            options: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Item Group"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            fieldname: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"date_range"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            label: </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">__</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Date Range"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">),</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            fieldtype: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"DateRange"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            fieldname: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"status"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            label: </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">__</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Status"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">),</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            fieldtype: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Select"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            options: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Open</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">\n</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">Completed</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">\n</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">Cancelled"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    ],</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">};</span>
```

### Tree Reports

Enable hierarchical rendering using `indent` and `parent` in your data:

```
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">frappe.query_reports[</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"My Report"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">] </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    tree: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">true</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    initial_depth: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,  </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// How many levels to expand by default</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// ... filters</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">};</span>
```

Data rows need `indent` (0-based depth) and optionally `parent` (ID of parent row):

```
<span style="--shiki-dark:#8B949E;--shiki-light:#6E7781"># Python: return rows with indent</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">data </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> [</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    {</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"name"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Group A"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"indent"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">0</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"id"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"A"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">},</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    {</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"name"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Item 1"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,  </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"indent"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"parent"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"A"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">},</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    {</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"name"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Item 2"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,  </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"indent"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"parent"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"A"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">},</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">]</span>
```

#### SQL Tree via UNION ALL

Build hierarchy in SQL using separate queries per level:

```
<span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">-- Level 0: Projects</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">SELECT</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> id, </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">name</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, ..., </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">0</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">AS</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> indent, </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">NULL</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">AS</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> parent </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">FROM</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> projects</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">UNION ALL</span>
<span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">-- Level 1: Operations under projects</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">SELECT</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> id, </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">name</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, ..., </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">AS</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> indent, project </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">AS</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> parent </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">FROM</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> operations</span>
```

### Custom Formatters

```
<span style="--shiki-dark:#FFA657;--shiki-light:#953800">formatter</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">function</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">value</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">row</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">column</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">data</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">default_formatter</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    value </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">default_formatter</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(value, row, column, data);</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (column.fieldname </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">===</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"name"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">&&</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> data) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">const</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">indent</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> row[</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">].indent;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (indent </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">===</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">0</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// Parent row: link to project</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            value </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">`<a href="/app/project/${</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">data</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">.</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">id</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">}">${</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">data</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">.</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">id</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">}</a>`</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        } </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">else</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// Child row: link to job card</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            value </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">`<a href="/app/job-card/${</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">data</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">.</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">job_card</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">}">${</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">data</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">.</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">name</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">}</a>`</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        }</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    }</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// Fraction formatting for a Float field</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (column.fieldname </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">===</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"conversion_factor"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">&&</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> value) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">format</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(value, {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            fieldtype: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Float"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            options: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Fraction"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        }, { inline: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">true</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    }</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> value;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">},</span>
```

### Conditional Row Coloring

Use `after_datatable_render` to style rows based on data values:

```
<span style="--shiki-dark:#FFA657;--shiki-light:#953800">after_datatable_render</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">function</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">datatable</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">const</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">varianceIdx</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> datatable.datamanager.columns.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">findIndex</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        (</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">col</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> col.fieldname </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">===</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"variance_percent"</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    );</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    datatable.datamanager.rows.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">forEach</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">((</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">row</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">rowIndex</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">const</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">value</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> row[varianceIdx].content;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (value </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">===</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">undefined</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">||</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> value </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">===</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">null</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">let</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> intensity </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> Math.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">min</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(Math.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">abs</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(value) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">/</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">100</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">let</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> bgColor </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> value </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">>=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">0</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">?</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">`rgba(0, 128, 0, ${</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">intensity</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">*</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">0.3</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">})`</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">   </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// Green for positive</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">:</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">`rgba(255, 0, 0, ${</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">intensity</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">*</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">0.3</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">})`</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;   </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// Red for negative</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        datatable.datamanager.columns.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">forEach</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">((</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">_</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">colIdx</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            datatable.style.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">setStyle</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">`.dt-cell--${</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">colIdx</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">}-${</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">rowIndex</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">}`</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                { backgroundColor: bgColor }</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            );</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        });</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// Bold parent rows</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (row[</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">].indent </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">===</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">0</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            datatable.datamanager.columns.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">forEach</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">((</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">_</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">colIdx</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                datatable.style.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">setStyle</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">`.dt-cell--${</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">colIdx</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">}-${</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">rowIndex</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">}`</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    { fontWeight: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">600</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> }</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                );</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        }</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">},</span>
```

### Datatable Options

```
<span style="--shiki-dark:#FFA657;--shiki-light:#953800">get_datatable_options</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">function</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">options</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> Object.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">assign</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(options, {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        treeView: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">true</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        checkboxColumn: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">false</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        serialNoColumn: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">false</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        layout: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"ratio"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,    </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// or "fixed"</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        cellHeight: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">36</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        showTotalRow: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">true</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">},</span>
```

### Inline Editors

Provide per-cell editors via `getEditor` in datatable options:

```
<span style="--shiki-dark:#FFA657;--shiki-light:#953800">get_datatable_options</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">function</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">options</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> Object.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">assign</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(options, {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">getEditor</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">colIndex</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">rowIndex</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">value</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">parent</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">column</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">row</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">data</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">!</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">data </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">||</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> data.row_type </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">===</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"group"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">false</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// Number editor</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (column.id </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">===</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"valuation_rate"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">const</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">input</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> document.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">createElement</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"input"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                input.type </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"number"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                input.step </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"0.01"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                input.style.width </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"100%"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                parent.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">appendChild</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(input);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">initValue</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">val</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) { input.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">focus</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(); input.value </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> val </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">||</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">""</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">; },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">getValue</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">() { </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">parseFloat</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(input.value) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">||</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">0</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">; },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">setValue</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">newValue</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                        </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// Save to server</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                        frappe.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">call</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">({</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                            method: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"myapp.api.update_field"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                            args: { item: data.item_code, value: newValue },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                            async: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">false</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                        });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                };</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            }</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// Frappe Link editor</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (column.id </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">===</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"stock_uom"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">let</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> control </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.ui.form.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">make_control</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">({</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    df: { fieldtype: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Link"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, fieldname: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"stock_uom"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, options: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"UOM"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    parent: parent,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    render_input: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">true</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                control.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">toggle_label</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">false</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                control.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">toggle_description</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">false</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">initValue</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">val</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                        control.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">set_value</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(val);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                        </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">setTimeout</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(() </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> control.$input?.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">focus</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(), </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">100</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">getValue</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">() { </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> control.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">get_value</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(); },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">setValue</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">newValue</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) { </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">/* save logic */</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                };</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            }</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// Frappe Fraction editor</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (column.id </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">===</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"conversion_factor"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">let</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> control </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.ui.form.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">make_control</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">({</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    df: { fieldtype: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Float"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, fieldname: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"cf"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, options: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Fraction"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    parent: parent,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    render_input: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">true</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                control.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">toggle_label</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">false</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                control.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">toggle_description</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">false</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> { </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">/* same pattern */</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> };</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            }</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">false</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">},</span>
```

### Cross-Column Recalculation

When editing one column should update others:

```
<span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">getEditor</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(colIndex, rowIndex, value, parent, column, row, data) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (column.id </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">===</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"reorder_qty"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">const</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">conv</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> data.conversion_factor </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">||</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">const</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">input</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> document.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">createElement</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"input"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        input.type </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"number"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        parent.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">appendChild</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(input);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">initValue</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">val</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) { input.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">focus</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(); input.value </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> val; },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">getValue</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">() { </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">parseFloat</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(input.value) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">||</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">0</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">; },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">setValue</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">value</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// Update multiple columns at once</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">updateDataRow</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">({</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    reorder_qty: value,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    reorder_skids: value </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">/</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> conv,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    projected_stock: data.available_stock </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">+</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> value,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                }, rowIndex);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        };</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    }</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">}</span>

<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">function</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">updateDataRow</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">updates</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">rowIndex</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    Object.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">entries</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(updates).</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">forEach</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(([</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">key</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">value</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">]) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        datatable.datamanager.data[rowIndex][key] </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> value;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">const</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">colIdx</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> datatable.datamanager.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">getColumnIndexById</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(key);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (colIdx </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">!==</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">-</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            datatable.datamanager.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">updateCell</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(colIdx, rowIndex, { content: value });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        }</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    datatable.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">refreshRow</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(datatable.datamanager.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">getRow</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(rowIndex), rowIndex);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    datatable.bodyRenderer.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">renderFooter</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">();</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">}</span>
```

### LocalStorage Persistence

Persist unsaved editor data across page refreshes:

```
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">const</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">STORAGE_KEY</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"my_report_data"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>

<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">function</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">saveData</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">() {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">const</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">data</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {};</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    datatable.datamanager.data.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">forEach</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">((</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">row</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (row.item </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">&&</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> row.reorder_qty) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            data[row.item] </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> row.reorder_qty;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        }</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    localStorage.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">setItem</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">STORAGE_KEY</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">JSON</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">stringify</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(data));</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">}</span>

<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">function</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">loadData</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">() {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">const</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">saved</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> localStorage.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">getItem</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">STORAGE_KEY</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">!</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">saved) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">const</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">data</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">JSON</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">parse</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(saved);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    datatable.datamanager.data.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">forEach</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">((</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">row</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">idx</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (row.item </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">&&</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> data[row.item]) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">updateDataRow</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">({ reorder_qty: data[row.item] }, idx);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        }</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">}</span>
```

### Custom Toolbar Buttons

```
<span style="--shiki-dark:#FFA657;--shiki-light:#953800">onload</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">function</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">report</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    report.page.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">add_button</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">__</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Create Purchase Order"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">), </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">function</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> () {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        frappe.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">call</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">({</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            method: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"myapp.api.create_purchase_order"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            args: { data: report.data },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">callback</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: (</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">r</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> { </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">/* handle result */</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    }, { btn_class: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"btn-primary"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, icon: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"check"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">},</span>
```

### Column Totals

```
<span style="--shiki-dark:#FFA657;--shiki-light:#953800">get_datatable_options</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">function</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">options</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> Object.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">assign</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(options, {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        showTotalRow: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">true</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        hooks: {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">columnTotal</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">columnValues</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">cell</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> ([</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">8</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">9</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">10</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">].</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">includes</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(cell.colIndex)) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> columnValues.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">reduce</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">((</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">acc</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">v</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=></span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                        acc </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">+</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">typeof</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> v </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">===</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"number"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">?</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> v </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">:</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">0</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">), </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">0</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">);</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                }</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">},</span>
```

### Column Background Colors

```
<span style="--shiki-dark:#FFA657;--shiki-light:#953800">after_datatable_render</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">function</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">datatable</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    datatable.style.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">setStyle</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">".dt-cell--col-6"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        backgroundColor: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"rgba(182, 216, 230, 1)"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    [</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">8</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">9</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">].</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">forEach</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">((</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">col</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        datatable.style.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">setStyle</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">`.dt-cell--col-${</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">col</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">}`</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            backgroundColor: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"rgba(148, 250, 179, 1)"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">},</span>
```

## Server-Side Whitelisted Endpoints for Reports

For editable reports, expose update endpoints:

```
<span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">@frappe.whitelist</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">()</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">def</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">update_item_field</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(item_code: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">str</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, fieldname: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">str</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, value: Any) -> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">dict</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    allowed_fields </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"stock_uom"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"sales_uom"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"valuation_rate"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">}</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> fieldname </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">not</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">in</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> allowed_fields:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"status"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"error"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"message"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: _(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Field not editable"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">)}</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">try</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        doc </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.get_doc(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Item"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, item_code)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        doc.set(fieldname, value)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        doc.save()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        frappe.db.commit()</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"status"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"success"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"message"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: _(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">{0}</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069"> updated"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">).format(fieldname)}</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">except</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">Exception</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">as</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> e:</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        frappe.log_error(frappe.get_traceback(), </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">f</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Update Error - </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">{</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">item_code</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">}</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"status"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"error"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"message"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">str</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(e)}</span>
```

## CSS for Full-Width Reports

```
<span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">/* my_report.css */</span>
<span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">@media</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">min-width</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">768</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">px</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">body</span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">.full-width</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">.container</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">width</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">100</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">%</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">!important</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">max-width</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">100</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">%</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">!important</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    }</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">}</span>
```

Need help with Frappe?

Our notes can take you a long way, but sometimes you'd rather have someone who's done it before.

[ERPNext implementation](/services/erp/erpnext/)

[← PreviousQuick Entry Forms](/kb/frappe/quick-entry-forms/)[Next →Testing on Live Databases](/kb/frappe/testing-live-databases/)

CC0This article is in the public domain ([CC0 1.0](https://creativecommons.org/publicdomain/zero/1.0/)), code samples included. Use it however helps you.

On this page

- [File Structure](#file-structure)
- [Report JSON Definition](#report-json-definition)
- [Python: The execute() Function](#python-the-execute-function)
- [Basic Pattern](#basic-pattern)
- [Full Return Signature](#full-return-signature)
- [External Columns from JSON](#external-columns-from-json)
- [External SQL](#external-sql)
- [Chart Data](#chart-data)
- [Typed Filters](#typed-filters)
- [JavaScript: Client-Side Configuration](#javascript-client-side-configuration)
- [Filters](#filters)
- [Tree Reports](#tree-reports)
- [Custom Formatters](#custom-formatters)
- [Conditional Row Coloring](#conditional-row-coloring)
- [Datatable Options](#datatable-options)
- [Inline Editors](#inline-editors)
- [Cross-Column Recalculation](#cross-column-recalculation)
- [LocalStorage Persistence](#localstorage-persistence)
- [Custom Toolbar Buttons](#custom-toolbar-buttons)
- [Column Totals](#column-totals)
- [Column Background Colors](#column-background-colors)
- [Server-Side Whitelisted Endpoints for Reports](#server-side-whitelisted-endpoints-for-reports)
- [CSS for Full-Width Reports](#css-for-full-width-reports)

[Back to top↑](#top)

Services

- [ERP implementation](/services/erp/)
- [Odoo](/services/erp/odoo/)
- [ERPNext](/services/erp/erpnext/)
- [Custom software](/services/custom-software/)
- [Devices & IoT](/services/devices-iot/)
- [Websites](/services/websites/)
- [Infrastructure](/services/infrastructure/)

Resources

- [Our work](/work/)
- [Open source](/open-source/)
- [Knowledge base](/kb/)
- [Insights](/insights/)

Company

- [About](/about/)
- [Team](/about/team/)
- [Partners](/partners/)
- [Contact](/contact/)

Clients

- [Project portal](https://erp.avunu.net/projects)
- [Invoices](https://erp.avunu.net/)
- [Support](https://erp.avunu.net/)

[![Avunu](/brand/avunu-logo-light.svg)](/)[\<av-icon data-jx-static>\<svg viewBox="0 0 24 24" width="20" height="20" fill="currentColor" stroke="none" stroke-width="1.6" stroke-linecap="round" stroke-linejoin="round" aria-hidden="true" focusable="false">\<path d="M20.400 20.500h-3.600v-5.600c0-1.300 0-3-1.800-3s-2.100 1.400-2.100 2.900v5.700H9.400V9h3.400v1.600c.5-.9 1.600-1.900 3.400-1.900 3.600 0 4.300 2.400 4.300 5.500v6.300zM5.300 7.400a2.100 2.100 0 1 1 0-4.100 2.100 2.100 0 0 1 0 4.100zm1.800 13.100H3.600V9h3.500v11.500zM22.200 0H1.800C.8 0 0 .8 0 1.700v20.600c0 .9.800 1.700 1.800 1.700h20.400c1 0 1.800-.8 1.800-1.700V1.700C24 .8 23.200 0 22.200 0z">\</path>\</svg>\</av-icon>](https://www.linkedin.com/company/avunu)[\<av-icon data-jx-static>\<svg viewBox="0 0 24 24" width="20" height="20" fill="currentColor" stroke="none" stroke-width="1.6" stroke-linecap="round" stroke-linejoin="round" aria-hidden="true" focusable="false">\<path d="M12 .3a12 12 0 0 0-3.8 23.4c.6.1.8-.3.8-.6v-2c-3.3.7-4-1.6-4-1.6-.6-1.4-1.4-1.8-1.4-1.8-1-.7.1-.7.1-.7 1.2.1 1.8 1.2 1.8 1.2 1 1.8 2.8 1.3 3.5 1 .1-.8.4-1.3.7-1.6-2.7-.3-5.5-1.3-5.5-5.9 0-1.3.5-2.4 1.2-3.2-.1-.3-.5-1.5.1-3.2 0 0 1-.3 3.3 1.2a11.500 11.500 0 0 1 6 0c2.300-1.500 3.300-1.200 3.300-1.200.6 1.700.2 2.900.1 3.200.8.8 1.200 1.900 1.200 3.200 0 4.600-2.800 5.600-5.500 5.900.4.400.8 1.100.8 2.200v3.300c0 .3.2.7.8.6A12 12 0 0 0 12 .3">\</path>\</svg>\</av-icon>](https://github.com/Avunu)[Client portal](https://erp.avunu.net/projects)[Start a project](/start/)

Avunu LLC · 948 East Philadelphia Street, York, PA 17403 · (717) 814-8540Knowledge base articles are in the public domain[Privacy](/privacy/)[Terms](/terms/)
