Table : 
	
	FormPchart :	DrawSTEP, title : string/literal, 
		ImageAREA : (height) integer, (width) integer ,
	     TYPE : integer, FORMAT: string/literal  use View  ("Table Name or $MS4VIEWDBTMP ");
	or
	Array :
	FormPchart :	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 .....;
	 
	

  		   
 #include "#SYSPATHMS4BI+\zInclude\includeChart.h"  
 
 ***********************************************************	
BEGIN
 	 
DBconnect{Ms4DB}(LEnvDemoExcelDB);  
FormPchart : DrawSTEP, title : " STEP Standard Business 2011,2012,2013" ,
 ImageAera :700, 300 ,TYPE : $STANDARD,  FORMAT :"$" 
  use View  ("ms4EmplBusinessDollars20111213")  ;
 	   
END ;
 
 ** or ARRAY
 BEGIN
 DBconnect{Ms4DB}(LEnvDemoExcelDB); 
 FormPchart : 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 ;

	  

Source & Copy : FormPchart STEP
Visualise Example : FormPchart STEP Scale
Source & Copy : FormPchart STEP Scale
Visualise Example : FormPchart STEP Plot
Source & Copy : FormPchart STEP Plot

Visualise ALL Examples : FormPchart
Visualise ALL CHART examples

Prerequisites

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

Remarks

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

Chart type : (FormPlus ,FormPchart, FORMMORRIS)

MS4SCRIPT : only ADD-ON MS4BI

See also

ToolBarExport, MS4_QUERY $MS4VIEWDBTMP

---

KEYWORD : FormPchart : DRAWSTOCK

Definition

Based on the FormPchart graphics library, displays STOCK charts .

Syntax

  	
 
	Array :
	FormPchart :	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

  		   
 #include "#SYSPATHMS4BI+\zInclude\includeChart.h"  
 
BEGIN
 DBconnect{Ms4DB}(LEnvDemoExcelDB); 
 FormPchart : 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 ;
	 
	  

FormPchart STOCK

STOCK Standard Open/Close (only !!!!)

Source & Copy FormPchart STOCK

Visualise ALL Examples : FormPchart
Visualise ALL CHART examples

Prerequisites

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

Remarks

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

MS4SCRIPT : only ADD-ON MS4BI

See also

ToolBarExport, MS4_QUERY $MS4VIEWDBTMP

---

KEYWORD : FormPchart : DRAWSPLINE

Definition

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

Syntax

  	
	Table : 
	
	 FormPchart :	DrawSPLINE, title : string/literal, 
		ImageAREA : (height) integer, (width) integer ,
	     TYPE : integer, FORMAT: string/literal  use View  ("Table Name or $MS4VIEWDBTMP ");
	or
	Array :
	FormPchart :	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

  		   
 #include "#SYSPATHMS4BI+\zInclude\includeChart.h"  
 
 ***********************************************************	
BEGIN
 	 
DBconnect{Ms4DB}(LEnvDemoExcelDB);  
FormPchart : DrawSPLINE, title : " STEP Standard Business 2011,2012,2013" ,
 ImageAera :700, 300 ,TYPE : $STANDARD,  FORMAT :"$" 
  use View  ("ms4EmplBusinessDollars20111213")  ;
 	   
END ;
 
 ** or ARRAY
BEGIN
FormPchart : 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 ;

	  

FormPchart SPLINE

SPLINE standard Business 2011,2012,2013

Source & Copy FormPchart SPLINE
Visualise Example : FormPchart SPLINE Plot
Source & Copy : FormPchart SPLINE Plot

Visualise ALL Examples : FormPchart
Visualise ALL CHART examples

Prerequisites

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

Remarks

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

Chart type : (FormPlus ,FormPchart, FORMMORRIS)

MS4SCRIPT : only ADD-ON MS4BI

See also

ToolBarExport, MS4_QUERY $MS4VIEWDBTMP

---

KEYWORD : FORMEXCEL : CHART

Definition

Based on the EXCEL 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

  		   
 #include  "#SYSPATHMS4BI+\zInclude\IncludeChartExcel.h"  
    BEGIN
 	   DBconnect{Ms4DB}(LEnvDemoExcelDB); 
 		FormExcel : Chart(xlSurface),  height : "50%", width : "90%"  , title :  " type xlSurface : Business 2011,2012,2013 by  EMPLOYEE " 
                 use View   (" [ms4EmplBusinessDollars20111213]")  ; 
    END;	
	  

Excel : surface

type xlSurface : Business 2011,2012,2013 by EMPLOYEE

Visualise Example : FormExcel Bar
Source & Copy FormExcel Bar

Visualise ALL Examples : FormExcel
Visualise ALL CHART examples

Prerequisites

- include header file : driver:\MandragorePlanete\MS4BI\zInclude\IncludeChartExcel.h
- DBconnect{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 EXCEL 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

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

Interested in joining us? contact@mgplanete.com
The Mg Planete team

---

Copyright 2022 by Mandragore Planete

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

---

Download

official site :
getms4bi.com

---

Our purpose : Keep it simple !

written with ms4script

• help 01.010.2022.8

MS4BI in 5 minutes