Script reports consistently fail to display data despite correct configuration.
The issue involves Script Reports not displaying any data, even with simple test cases, while Query Reports work fine. The problem appears to be systemic rather than configuration-specific, potentially related to installation or core functionality. Multiple users report the same behavior, suggesting a broader issue.
Hi everyone,
I’m having a persistent issue with Script Reports on my ERPNext instance (ERPNext 15.45.2, Frappe 15.49.1, HRMS 15.35.3, self-hosted on Ubuntu).
Problem: No matter what I do, any Script Report I create (even the simplest possible, with just one column and one row) always displays “Nothing to show” or “Generic Empty State”. Query Reports work fine and show data from the database.
What I’ve tried so far:
Checked all permissions (Administrator user, all necessary permissions on Report, Item, User, etc.) Made sure the report is not “Disabled” Tried different DocTypes (Item, User, Employee) Used the simplest possible script:
def execute(filters=None): columns = [{"label": "Test", "fieldname": "test", "fieldtype": "Data"}] data = [{"test": "It works!"}] return columns, data
Tried with and without filters, with and without “Is Standard”, in multiple browsers and with different users Ran bench clear-cache, bench restart, bench --site site1.local migrate Checked the Error Log in ERPNext and in the terminal – no errors related to reports In bench console, frappe.get_all("Item", fields=["item_code", "item_name"]) returns data Query Reports with SQL queries work and display data Created a brand new Script Report, no filters, just one column and one value – still nothing shows Additional info:
No customizations on the Report DocType No custom scripts that could affect reports Tried incognito mode and a different computer Question: Has anyone experienced this before? Is there anything else I can check or try before setting up a new instance or restoring from backup?
Any help or suggestions would be greatly appreciated!
Thanks in advance!
stock
15.49.1 15.45.2
manual install
Claim this issue to let others know you're working on it. You'll earn 10 points when you complete it!