[Tutorial] Script Report / Chart

[paco_ad]

Thanks a lot for your sharing effort to explain these report details to the community. It’s really awesome to have contributors like you. Profile - EugeneP - ERPNext Forum

[anouar_ali]

Thank you sir, it is pretty awesome what u have given to the community

[zulfi007]

Can you explain How to achieve Selectable rows in script report. e.g

[CleoMenezesJr]

Is there any way to remove the truncated from the names of the chart-legend? Lots of wasted space.

[MartinHBramwell]

Eugene, your document is spectacular and greatly appreciated.

@EugeneP

Note that the directory is in .../frappe-bench/apps/frappe/frappe/core/report/ This is where the Core module’s report definitions live, irrespective of the DocType such as User in this case.

This is a big long-term maintenance problem.

Have you found a way to include Script Reports into backups, for example?

A symlink into the private files directory would work, I think.

[TurkerTunali]

You can store report files in your custom apps folder. Play with the “Is Standart” and “Module” settings. Then the files will be stored in your custom app’s folder.

[MartinHBramwell]

Yeah!

I see that that works. Thank you.

[mohamed_ibrahim]

@EugeneP how can we modified the table row height and width?

[Tusharp21]

good idea

for my issue it’s work

thankyou

[alwin_johnson]

How to remove or hide series no in script report…

[ganureddy]

On click of down arrow from column, you can able to remove. Or if you want permanently remove just comment the code in python file.

[alwin_johnson]

Thanks for replay. But it is default column. Not showing any arrow in that columns

[Basant]

@EugeneP , if I need to print some dynamic value in print template, how do you do that? Server call/Get value from DB call doesn’t work inside report html print format. I cannot pass this as either from the execute function. The only allowed ones are column, data, message, chart and report summary. Is there a way to add value to report context object that can be accessed inside html?

[ratninder]

@wale

@EugeneP

Hi @EugeneP,

Thanks for an excellent tutorial on Reports & Charts. Very informative, with clear examples !

[Krishn]

Hey, @zulfi007 ,
" The function get_datatable_options(options) generates a checkbox column. Upon clicking the ‘Get Selected’ button, it fetches data from the selected row in the report."

frappe.query_reports[‘Report Name’] = {
     onload: function(report) {
        frappe.query_report.page.add_inner_button(__(“Get Selected”), function() {
        var selectedRows = [];
         $(‘.dt-scrollable’).find(“:input[type=checkbox]“).each((idx, row) => {
              if (row.checked) {
                  console.log(“*** selected row id : ” + idx);
                  selectedRows.push(frappe.query_report.data[idx]);
              }
          });
            console.log("Selected row: " selectedRows)
      })
        get_datatable_options(options) {
                return Object.assign(options, {
                    checkboxColumn: true
                });
            }
     }
}

[Divya_J]

Hi, I want create custom chart in dashboard , to create graph of that month so

[Hela_Guesmi]

How can i do two chart or more in one script report

How can i do two chart or more in script report

hello how can i display two chart or more in script report i can only show 1 chart as we can only return 1 chart at the py . return columns, data, None, chart, report_summary [Capture d’écran du 2024-09-20 19-03-17] and the other chart [Capture d’écran du 2024-09-20 19-05-37] i want both of chart in the same script report

[kyanwick]

Great work! Helped out a ton.

[anilpoda]

@EugeneP is it mandatory to set Is Standard to Yes? If make it Yes, script box is not is visible.

[EugeneP]

Hello @anilpoda

As explained in the first section of this topic, setting “Is Standard” to Yes, means that the script is persisted as a file, not as a record in the database. The rest of the topic assume you did that so that you can follow along and edit / save the file.

Also refer to What is the "Is Standard" in a Report?