Thank you @lasalesi. I am able to do this. But I want to do further customisations on the report.
For example, my report displays columns for “quantity ordered” and “quantity delivered”. I want the report to have additional fields, for example balance ( = “quantity ordered” - “quantity delivered”).
Currently I have to download the report in my spreadsheet and make modifications before sending it to management. I want the report to be complete so that it can be directly usable by management.
Thank you, I get that @root13F. With that I am limited to certain changes, like filter, pick columns and so on. I want to make changes that I cannot make with the edit->save as functionality. For example, as I explained above, to add new calculated columns.
Oh then you should look at using either a query report or a script report. There you can add as many columns as you want. Query report will require you to write an SQL query and you’ll have to write the logic of your new columns in SQL .
Meanwhile in script report you may also use python. You can use MySQL to get your data and then use python to manipulate and add even more columns as you require.