REPORTINPUT :   DBconnect {Ms4DB}(your MS4BI DB) use View  ("['your MS4BI DB tablename']") 

OR 

REPORTINPUT :    DBconnect { Ms4DB}  ($MS4DBTMP) use View ($MS4VIEWDBTMP)
 
REPORTFORM:AGGREGATE , TITLE : " xxxxxxxxxxxxx "  
Option  :  BEGIN pagesize:xxx ,height: xxx END OPTION   
		AGGREGATE   BY    :     Hierarchy : column  1, 2..
				column1 COUNT ,  <-COUNT (optional)
				column2 AVERAGE ,  <-AVERAGE (optional)
				columnX SUM        <-TOTALISATION (optional)
   	 	DETAIL AGGREGATE    :     
		  column1  , 			TITLE "xxxxxx "  ,  
		  column2   , 			TITLE "yyyyyyyy"  , 
		  column3   , 		  	TITLE "xxxxxxxxxxxxxxx"  
		  ...
   END_REPORT ;

	

  
   Source & Copy Report Aggregate     		
   
   Visualise Report     		
  [Source & Copy Report Aggregate    

	

Visualise ALL Examples : Reports
Visualise ALL examples

Pre-requisite

DECLARE SCHEMA_Report :

TableName
{ TEXT : Var1 , Var2;
INTEGER : Var3 ;
.......
};

Remarks

Drag/Drop : Columns

BEFORE : SORT =$MS4DBTMP

example :
DBconnect{Ms4DB}(string DB);
Ms4_query{ms4db} option :

into $MS4DBTMP

(" SELECT * from table as a " +
"where namevar1 ... order by Var1, Var2... < is ReportAggregate for AVERAGE or SUM ...> ");

---

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