Simple :
	
	FormPlus :	DrawRADAR ,  title : string/literal ,  
	  TYPE : integer   use View  ("Table Name or $MS4VIEWDBTMP ");
	  
	or 
	
	FormPlus : optional theme : string/literal     
	DrawRADAR , optional height : integer, 	width :integer , 
	title :string/literal ,  
      TYPE : integer  use View  ("Table Name or $MS4VIEWDBTMP ");
	  
	  TYPE: integer= $RDLine or $RDColumn or $RDAera 
	
	

  		   
#include "#SYSPATHMS4BI+\zInclude\includeChart.h"  
 
 DBconnect{Ms4DB}(LEnvDemoExcelDB); 
 	  FormPlus :	DrawRADAR, title : "  RADAR Line  Business 2011 by  EMPLOYEE "  , TYPE : $RDLINE   
			use View   (" [ms4EmplTotalBusiness2012]")  ;

 FormPlus : theme : "blueopal"    DrawRADAR , height : "430",  width :"730",   
 	title : "  RADAR Line  Business 2011 by  EMPLOYEE "  , TYPE : $RDCOLUMN    
			use View   (" [ms4EmplTotalBusiness2012]")  ;
	

  		   
#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 :	DrawRADAR , title :" Business 2011 by  EMPLOYEE " ,  
	TYPE : $RDCOLUMN    use   View  ($MS4VIEWDBTMP)   ;
 	

Visualise Example : FormPlus RADAR
Source & Copy FormPlus RADAR

Visualise ALL Examples : FormPlus
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)
integer : $RDLINE := 71 ;
integer : $RDAREA := 72 ;
integer : $RDCOLUMN := 73 ;
integer : $RDSTAR := 74 ;
integer : $RDCIRCLE := 75 ;



MS4SCRIPT : only ADD-ON MS4BI

See also

ToolBarExport, MS4_QUERY $MS4VIEWDBTMP,

---

KEYWORD : FormPchart : DRAWRADAR

Definition

Based on the FormPchart grahics library, displays a classic VERTICAL,HORIZONTAL, STACK ,LINE or AREA RADAR chart.

Syntax

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

Example

  		   
 #include "#SYSPATHMS4BI+\zInclude\includeChart.h"  
 
 BEGIN /* table */
 	 DBconnect{Ms4DB}(LEnvDemoExcelDB); 
	  FormPchart : DrawRADAR, title : " Business 2011 by  EMPLOYEE " ,
		   ImageArea : 800, 500 ,	  TYPE :  $RDCIRCLE,  FORMAT :"$" 
		   use View   ("  [ms4EmplTotalBusiness2012]")  ;
   END
 ** or ARRAY
   DBconnect{Ms4DB}(LEnvDemoExcelDB); 
  FormPchart : DrawRADAR, title : " RADAR Standard   xxxxxxx" ,
  ImageArea :500, 300 ,TYPE : $RDSTAR,  FORMAT :"$" 
  use  
 Array  Label   : "Coord "      : "40","80","120","160","200","240","280","320","360"  ,
 Array   value  : "ScoreA"      :  10,20,30,40,50,60,70,80,90 ,
 Array   Value  :  "ScoreB"     :  20,40,50,12,10,30,40,50,60 ;

	  

Pchart : DrawRadar standard

RADAR Standard/ CERCLE xxxxxxx

Visualise Example : FormPchart RADAR
Source & Copy FormPchart RADAR

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 :

chart type : (FormPlus ,FormPchart )
goto to see FormPlus


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... charts.

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(xlRadar),  title :  " type xlRadar : Business 2011,2012,2013 by  EMPLOYEE "
		use View   (" [ms4EmplBusinessDollars20111213]")  ; 
    END ;	
	  

Pchart : DrawRadar standard

type xlRadarMarkers : Business 2011,2012,2013 by EMPLOYEE

Visualise Example : FormExcel RADAR
Source & Copy FormExcel RADAR

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 xlRadar -4151 ** Radar.
define xlRadarFilled 82 ** Filled Radar.
define xlRadarMarkers 81 ** Radar with Data Markers.
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(xl3DRADAR), title :  " Business 2011 by  EMPLOYEE "  
		use   View  ("[ms4EmplTotalBusiness2011]")
			ExcelExportImage_JPG("c:\temp\ms4ImageExcelRADAR3D1.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