Script Reports Help

ERPNext Reports
1

Hello Team
I need some help in script reports

  • How to build script report that show live charts?
  • How to make report collapse rows depend on specific field?

best regards
Omar

2

have a look at:

3

Thanks @JoEz
I don’t want to use HTML page i need charts in report page!! any help?

4

Yes I need like this but in report page.
please tell me when u find this code to do collapse as shown in picture

5

You can create a script report, have a look at maintenance report

6

Thanks again @JoEz
I actually do my report

Pasted image1189×545 38.8 KB

but i need collapse speed field depend on speed value like all 0.1 collapse together

7

you need to change the query grouping by speed instead of per date

8

Hi @Omar_Salah
Can you please share ur code if possible i m struggling the same issue long time with no solution

Regards

9

@SOLOSOFT witch one?

10

Shopper statistics

11

@SOLOSOFT If you mean Charts follow this link

note: “js file more important than others”

12

The problem is i have more than one line of chart to show i need to change sql query (turn rowns into lines)

13

@SOLOSOFT If you mean like this

Pasted image1233×602 33.4 KB

you must follow erpnext/erpnext/accounts/report/balance_sheet at develop · frappe/erpnext · GitHub

and please if you understand this topic tell me :grin::joy:

14

Where you able to figure this one out?

I believe The answer lies in the way the rows are structured.

As a tip: each row is given a specific structure and elements.
Each row also refers to the following function one directory above the python file you link, which is financial_statements.py