** ****************************************************************************************** *
** (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 ,FirstName; 
	  INTEGER : EmployeeID ;
	 };
 
 	DECLARE  SCHEMA_REPORT :   Orders
	{ TEXT    : ProductName, CustomerID ,  ShipName, ShipAddress,	ShipCity,ShipRegion,ShipPostalCode,ShipCountry ;
	  INTEGER : OrderID ,EmployeeID,ProductID ,Quantity;	
	  FLOAT   : unitprice  dec(2); 
	} ;
 

Begin_Report
 
 REPORTINPUT :   DBconnect {Ms4DB}(LEnvDemoExcelDB) use View  ("[ms4EmplConsolidationBusiness]") 
   REPORTFORM:AGGREGATE , TITLE : " EXCEL Informations and Consolidation : REPORT   EMPLOYEE orders BY SHIP COUNTRY " 
   Option  :  BEGIN pagesize:300 ,style:$MS4BLUE END OPTION  
	        AGGREGATE  BY       :               Employees.EmployeeID   ,   Orders.Shipcountry 
       	 			    
   	 	DETAIL AGGREGATE    :    
		  Employees.EmployeeID   ,        TITLE "Employee"  , 
		  Employees.LastName   ,        TITLE "LastName"  , 
		  Employees.FirstName   ,        TITLE "FirstName"  , 
				    Orders.OrderID   ,        TITLE "ORDER"  , 
					orders.unitprice ,        TITLE "Price ",
				    Orders.ShipName ,         TITLE " ship Name "  ,
 				    Orders.ShipAddress  ,     TITLE "Adress"   ,
   				    Orders.ShipCity  ,        TITLE "city"   ,
				    Orders.ShipRegion  ,      TITLE "Region"   ,
				    Orders.ShipPostalCode  ,  TITLE "Postal code "   ,
				    Orders.Shipcountry  ,     TITLE "Ship country"   
   END_REPORT ;