Issue with add_total_row Behavior in Report Across Local and Cloud Environments

Frappe Framework
1

Hi everyone,
I’m facing an issue where the add_total_row behavior is inconsistent between my local Frappe setup and a cloud-hosted environment.
Scenario:
In my local setup, I have a report where the add_total_row is set to 1 (verified in the tabReport table), and a total row is correctly displayed at the bottom of the report. However, when I run the same report on the cloud-hosted site, the total row does not appear, even though everything else in the report (data, columns, etc.) is the same.
What I’ve Checked:

  1. Verified that the add_total_row is set to 0 in hosted environment and 1 in local env.
  2. The report scripts and logic are the same across both environments.
  3. Checked for caching issues by clearing the cache, but the problem persists.

Has anyone else experienced this issue or have any insights on what might be causing the discrepancy?
Thanks in advance for your help!

2

According to this line add_total_row is set 0 on live that’s why it is not showing total row.

and in local add_total_row is set 1 that’s why it is showing total row

System working properly
Please check the add_total_row in the hosted environment.