MS4BI HELP 2019

by MS4script
01-Introduction
Preface & Copyright
Getting started
Demos Simple
02- Declarations
Structure
Type
03- Instructions
Conditions if,do,while..
String functions Str..()
Get + Include functions Get, Include..
Date-Time Day, Time, Year.
Display
Call
Formulas Complex
04- Database
Connector Ado, Odbc, Dsn, SAP, Ms4
Connect DB Create, delete
Import DataSource Import, Consolidation
Administration Admin, User
05- Sql-Query
Sql
Query Form : BTS,SHOW
Grid option
06- Charts
Forms Show, Win, Image, Excel, Morris...
Pie Std, Donut, 3D...
Bar Std, Stack, Line, Area, Plot
Radar
QrCode, Gauge
Step, Stock...
,Google,Leaflet... GeoMap
,Gantt,Timeline,Org.
07- Dashboard
Form tab, no tab
Responsive UI
08- Report
Report Hierarchy
Report Design
09- Filters
Dialogue + Call
10- Menus
Menu Design
Menu Frameset
Menu Special
11-UI : Responsive
Tables Responsive,Frame,position
List Group
Text
Panel Header, body, Footer
Button Button, Progress Bar
Icon & Button
Collapse Group, Panel
Notifications
12- Encryption
Encrypt
Decrypt
13- Windows
Dialogue
Picture, Frame, Button..
MsgBox
Grid
14- Cloud.
Account Open
15- Css, html, Php, js.
Insert Native language Begin_sw..End_Sw
16-Install + tools.
Installation & Configuration This Menu
Generate Native... Php, Html, js..
Code Generator Ms4 Script
MarkDown Ms4 Script
Source Code Menu Help This Menu
written with ms4script
     

BASIC HELP : MS4BI by MS4script 2019 version 1

Chapter 6 : CHARTS

KEYWORD : FORMIMAGE : DRAWSTEP

Definition

Based on the FORMIMAGE graphics library, displays Standard, Plot, scale of STEP charts .

Syntax

 	
	Table : 
	
	FormImage :	DrawSTEP, title : string/literal, 
		ImageAREA : (height) integer, (width) integer ,
	     TYPE : integer, FORMAT: string/literal  use View  ("Table Name or $MS4VIEWDBTMP ");
	or
	Array :
	FormImage :	DrawStep, title : string/literal, 
		ImageAREA : (height) integer, (width) integer ,
	     TYPE : integer, FORMAT: string/literal
		use  
 		array Label : literal 		:literal 1,literal 2,3,4 .....,
 		array value : literal	: integer 1,integer 2,3,4 .....;
	 
	

Example

 		   
 #includeSYSpathMS4BI "\zInclude\includeChart.h"  
 
 ***********************************************************	
BEGIN
 	 
ConnectDB{Ms4DB}(LEnvDemoExcelDB);  
FormImage : DrawSTEP, title : " STEP Standard Business 2011,2012,2013" ,
 ImageAera :700, 300 ,TYPE : $STANDARD,  FORMAT :"$" 
  use View  ("ms4EmplBusinessDollars20111213")  ;
 	   
END ;
 
 ** or ARRAY
 BEGIN
 ConnectDB{Ms4DB}(LEnvDemoExcelDB); 
 FormImage : DrawStep, title : " STEP Standard Product xxxxxxx" ,
 ImageAera :700, 300 ,TYPE : $STANDARD,  FORMAT :"Unit " 
 use  
 Array   Label : "Select Products" : "Apple","Banana","Orange","Lemon","Peach","Strawberry"    ,
 Array   Value :  "Probe1"         :  34,55,15,62,38,42    ,  
 array   Value :  "Probe1Weight"   :  15,30,20,19,15,10      ,  
 Array   Value :  "Probe2"         :  25,10,15,11,12,50    ,
 Array   Value :  "Probe2Weight"   :  16,10,14,10,14,16      ;
 	   
 END ;

	  

Prerequisites

- include header file : driver:\MondaySoftware\MS4BI\zInclude\IncludeChart.h
- ConnectDB{Ms4DB} (DB Name )

Remarks

IncludeChart.h :
integer : $STANDARD := 1 ; integer : $PLOT := 90 ;
integer : $NETWORK := 91 ;
integer : $SCALE := 92 ;

Chart type : (FORMSHOW ,FORMIMAGE, FORMMORRIS)

MS4SCRIPT : only ADD-ON MS4BI

See also

ToolBarExport, MS4_QUERY $MS4VIEWDBTMP



KEYWORD : FORMIMAGE : DRAWSTOCK

Definition

Based on the FORMIMAGE graphics library, displays STOCK charts .

Syntax

 	
 
	Array :
	FormImage :	DrawStock, title : string/literal, 
		ImageAREA : (height) integer, (width) integer ,
	     TYPE : integer, FORMAT: string/literal
		use  
 		array Label : literal 		:literal 1,literal 2,3,4 .....,
 		array value : literal	: integer 1,integer 2,3,4 .....;
	 
	

Example

 		   
 #includeSYSpathMS4BI "\zInclude\includeChart.h"  
 
BEGIN
 ConnectDB{Ms4DB}(LEnvDemoExcelDB); 
 FormImage : DrawStock, title : " STOCK Standard Product xxxxxxx" ,
 ImageAera :700, 300 ,TYPE : $STANDARD,  FORMAT :"$" 
 use  
 Array   Label : "Time"      :  "8h","10h","12h","14h","16h","18h" 
 Array   Value :  "Open"       :  34,55,15,62,38,42   ,  
 Array   Value :  "Close" 	  :  42,25,40,38,49,36     ,  
 Array   Value :  "Min"        :  27,14,12,25,32,32    ,
 Array   Value :  "Max"        :  45,59,47,65,64,48      ;
 END ;
	 
	  

Prerequisites

- include header file : driver:\MondaySoftware\MS4BI\zInclude\IncludeChart.h
- ConnectDB{Ms4DB} (DB Name )

Remarks

IncludeChart.h :
integer : $STANDARD := 1 ;
Chart type : (FORMSHOW ,FORMIMAGE, FORMMORRIS)

MS4SCRIPT : only ADD-ON MS4BI

See also

ToolBarExport, MS4_QUERY $MS4VIEWDBTMP



KEYWORD : FORMIMAGE : DRAWSPLINE

Definition

Based on the FORMIMAGE graphics library, displays Standard, Plot, scale of SPLINE charts .

Syntax

 	
	Table : 
	
	FormImage :	DrawSPLINE, title : string/literal, 
		ImageAREA : (height) integer, (width) integer ,
	     TYPE : integer, FORMAT: string/literal  use View  ("Table Name or $MS4VIEWDBTMP ");
	or
	Array :
	FormImage :	DrawSpline, title : string/literal, 
		ImageAREA : (height) integer, (width) integer ,
	     TYPE : integer, FORMAT: string/literal
		use  
 		array Label : literal 		:literal 1,literal 2,3,4 .....,
 		array value : literal	: integer 1,integer 2,3,4 .....;
	 
	
BEGIN

Example

 		   
 #includeSYSpathMS4BI "\zInclude\includeChart.h"  
 
 ***********************************************************	
BEGIN
 	 
ConnectDB{Ms4DB}(LEnvDemoExcelDB);  
FormImage : DrawSPLINE, title : " STEP Standard Business 2011,2012,2013" ,
 ImageAera :700, 300 ,TYPE : $STANDARD,  FORMAT :"$" 
  use View  ("ms4EmplBusinessDollars20111213")  ;
 	   
END ;
 
 ** or ARRAY
BEGIN
FormImage : DrawSpline, title : " SPLINE Standard  xxxxxxx" ,
ImageAera :700, 300 ,TYPE : $STANDARD,  FORMAT :"$" 
 use  
 Array   Label : "Time"      :  "8h","10h","12h","14h","16h","18h" 
 Array   Value :  "Open"       :  34,55,15,62,38,42   ,  
 Array   Value :  "Close" 	  :  42,25,40,38,49,36     ,  
 Array   Value :  "Min"        :  27,14,12,25,32,32    ,
 Array   Value :  "Max"        :  45,59,47,65,64,48      ;
 END ;

	  

Prerequisites

- include header file : driver:\MondaySoftware\MS4BI\zInclude\IncludeChart.h
- ConnectDB{Ms4DB} (DB Name )

Remarks

IncludeChart.h :
integer : $STANDARD := 1 ; integer : $PLOT := 90 ;

Chart type : (FORMSHOW ,FORMIMAGE, FORMMORRIS)

MS4SCRIPT : only ADD-ON MS4BI

See also

ToolBarExport, MS4_QUERY $MS4VIEWDBTMP



KEYWORD : FORMEXCEL : CHART

Definition

Based on the FORMEXCEL graphics library, displays PIE, BAR, SCATTER, RADAR, STEP, STOCK,BUBBLE... chart types.

Syntax

 	
 FormExcel : Chart(Chart type: integer) ,  title :  string/literal   use  View  ("[Table Name or $MS4VIEWDBTMP]"); 
		or
 FormExcel : Chart(Chart type: integer) , height : "xx%", width : "xx%" 
             title :  string/literal   use  View  ("[Table Name or $MS4VIEWDBTMP]"); 

		
 	

Example

 		   
 #includeSYSpathMS4BI "\zInclude\IncludeChartExcel.h"  
    BEGIN
 	   ConnectDB{Ms4DB}(LEnvDemoExcelDB); 
 		FormExcel : Chart(xlBAR) ,  title :  "xlBAR : Business 2011 by  EMPLOYEE " 
		use  View{Ms4DB} ("[ms4employeeTotalBusiness2011]"); 
    END;	
	  

Prerequisites

- include header file : driver:\MondaySoftware\MS4BI\zInclude\IncludeChartExcel.h
- ConnectDB{Ms4DB} (DB Name )

Remarks

IncludeChartExcel.h :

(70) Chart type :
define xlBAR 5 ** BAR.
define xlBARExploded 69 ** Exploded BAR.
define xlBAROfBAR 68 ** BAR of BAR.
define ....

MS4SCRIPT : only ADD-ON MS4BI

See also

ExcelExportImage_JPG, ToolBarExport



KEYWORD : EXCELEXPORTIMAGE_JPG

Definition

Based on the FORMEXCEL graphics library, exports charts in JPG image format.

Syntax

 	
 FormExcel : Chart(Chart type: integer) ,  title :  string/literal   use  View  ("[Table Name or $MS4VIEWDBTMP]"); 
 			ExcelExportImage_JPG( string/literal : Directory and JPG file name) ;		
 		
 	

Example

 		   
#includeSYSpathMS4BI "\zInclude\IncludeChartExcel.h"   
 
** ************************************************************
** EXPORT EXCEL CHART
** ***********************************************************	
 BEGIN
 	   ConnectDB{Ms4DB}(LEnvDemoExcelDB); 
		FormExcel : Chart(xl3DBAR), title :  " Business 2011 by  EMPLOYEE "  
		use   View  ("[ms4EmplTotalBusiness2011]")
			ExcelExportImage_JPG("c:\temp\ms4ImageExcelBAR3D1.jpg") ; 
 END;	
	  

Interested in our project? contact@monday-software.com
The Monday Software team


Copyright 2019 by Monday Software

the official sites :
www.monday-software.com
www.ms4bi.com
demos.ms4bi.com
getms4bi.com
getms4bifree.com
cloud.ms4bi.com
cloud.testing.ms4bi.com
www.ms4script.com

Our purpose : Keep it simple !


written with ms4script
  • MS4BI v.00.0005.02.2019
  • MS4BIRE v.00.0005.02.2019
  • MS4SCRIPT v.00.0005.02.2019
  • help 02/2019

MS4BI in 5 minutes