{
 "add_total_row": 1,
 "creation": "2020-07-27 16:05:33.263539",
 "disable_prepared_report": 0,
 "disabled": 0,
 "docstatus": 0,
 "doctype": "Report",
 "idx": 0,
 "is_standard": "Yes",
 "json": "{}",
 "modified": "2020-08-05 14:14:12.410515",
 "modified_by": "Administrator",
 "module": "Education",
 "name": "Program wise Fee Collection",
 "owner": "Administrator",
 "prepared_report": 0,
 "query": "SELECT \n    FeesCollected.program AS \"Program:Link/Program:200\",\n    FeesCollected.paid_amount AS \"Fees Collected:Currency:150\",\n    FeesCollected.outstanding_amount AS \"Outstanding Amount:Currency:150\",\n    FeesCollected.grand_total \"Grand Total:Currency:150\"\nFROM (\n    SELECT \n        sum(grand_total) - sum(outstanding_amount) AS paid_amount, program,\n        sum(outstanding_amount) AS outstanding_amount,\n        sum(grand_total) AS grand_total\n    FROM `tabFees`\n    WHERE docstatus = 1\n    GROUP BY program\n) AS FeesCollected\nORDER BY FeesCollected.paid_amount DESC",
 "ref_doctype": "Fees",
 "report_name": "Program wise Fee Collection",
 "report_type": "Script Report",
 "roles": [
  {
   "role": "Academics User"
  },
  {
   "role": "Accounts User"
  },
  {
   "role": "Accounts Manager"
  }
 ]
}