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 7 : DASHBOARDS

KEYWORD : BEGIN_DASHBOARD TABstrip END_DASHBOARD

Definition

Creates a TABstrip type dashboard, including charts and reports

Syntax

  	
	BEGIN_DASHBOARD  
		option :
		BEGIN
		type  : $TABSTRIP , 	  	title :   ""  
		END
		TabTitle : 'title 1   ',  DrawReport : ....... 
	  	TabTitle : 'title 2  ', FormMS4 :  DrawGrid  .......    
		 FormShow : theme : "blueopal"	DrawPIE....... 
		TabTitle : "title 3   " ,   FormShow : theme : "bootstrap" DrawRADAR, .......   
			....      
	END_DASHBOARD ;  	
	

Example

 		   
       BEGIN_DASHBOARD  
		option :
		BEGIN
		type  : $TABSTRIP , 	  	title :   ""  
		END
		TabTitle : 'My Aggregate Report  ',  DrawReport : ....... 
	  	TabTitle : 'My Excel Consolidation ', FormShow :  DrawGrid  .......    
			FormShow : theme : "blueopal"	DrawPIE....... 
		TabTitle : "Radar  " ,   FormShow : theme : "bootstrap" DrawRADAR, .......   
			....      
	END_DASHBOARD ; 
	

Prerequisites

CONNECTDB {driver} ("['your MS4BI DB name']")

Remarks

IncludeChart.h :
type : $TABSTRIP ;
integer : $TABSTRIP := 0 ;
integer : $NOTABSTRIP := 1 ;

See also

MS4_QUERY:WEB, MS4_QUERY:WIN, FORMXXX
Examples :
driver:\MondaySoftware\MS4BI\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\4-DASHBOARD



KEYWORD : BEGIN_DASHBOARD NOTABstrip END_DASHBOARD

Definition

Creates a non-tabstrip style dashboard, including charts and reports

Syntax

  	
	BEGIN_DASHBOARD  
		option :
		BEGIN
		type  : $NOTABSTRIP , 	  	title :   ""  
		END
		TabTitle : 'title 1   ',  DrawReport : ....... 
	  	TabTitle : 'title 2  ', FormMS4 :  DrawGrid  .......    
		 FormShow : theme : "blueopal"	DrawPIE....... 
		TabTitle : "title 3   " ,   FormShow : theme : "bootstrap" DrawRADAR, .......   
			....      
	END_DASHBOARD ;  	
	

Example 1

 		   
ConnectDB{Ms4DB}(LEnvDemoExcelDB); 
   
  BEGIN_DASHBOARD  option : 
	BEGIN
		type  : $NOTABSTRIP , 
		style : $blue  ,  
		title : "  EXCEL FORM DASHBOARD : EXCEL CHART AND GRID - BUSINESS ANALYSIS 2011,12,13 -" 
	END
    FormExcel : DrawGrid , title : " Standard Excel format grid  " ,  
	   use View  ("ms4EmplBusinessDollars20111213") ,
    FormMs4  : DrawGrid , title : " Standard Grid MS4 Form" 
     Option  : 
      BEGIN 
        Height : 330,
        Width  : 380 ,
        Footer : Sum, Count, Average
      END use View  ("ms4EmplBusinessDollars20111213") ,
    FormExcel : Chart(xlPyramidCol) ,  title :  " type xlPyramidCol : Business 2011,.. by  EMPLOYEE "  
use View   (" [ms4EmplBusinessDollars20111213]")  ,
    FormExcel : Chart(xlConeBarStacked) ,  title :" type xlConeBarStacked : Business ... by EMPLOYEE "   
use View   (" [ms4EmplBusinessDollars20111213]")   ,
 
    FormShow :  DrawQrCODE type : $MAIL ("http://www.monday-software.com")  					
 END_DASHBOARD ;     
	

Example 2 : INCLUDE A STYLE SHEET

 	
	BEGIN_DASHBOARD 
   option :
         BEGIN
          type  : $NOTABSTRIP , 
          style : $blue  ,  
          title : "  DASHBOARD :  BUSINESS ANALYSIS 2011 "            LinkCss: #includeSYSpathMS4BI "\zInclude\css\StandardStyleDashboardColumn.css"
        END
	

Prerequisites

CONNECTDB {driver} ("['your MS4BI DB name']")

Remarks

-IncludeChart.h :
type : $TABSTRIP ;
integer : $TABSTRIP := 0 ;
integer : $NOTABSTRIP := 1 ;
- Inclure un style :
LinkCss: #includeSYSpathMS4BI "\zInclude\css\Name---.css"

See also

MS4_QUERY:WEB, MS4_QUERY:WIN, FORMXXX
Examples :
driver:\MondaySoftware\MS4BI\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\4-DASHBOARD



KEYWORD : BEGIN_DASHBOARDFRAME .. END_DASHBOARD

Definition

Creates a frame type dashboard including charts and reports in MS WINDOWS windows.

Syntax

  	
	BEGIN_DASHBOARDFRAME  
		option :
		BEGIN
	   	title :   "title"  
		END
		TabTitle : 'title 1   ',  DrawReport : ....... 
	  	TabTitle : 'title 2  ', FormMS4 :  DrawGrid  .......    
		 FormShow : theme : "blueopal"	DrawPIE....... 
		TabTitle : "title 3   " ,   FormShow : theme : "bootstrap" DrawRADAR, .......   
			....      
	END_DASHBOARD ;  	
	

Example

 		   
ConnectDB{Ms4DB}(LEnvDemoExcelDB); 
 
  BEGIN_DASHBOARDFRAME  
    option :
       BEGIN
           style : $blue  ,  
           title : "  DASHBOARD : BUSINESS ANALYSIS 2011"
       END
       DrawWindow  : Standard ,"Win1" position : 100,10,500,600  
	   TITLE : "Web: URL Window 1" 
           Insertchart :  FormShow : DrawChartBAR, title : "   Business 2011 by  EMPLOYEE "  , 
          TYPE : $VERTICAL ,format :" account"   use View  ("[ms4EmplTotalBusiness2011]")  
                                  
       DrawWindow  : Standard ,"Win2" position : 100,610,500,600  
	   TITLE : "2 Web: URL Window 2" 
         Insertchart : FormShow : DrawChartPIE, title : "PIE  Business 2011 by  EMPLOYEE " , 
          ANGLE :120 , TYPE : $STANDARD, FORMAT: "$" use View  ("[ms4EmplTotalBusiness2011]") 
   
  END_DASHBOARD ;      
	

Prerequisites

CONNECTDB {driver} ("['your MS4BI DB name']")

Remarks

-IncludeChart.h :

See also

MS4_QUERY:WEB, MS4_QUERY:WIN, FORMXXX
Examples :
driver:\MondaySoftware\MS4BI\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\4-DASHBOARD



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


Copyright 2020 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.01.0027.01.2020
  • MS4BIRE v.01.0021.10.2019
  • MS4SCRIPT v.01.0027.01.2020
  • help 06/2019

MS4BI in 5 minutes