Hello @Abdullah_A_Ansari
There are 4 kinds of built-in reporting mechanisms in ERPNext : Report Builder, Query Report, Script Report and Query Builder.
For both Query Reports and Script Reports the same UI view is used to render them : Query Report View.
-
Report Builder allows for simple reports to be built from the web user interface (WUI) without any coding, unlike the others
Reports -
Query Report is a SQL query defined within the WUI by a user with System Manager permissions
How To Make Query Report -
Script Reports are written client-side in the WUI or in JS/Python and stored as files server-side by a user with Administrator permissions in Developer mode
Script Report
Also look at this tutorial
[Tutorial] Script Report / Chart -
Query Builder
Query Builder
Making use of these methods you should be able to build whatever your requirements are, especially using Script Reporting.