Auto Email Report not working when Add Total Row is enabled in Report

[aheart]

Description of the issue

I've created a report using Report Builder and enabled the Total Row. It's impossible to set an Auto Email report for this report because of an error related to the Total Row

Context information (for bug reports)

Output of bench version

erpnext 15.9.1
frappe 15.8.1
hrms 15.8.0
insights 1.1.3
payments 0.0.1
wiki 2.0.0

Steps to reproduce the issue

1. Create a report for any document (e.g. Opportunity) using Report Builder
2. Enable Total Row and save
3. Set up Auto Email Report for this report and click Send Now

Observed result

Expected result

Stacktrace / full error message

{
    "exc_type": "DoesNotExistError",
    "_server_messages": "[\"{\\\"message\\\": \\\"Opportunity Total not found\\\", \\\"title\\\": \\\"Message\\\", \\\"indicator\\\": \\\"red\\\", \\\"raise_exception\\\": 1, \\\"__frappe_exc_id\\\": \\\"e680c183390033f16e847a2be7d91a3dcf4b3679a83d5ddb20ab749a\\\"}\"]"
}

[Nihantra-Patel]

Hi @aheart,

It's not a bug, When you make a report using the report builder, there's an option called "Show Totals." Just click on that option and save the report again. Then, the total will be included in the report. Don't use 'Add Total Row' in the Report Builder report.

https://github.com/frappe/frappe/assets/141945075/82d412a3-2612-4f5e-833e-4e4c763f2c12

Thank You!

[aheart]

@Nihantra-Patel thank you for your clarification. Here's what I tried:

1. Open Report View for Opportunity
2. Select "Show Totals" from the menu
3. Save the report
4. Select Setup Auto Email from the same menu
5. Save the new Auto Email Report
6. Click Send Now This time I haven't touched the "Add Total Row" checkbox, but the result is the same:

[Nihantra-Patel]

Right @aheart.

We reopen it.

[frappe-pr-bot]

:tada: This issue has been resolved in version 15.29.1 :tada:

The release is available on GitHub release

Your semantic-release bot :package::rocket:

[frappe-pr-bot]

:tada: This issue has been resolved in version 14.76.1 :tada:

The release is available on GitHub release

Your semantic-release bot :package::rocket: