** ****************************************************************************************** *
** (ms4 script) - MS4 BI PROFESSIONAL for WINDOWS & WEB-
** *******************************************************************************************

#include  "#SYSPATHMS4BI+\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\99-DATABASE\VersionADO\300-00-CreateDBDemoExcel.ms4" 
 
** ************************************************************
** DISPLAY PIE CHART
** ***********************************************************	
	  DBconnect{Ms4DB}(LEnvDemoExcelDB); 
		
Display " Dashboard .........";
  BEGIN_DASHBOARDFRAME  
 option :
       BEGIN
		type  : $TABSTRIP , 
		style : $metro ,  
		title :  "  DASHBOARD :  ANALYSIS BUSINESS 2011" 
		LinkCss: #include  "#SYSPATHMS4BI+\zInclude\css\StandardStyleDashboardColumn.css" 
	END  
 	 
 		DrawWindow : "Win1" , actions : $WinCustom +  $WinMinimize + $WinMaximize + $WinClose ,  position : 100,10,500,600  TITLE : "1 Window Web: URL" 
		Insertchart :  FormPlus : DrawBAR, title : " CHART BAR VERTICAL :  Business 2011 by  EMPLOYEE "  , TYPE : $COLUMN ,format :" account"  
								use View  ("[ms4EmplTotalBusiness2011]")  ;
	 							
  		DrawWindow : "Win2" , actions : $WinCustom +  $WinMinimize + $WinMaximize + $WinClose , position : 100,610,500,600  TITLE : "2 Window Web: URL" 
		Insertchart : FormPlus : DrawPIE, title :"PIE  Business 2011 by  EMPLOYEE " , ANGLE :120 , TYPE : $STANDARD, FORMAT: "$"  
                                                                use View  ("[ms4EmplTotalBusiness2011]") ;
 
                DrawWindow : "Win3" , actions : $WinCustom +  $WinMinimize + $WinMaximize + $WinClose ,  position : 170,350,500,600  TITLE : "3 Window Web: URL" 
		Insertchart : FormPlus :  DrawBAR, title : "BAR PLOT Business 2011,201,2013 by  EMPLOYEE ",
				  Type :  $BAR  , FORMAT :"$" , 
				  Plot :  from 1  to 60000   ** Plot  1
					  from 60000  to 120000   ** Plot  2
                              use View   (" [ms4EmplBusinessDollars20111213]")  ;
  END_DASHBOARD ;