ERPNext Frappe script report creation and coding

ERPNext and Frappe training for creating script reports
Free Download What you'll learn
ERPNext implementors, consultants, programmers, accountants and small business owners
1000 Dollars
No risk
SQL creation , coding
Requirements
ERPNext basic knowledge
Description
In this session, we create a script report withReport summaryGraph with two legsData listingColor the value with conditionMessageClient side scriptingSQLand a little bit of Query report.Lets start by creating simple messageStandard - NO***** Note: Lot of indent issues with the following codes, please fix it if you are copying the code. Better you write on your owndata = columns, data, "Hello, here is my stock summary, graph and details", chart, report_summarydata = None, None, "Lets learn Script reporting", None, NoneNow lets have two columscolumns =["Letter","Number","Colour"]mydata =[['Row-1',2,'Red'],['Row-2',2,'Blue'],['Row-3',8,Yellow'],['Row-4',7,'Violet']]data = columns, mydata, "Lets learn Script reporting", None, NoneColor itcolumns =["Letter","Number","Colour"] # listmydata =[['Row-1',2,'<span style="color: red;">Red</span>'],['Row-2',2,'Blue'],['Row-3',8,'Yellow'],['Row-4',7,'<span style="color: violet;">Violet</span>']] # list within listdata = columns, mydata, "Lets learn Script reporting", None, Nonelets do report summaryreport_summary =[{"value": "100", "label": "label1", "datatype": "Data"},{"value": "200", "label": "label2", "datatype": "Data"},{"value": "300", "label": "label3", "datatype": "Data"}]data = None, None, None, None, report_summaryHave a totalJust tick the boxLets plot a graphcolumns =["Letter","Number"]data =[['c',2],['a',2],['t',8],['s',7]]mydataset = {"values":[3000, 6500, 4250, 1000]}chart = {'data':{'labels':['Saudi','Qatar','UAE','Oman'],'datasets':[mydataset]},'type':'bar'}data = columns, data, None, chart, None
Who this course is for
Creating reports and charts on ERPNext
Homepage