BEGIN_SW   
 instructions 	Javascript, php, html, ajax, css 
	
 END_SW	   ;

	

  		   
Begin_SW  
  <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:#A7CDF0;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  ; 
  Begin_Report
  
  REPORTINPUT :   DBconnect {Ms4DB}(LEnvDemoExcelDB) use View  ("[ms4EmplConsolidationBusiness]") 
   REPORTFORM:AGGREGATE , TITLE : " EXCEL  Consolidation : REPORT   EMPLOYEE orders BY SHIP COUNTRY " 
    
             AGGREGATE  BY       :      Employees.EmployeeID   ,   Orders.Shipcountry ,Orders.ShipCity
                              
            DETAIL AGGREGATE    : Option  :  BEGIN pagesize:300  END OPTION      
                    Orders.OrderID   ,		TITLE "ORDER"  , 
                    Orders.ShipName ,		TITLE " ship Name "  ,
                    Orders.ShipAddress  , 	TITLE "Address"   ,
                    Orders.ShipCity  , 		TITLE "City"   ,
                    Orders.ShipRegion  ,		TITLE "Region"   ,
                    Orders.ShipPostalCode  ,	TITLE "Postal code "   ,
                    Orders.Shipcountry  , 	TITLE "Ship country"   
 END_REPORT ;	
	

Visualise example 1
Source example 1
Visualise example 2
Source example 2

Remarks

See also markdown and help on blocks: BEGIN_SW ........... END_SW

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