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

  		   
DBconnect{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]")   ,
 
    FormPlus :  DrawQrCODE type : $MAIL ("http://www.mgplanete.com")  					
 END_DASHBOARD ;     
	

Visualise example
Source & Copy DashBoard NO TAB

Visualise ALL Examples : Basic DashBoard
Visualise ALL DashBoard examples

Prerequisites

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

Remarks

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

See also

MS4_QUERY:WEB, MS4_QUERY:WIN, FORMXXX
Examples :
driver:\MandragorePlanete\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   ',  Ms4Script_Import : ....... 
	  	TabTitle : 'title 2  ', FormMS4 :  DrawGrid  .......    
		 FormPlus : theme : "blueopal"	DrawPIE....... 
		TabTitle : "title 3   " ,   FormPlus : theme : "bootstrap" DrawRADAR, .......   
			....      
	 END_DASHBOARD ;  	
	

Example

  		   
DBconnect{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 :  FormPlus : DrawChartBAR, title : "   Business 2011 by  EMPLOYEE "  , 
          TYPE : $COLUMN ,format :" account"   use View  ("[ms4EmplTotalBusiness2011]")  
                                  
       DrawWindow  : Standard ,"Win2" position : 100,610,500,600  
	   TITLE : "2 Web: URL Window 2" 
         Insertchart : FormPlus : DrawChartPIE, title : "PIE  Business 2011 by  EMPLOYEE " , 
          ANGLE :120 , TYPE : $STANDARD, FORMAT: "$" use View  ("[ms4EmplTotalBusiness2011]") 
   
  END_DASHBOARD ;      
	

Visualise example
Source & Copy DashBoard FRAME

Visualise ALL Examples : Basic DashBoard
Visualise ALL DashBoard examples

Prerequisites

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

Remarks

-IncludeChart.h :

See also

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

---

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