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

#include  "#SYSPATHMS4BI+\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\99-DATABASE\VersionADO\300-00-CreateDBDemoExcel.ms4" 
** *****************************************
** REPORT
** ***************************************** 

	DECLARE SCHEMA_Report : Employees
	{ TEXT    : LastName ; 
	  INTEGER : EmployeeID ;
	 };
 
 	DECLARE  SCHEMA_REPORT :   Orders
	{ TEXT    : ProductName, CustomerID ,  ShipName, ShipAddress,	ShipCity,ShipRegion,ShipPostalCode,ShipCountry ;
	  INTEGER : OrderID ,EmployeeID,ProductID ,Quantity;	
	  FLOAT   : unitprice  dec(2); 
	} ;
 
<MS4>  ** start  page web
** ****************
** web script + Notes Confidential
** ************************************
 

 
Begin_Report
  
 REPORTINPUT :   DBconnect {Ms4DB}(LEnvDemoExcelDB) use View  ("[ms4EmplConsolidationBusiness]") 
   REPORTFORM:AGGREGATE , TITLE : " EXCEL Informations and Consolidation : REPORT   EMPLOYEE orders COUNT AND SUM unit price " 
             Option  : 
			 BEGIN 
			   EXPORTEXCEL : yes   ,
               pagesize : 1000			   
			  END OPTION  
	          AGGREGATE  BY       :      Employees.EmployeeID  , 
										Orders.OrderID  COUNT ,  ** <-----------COUNT
												Orders.unitprice SUM  , ** <-----------SUM
       	 			    
   	 	DETAIL AGGREGATE    : 
	    
		            Employees.EmployeeID ,    TITLE "EMPLOYEE"  , 
				  
		 		    Orders.OrderID   ,        TITLE "ORDER"  , 
					 Orders.unitprice  ,     TITLE "Unit price "  ,
				    Orders.ShipName ,         TITLE " ship Name "  ,
 	  			    Orders.ShipCity  ,        TITLE "city"   
	 		 
   END_REPORT ;
    Begin_Sw                /* Script Web  */
<style>  
   .k-grid { border-bottom: none;   font-size: 9px;}  
   .k-header { background-color:green;color:yellow;font-family:tahoma;font-size:18px; } 
   .k-header.k-link { color:black; } 
   .k-state-selected { background-color:orange;background-image:none;color:red;} 
   .k-alt.k-state-selected  { background-color:green;background-image:none;color:white;} 
    tr { font-family:arial;font-size:11px;color:black;border-bottom:solid 14px #DBDEE1;height:21px;} 
   .k-alt { background-color:#dff7ae; } 
    .k-grid td { line-height: 2; padding:0px 10px;margin:0px;border-bottom:solid 2px green;  } 
    .k-grid-header { padding:0px 0px;margin:0px; font-size: 39px;} 
  </style> 
  End_Sw ;
</MS4> ;