MS4BIĀ®

MS4BI HELP 2022

by MS4script
01-Introduction
Preface & Copyright
Getting started
Informations + Cmd/param Server
Demos Simple
02- Declarations
Structure
Type
03- Instructions
Conditions if,do,while..
Char/Text functions Char or Text..()
Get + Include functions Get, Include..
String functions String# (hashtag)
Date-Time Day, Time, Year.
Display
Call
Formulas Complex
04- Database
Connector Ado, Odbc, Dsn, SAP, Ms4
DB Connect Create, delete
Import DataSource Import, Consolidation
Administration Admin, User
05- Sql-Query
Sql
Query Form : BTS,Plus
Grid option
06- Charts
Forms Plus, 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.
DrawWindow [web]
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 Custom
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

Designer

00-OverView
01-Transaction
02-Setting
05-Import
10-Formula
15-Report-Part1
16-Report-Part2
20-Query-Part1
21-Query-Part2
25-Report-Query-Style
30-QrCodeImage
31-Windows
32-Frame
40-TabStrip
50-Collapse
60-BeginForm
63-Input-SubmitBox
70-Input-Select
71-Input-Insert
72-Input-Update
73-Input-Delete
75-Input-Query
77-ListComBo
81-Button-Link
82-Button-DataList
86-Sticky-Label
91-Insert-PhpJsHtml
92-Insert-MS4script
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

2022 version 1.10

Chapter 6 : CHARTS

KEYWORD : FormPlus : DRAWPIE

Definition

Based on the FormPlus graphics library, displays a classic or doughnut pie chart.

Syntax

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

Example 1

  	
	   
#include "#SYSPATHMS4BI+\zInclude\includeChart.h"  
 
 DBconnect{Ms4DB}(LEnvDemoExcelDB); 
 
 FormPlus :	DrawPIE , 
 title :"Example PIE Form" , ANGLE :120 , 
 TYPE : $STANDARD, FORMAT: "$"  use View  ("[ms4EmplTotalBusiness2011]");
	  or
 FormPlus : theme : "blueopal"    DrawPIE , height : "430",  width :"730", title :"" , ANGLE :120 , 
  TYPE : $STANDARD, FORMAT: "pers"  use View  ("[ms4TotalPopulByProvince]"); 
	

Example 2 : $MS4DBTMP : NB: This example can be applied to any and all chart types

  		
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 :	DrawPIE , title :" Business 2011 by  EMPLOYEE " , ANGLE :120 ,
	TYPE : $STANDARD, FORMAT: "$"  use   View  ($MS4VIEWDBTMP)   ;
 	

DrawPIE , Business 2011

Nb products by EMPLOYEE

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 : $STANDARD := 1 ;
integer : $DONUT := 2 ;


MS4SCRIPT : only ADD-ON MS4BI

See also

ToolBarExport, MS4_QUERY $MS4VIEWDBTMP



KEYWORD : FormPchart : DRAWPIE

Definition

Based on the FormPchart graphics library, displays a classic, doughnut or 3D pie chart.

Syntax

  	
 	 Table :  
	
	-- FormPchart :	DrawPIE, title : string/literal,  
	 	ImageArea : (height) integer, (width) integer ,
		Radius :integer, POSITION :  horizontal coordinate integer, verticle coordinate integer ,  
	    TYPE : integer, FORMAT: string/literal  use View  ("Table Name or $MS4VIEWDBTMP ");
	or
	 Array : 
	FormPchart :	DrawPIE, title : string/literal, 
		ImageArea : (height) integer, (width) integer ,
		Radius :integer, POSITION :  horizontal coordinate integer, verticle coordinate 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 :	DrawPIE, title : " Business 2011 by  EMPLOYEE " , 
		ImageArea : 800, 500 ,
		Radius :120,POSITION :360, 270 , TYPE : $STANDARD, FORMAT: "dollars$"  
  END
 ** or ARRAY
  	FormPchart :	DrawChartPIE, title : " TITLE X XXXXXXXXXXXXXXXXXXXXX " , 
		ImageArea : 800, 500 ,
		Radius :120, POSITION :360, 270 , TYPE : $STANDARD, FORMAT: "UNIT % $ etc.."  
		use  
 		array Label : "Labels" 		:"A0","B1","C2","D3","E4","F5","G6","H7","I8","J9",
 		array value : "Application " 	: 50,2,3,4,7,10,25,48,41,10;

	  

Pchart : DrawPIE standard

Business 2011 by EMPLOYEE

Visualise Example : FormPchart Pie
Source & Copy FormPchart Pie
Visualise ALL EXAMPLES : FormPchart Pie
Visualise ALL CHART EXAMPLES

Prerequisites

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

Remarks

IncludeChart.h :

Chart type :
integer : $STANDARD := 1 ;
integer : $DONUT := 2 ;
integer : $3DPIE := 3 ;

MS4SCRIPT : only ADD-ON MS4BI

See also

ToolBarExport, MS4_QUERY $MS4VIEWDBTMP



KEYWORD : FORMMORRIS : DRAWPIE

Definition

Based on the FORMMORRIS graphics library, displays a classic or doughnut pie chart.

Syntax

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

Example

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

	  

Morris : DrawPie standard

-bkb- Exampe PIE Form Morris
Visualise Example : FormMorris Pie
Source FormMorris Pie
Source & Copy FormMorris Pie
Visualise ALL CHART EXAMPLES

Prerequisites

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

Remarks

IncludeChart.h :

Chart type :
integer : $STANDARD := 1 ;
integer : $DONUT := 2 ;


MS4SCRIPT : only ADD-ON MS4BI

See also

ToolBarExport, MS4_QUERY $MS4VIEWDBTMP



KEYWORD : FORMEXCEL : CHART

Definition

Based on the FORMEXCEL graphics library, displays charts in PIE, BAR, SCATTER, RADAR etc. format.

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

Excel : DraPie standard

xlPie : Business 2011 by EMPLOYEE

Visualise Example : FormExcel Pie
Source & Copy FormExcel Pie
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 xlPie 5 ** Pie.
define xlPieExploded 69 ** Exploded Pie.
define xlPieOfPie 68 ** Pie of Pie.
define ....

MS4SCRIPT : only ADD-ON MS4BI

See also

ToolBarExport, MS4_QUERY $MS4VIEWDBTMP



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(xl3DPie), title :  " Business 2011 by  EMPLOYEE "  
		use   View  ("[ms4EmplTotalBusiness2011]")
			ExcelExportImage_JPG("c:\temp\ms4ImageExcelPIE3D1.jpg") ; 
 END;	
	  

Remarks

It s a same syntax for ChartJS,Google..

Syntax

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

Google : DrawPie standard

MS4BI : PIE (google chart) Business 2011 by EMPLOYEE
Visualise ALL EXAMPLES : FormGoogle
Visualise ALL CHART Examples

ChartJs : DrawPie standard

-bkb- Business 2011 12 13 by EMPLOYEE

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

Visualise ALL EXAMPLES : FormCharJs
Visualise ALL CHART Examples

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