one of my column doesn't show data on the report . the report is custom report

I’m working on a custom report in ERPNext. My SQL (python file ) and JSON configs are correct and similar filed name, and the SQL query fetches data directly from the database. However, the field untaxable fuel Allowance shows empty in the ERPNext report other column fetch the real data from database

Hi,
Try these things

  • Check SQL Query Output
  • Verify the SQL query column name is the same as the Report column name (the SQL query column should match the field name of the column data shown in the screenshot below).