BASIC HELP : MS4BI Designer by MS4script   
   2021 version 1       

Part 1 : QUERY No chart

Form Special Grid or Plus : Overview, Standard, Edit , Select column , Multiple tables, Aggregate, Calculate & InputLink

Step 1

toolbar

Presentation

Implementation 1

∑ REVENUE	∑EXPENSE	BALANCE	%EXPENSE
9755.00 €	4573.00 €	5182.00 €	expense/revenue : 46.88 %

Standard

 		   	
		 Query  : Form Special Grid   + Simple Style  
	
	

Query Simple Implementation 2

NAME	FIRSTNAME	SEX	AGE	REVENUE	EXPENSE
Arthur	Sheila	F	28	750	120
Buchanan	Steven	M	61	1000	210
Devis	John	M	21	50	12
Dodsworth	Anne	F	27	540	120
Fuller	Andrew	M	28	750	500
Hallan	Donald	M	33	1280	500
King	Robert	M	34	650	56
Leverling	Janet	F	52	50	12
Mactree	Peter	M	42	2400	1350
Nevada	patrick	M	23	450	180
Peacock	Margaret	F	42	0	0
Picsou	Jack	M	57	99	1
Suyama	Michael	M	26	500	250

Personalize Style

 		   	
		 QUERY : Form Special Grid   + Personalize Style  
	
	

Implementation 3

NAME	FIRSTNAME	SEX	AGE	+	-
Arthur	Sheila	F	28	750.00 €	120.00 €
Buchanan	Steven	M	61	1000.00 €	210.00 €
Devis	John	M	21	50.00 €	12.00 €
Dodsworth	Anne	F	27	540.00 €	120.00 €
Fuller	Andrew	M	28	750.00 €	500.00 €
Hallan	Donald	M	33	1280.00 €	500.00 €
King	Robert	M	34	650.00 €	56.00 €
Leverling	Janet	F	52	50.00 €	12.00 €
Mactree	Peter	M	42	2400.00 €	1350.00 €
Nevada	patrick	M	23	450.00 €	180.00 €
Peacock	Margaret	F	42	0.00 €	0.00 €
Picsou	Jack	M	57	99.00 €	1.00 €
Suyama	Michael	M	26	500.00 €	250.00 €

Personalize Style

 		   	
		 QUERY : Form Plus 
	
	

Implementation 4

Edit Line

 		   	
		 QUERY :  Edit Line (only 1 table and Form Special )
	
	

Goto to see 70,71,72 Input(Select,insert,Update)

Implementation 5

NAME	FIRSTNAME	SEX	AGE	REVENUE	EXPENSE	Options
Arthur	Sheila	F	28			Save
Buchanan	Steven	M	61			Save
Devis	John	M	21			Save
Dodsworth	Anne	F	27			Save
Fuller	Andrew	M	28			Save
Hallan	Donald	M	33			Save
King	Robert	M	34			Save
Leverling	Janet	F	52			Save
Mactree	Peter	M	42			Save
Nevada	patrick	M	23			Save
Peacock	Margaret	F	42			Save
Picsou	Jack	M	57			Save
Suyama	Michael	M	26			Save

InputQuery/Link : Only 1 by transaction

Go to See 75-InputQuery

NAME	REVENUE	EXPENSE
Buchanan	1000	210
Callahan	36	12
Davolio	1200	1250
Devis	50	12
Dodsworth	540	120
Fuller	750	500
Hallan	1280	500
King	650	56
Leverling	50	12
Mactree	2400	1350
Nevada	450	180
Peacock	0	0
Picsou	99	1
Suyama	500	250
Arthur	750	120

TabStrip

the official sites :
www.mgplanete.com
getms4bi.com
demos.ms4bi.com
help.ms4bi.com
www.ms4script.com