Simple :
	
	 FormPlus :	DrawBAR  ,  title : string/literal ,  
	  TYPE : integer, FORMAT: string/literal  use View  ("Table Name or $MS4VIEWDBTMP ");
	  
	or 
	
	FormPlus : optional theme : string/literal     
	DrawBAR , optional height : integer, 	width :integer , 
	title :string/literal ,  
      TYPE : integer, FORMAT: string/literal  use View  ("Table Name or $MS4VIEWDBTMP ");
	
	

  		   
#include "#SYSPATHMS4BI+\zInclude\includeChart.h"  
 
 DBconnect{Ms4DB}(LEnvDemoExcelDB); 
 FormPlus : DrawBAR, title : "  Business 2012 by  EMPLOYEE "  , TYPE : $COLUMN , FORMAT :"$" 
                        use View   ("[ms4EmplTotalBusiness2012]")  ;

 FormPlus : theme : "blueopal"    DrawBAR , height : "430",  width :"730", title :"" ,  
  TYPE : $STANDARD, FORMAT: "pers"  use View  ("[ms4TotalPopulByProvince]"); 
	

  		   
#include  "#SYSPATHMS4BI+\zInclude\includeChart.h"
text :   tabname :="ms4EmplTotalBusiness2011"  ,varname := "%a%"; 
 
DBconnect{ms4DB}(LEnvDemoExcelDB); 
Ms4_query{ms4db}  option : into  $MS4DBTMP 
  (" SELECT  *    from  [%s]   as a  where a.LASTNAME LIKE '%s' ",tabname,varname) ;

  DBconnect{Ms4DB}($MS4DBTMP);
	 FormPlus  :	DrawBAR , title :" Business 2011 by  EMPLOYEE " ,  
	 TYPE :  $COLUMN,  FORMAT: "$"  use View ($MS4VIEWDBTMP)   ;
 	

Visualise Example : FormPlus BAR
Source & Copy FormPlus BAR

Visualise ALL EXAMPLES : FormPlus BAR
Visualise ALL CHART EXAMPLES

Prerequisites

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

Remarks

IncludeChart.h :
THEME :
CONSTANT_STRING :
**theme Form Plus (ONLY)
$theme_default "default",
$theme_bts "bootstrap",
$theme_metro "metro",
$theme_moonlight "moonlight",
$theme_blueopal "blueopal",
$theme_silver "silver",
$theme_uniform "uniform",
$theme_flat "flat";
Visualise chart themes for FormPlus

Chart type : (FormPlus ,FormPchart, FORMMORRIS)
integer : $COLUMN :=1 ;
integer : $BAR :=2 ;
integer : $LINE :=3 ;
integer : $STACK :=4 ;
integer : $AREA :=5 ;
integer : $STACKVERTICAL :=7 ;
integer : $STACKGRADIENT := 8;
integer : $STACKVERTICALGRADIENT := 9;
integer : $STACKSHADED := 10;
integer : $AREAOVERLAY :=11 ;


MS4SCRIPT : only ADD-ON MS4BI

See also

ToolBarExport, MS4_QUERY $MS4VIEWDBTMP

---

KEYWORD : FormPchart : DRAWBAR

Definition

Based on the FormPchart graphics library, displays VERTICAL, HORIZONTAL, STACKED, LINE or AREA bar charts .

Syntax

  	
	  Table : 
	
	FormPchart :	DrawBAR, title : string/literal, 
		ImageAREA : (height) integer, (width) integer ,
	     TYPE : integer, FORMAT: string/literal  use View  ("Table Name or $MS4VIEWDBTMP ");
	or
	Array : 
	FormPchart :	DrawBAR, 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 /* table */
 	 DBconnect{Ms4DB}(LEnvDemoExcelDB); 
	  FormPchart  : DrawBAR, title : " Business 2011 by  EMPLOYEE " ,
		   ImageArea : 800, 500 ,	  TYPE :   $BAR   , FORMAT :"$" 
		   use View   ("  [ms4EmplTotalBusiness2012]")  ;
   END
 ** or ARRAY
   DBconnect{Ms4DB}(LEnvDemoExcelDB); 
   FormPchart : DrawBAR, title : " Hits by server " ,
   ImageArea : 700, 350 ,	  TYPE :  $BAR   , FORMAT : "Hits " 
    use  
     Array   Label : "Months"  :  "Jan" , "Feb","Mar","Apr","May","Jun","Jul","Aug","Sep"  , 
     Array   Value : "Server A" :  150,220,300,-250,-420,-200,300,200,100  ,
     Array   Value : "Server B" :  140,0,340,-300,-320,-300,200,100,50 ;

	  

Pchart : DrawBar standard

Business 2011 by EMPLOYEE

Visualise Example : FormPchart BAR
Source & Copy FormPchart BAR

Visualise ALL EXAMPLES : FormPchart BAR
Visualise ALL CHART EXAMPLES

Prerequisites

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

Remarks

IncludeChart.h :

Chart type : (FormPlus ,FormPchart, FormMorris, FormGoogle,FormChartJs ..)
see Remarks for FormPlus : DRAWBAR


MS4SCRIPT : only ADD-ON MS4BI

See also

ToolBarExport, MS4_QUERY $MS4VIEWDBTMP

---

KEYWORD : FORMMORRIS : DRAWBAR

Definition

Based on the FORMMORRIS graphics library, displays a classic, line, stacked or overlay BAR chart

Syntax

  	
  
   /r  FormMorris :	/R DrawBAR , 
	 title : string/literal ,  
	  TYPE : integer, FORMAT: string/literal  use View  ("[Table Name or $MS4VIEWDBTMP]");
 	  
	

Example

  		   
 #include "#SYSPATHMS4BI+\zInclude\includeChart.h"  
 
  DBconnect{Ms4DB}(LEnvDemoExcelDB); 
 
     FormMorris :	DrawBAR , 
	 title :"-bkb-   Example Morris Form BAR" ,  
	  TYPE : $COLUMN, FORMAT: "$"  use View  ("[ms4EmplTotalBusiness2011]");

	  

Morris : DrawBar standard

-bkb- Business 2011,12,13 by EMPLOYEE

Visualise Example : FormMorris BAR
Source & Copy FormMorris BAR

Visualise ALL Examples : FormMorris BAR
Visualise ALL CHART examples

Prerequisites

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

Remarks

IncludeChart.h :

Chart type : (FormPlus ,FormPchart, FORMMORRIS)
see FormPlus remarks


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... 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(xlBAR) ,  title :  "xlBAR : Business 2011 by  EMPLOYEE " 
		use  View{Ms4DB} ("[ms4employeeTotalBusiness2011]"); 
    END;	
	  

Excel : DrawBar standard

type xlColumnStacked : Business 2011,2012,2013 by EMPLOYEE

Visualise Example : FormExcel BAR
Source & Copy FormExcel BAR

Visualise ALL Examples : FormExcel BAR
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 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

  		   
#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;	
	  

Remarks

It s a same syntax for ChartJS,Google..

Syntax

  	
	 Simple :
	 
	 Formgoogle  :	DrawBAR ,  title : string/literal ,  
	  TYPE : integer, FORMAT: string/literal  use View  ("Table Name or $MS4VIEWDBTMP ");
 	
	

Google : DrawBar standard

MS4BI : Bar (Google chart ) Business 2011 by EMPLOYEE : HORIZONTAL

>link>Help Bar (google chart)

ChartJs : DrawBar standard

-bkb- Business 2011 12 13 by EMPLOYEE

CopyRight ChartJs, is open source and available under the MIT license.

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