Hide column label while exporting report

ERPNext
1

The snapshot of the screen from where we need to export the report is as follows,
following which is the report generated

report_view
report_view1445×667 40.9 KB

with_lable
with_lable1445×753 57.7 KB

The expected format of the report is as follows:

without_label
without_label1415×725 46.5 KB

2

Is anyone having any solution for this?

I am also having the same requirement. I have created a script report and when I export the report in an excel sheet I don’t want headers in the excel sheet just want data.

Also, I have tried making column names empty in the report but in this case, when I export an empty row comes up in the excel sheet at the top which is not my requirement. The first row must be data from the report.

Thanks.

3

Hi,

For hiding the column label, this solution might work for you. with_header need to be set as false to make the column label hide, the method that can be approached here is frappe.utils.xlsxutils.make_xlsx

Example Code:

frappe.ui.form.on('Report', {
    refresh: function(frm) {
        frm.page.add_menu_item(__('hide column'), function() {
            frappe.call({
                method: 'frappe.utils.xlsxutils.make_xlsx',
                args: {
                    data: frm.report_data,
                    sheet_name: frm.name,
                    with_header: false // Set with_header parameter to False to hide column labels
                },
                callback: function(r) {
                    var data = window.open(
                        'data:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;base64,' +
                        r.message,
                        '_blank'
                    );
                    data.document.close();
                    data.document.title = `${frm.name}.xlsx`;
                }
            });
        });
    }
});

Thank you.

4

@VINOTH Thanks for the reply. But, where can I put this JS code.

5

Yes, you need to apply this in the .js file.

6

@VINOTH
.js file of my script report?

7

The doctype where you need this change to be done, on that js you need to apply this code and need to replace the Report to your doctype name.

Thank you.