How to set width of the column in report

1

I created script based report. How to define the width of the column?

2

Open .py file and you can set the width of the columns like column name followed by length.

3

The width can be set in the <report_name>.py file if it is a script report as follows:

{
   "fieldname": "amount",
   "label": _("Amount"),
   "fieldtype": "Currency",
   "width": 130
}

For Query reports, You can set it in the SQL Query statement as follows:

select item_code as "Material Code:Link/Item:120"
from tabItem ......
4

thanks able to do it.

5

To tell precisely columns=[{“fieldname”:“xyz”,“widht”:130},{…}]