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 €	4073.00 €	5682.00 €	expense/revenue : 41.75 %

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
Callahan	Laura	F	36	36	12
Davolio	Nancy	F	39	1200	1250
Devis	John	M	21	50	12
Dodsworth	Anne	F	27	540	120
Fuller	Andrew	M	28	750	500
Hallan	Donald	M	33	1280	0
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 €
Callahan	Laura	F	36	36.00 €	12.00 €
Davolio	Nancy	F	39	1200.00 €	1250.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 €	0.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
Callahan	Laura	F	36			Save
Davolio	Nancy	F	39			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	0
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