Making Reports in Frappe Framework/ERPNext: Builder, Query Report & Script Reports!

This video is all about building reports in Frappe Framework! We will cover:
A few built-in reports (Database, Web Analytics)
The Report Builder (No-code!)
Query Report (using SQL)
Script Report (using Python & JS)
Register on official website for more: buildwithhussa...
Follow me on X: x.com/NagariaH...
About Frappe and Frappe Framework:
frappe.io
frappeframewor...
Learn More Frappe Framework:
frappe.school
Get 15 days free trial Frappe site (without Credit Card details!) here: frappecloud.co...
#frappe #buildwithhussain #erpnext @frappetech

[@sword_tech]

Hussain, I just want to than you for this awesome tutorial. It is well thought and brilliantly presented. Shukran Bhai

[@BuildWithHussain]

🤝 Really glad you found this useful!

[@Vic-ky3cc]

Hi Hussain, at around 47:10 you noticed that the filters you set have no impact on your front end, i.e. the filter field is not shown. You then made a note that the filters section should be removed if "Is Standard" is set to "Yes". I generally agree though it was helpful that you were able to simply copy the lines in the json file over to your js file in order to show the filter field. As such, wouldn't it be more user friendly if any filters set in the UI there will automatically change the js file instead of the json file (if Is Standard is set to Yes)?

[@sonalinarkar6087]

How to add pie chart in Report list, Report Type - custom report.

[@fareshamza972]

Hello, is it possible to create an Override for the Jinja file for the general ledger report in my app ?

[@DAVE-GM]

Really good tutorials! I wonder if it's possible you can clear the fog around Tree type doctypes since it adds extra fields to the actual DB table.

[@moiz52moiz52]

Hi on 23rd minute you mentioned that we have functions in query reports that shows all records if nothing is selected in the filters, but I have tried so many things so many times, nothing seems to work on the Frappe Cloud environment. so If you have some solution that would be amazing

[@BuildWithHussain]

There are functions on the SQL side, but Framework’s application logic does not work.. so I figured out it won’t work as of now.

[@gopalkedia2020]

why can't I see default option in filter for "Query Reports" even after clicking on edit button? I have checked the fields by customization option too, but a total of 6 fields are there only. Our site is hosted on frappe cloud. without default field, its giving error using popup every time, for each filter i am setting. Defining filters using JS script is not showing filter options all together.

[@BuildWithHussain]

Hi 👋 Can you post this question here: discuss.frappe.io?

[@sukun05]

where does these customs reports are saved in server side........?

[@fiberworld777]

Dear Hussain... Your work is awesome. How can we create an installment report based upon payment terms at sales invoice. Kindly make a short video. Thanks

[@RohitRoy-p3g]

where is the code ? Can you please provide its link

[@Rajat_maurya]

How your System console is able to run SQL query also i dont have field type in my system console did you change code in backend and also added this field from frontend what you did tell me, i also want to do that??

[@BuildWithHussain]

Hi 👋 Which version of Frappe are you on? It’s a Framework feature, not customisation.

[@Rajat_maurya]

@@BuildWithHussain 13 version which one is yours

[@weixiangng8279]

Hussain how do you implement SST (Malaysia) inside ERPNext system though? My first time in erp. By the way your video are good.

[@BuildWithHussain]

You can make a custom app for the same. Here is the implementation of India’s tax localisation (GST): github.com/resilient-tech/india-compliance

[@Wawadewa]

Cool. Can I set this report to only show to a specific user or role?

[@BuildWithHussain]

You can role permissions in report document.

[@prasantpant9483]

how to do filters? I think You have missed that.

[@BuildWithHussain]

Yeah, have to create a separate video for that 😀 Will cover it in a separate real world use case video I think.

[@prasantpant9483]

@@BuildWithHussain thanks