FormXXX   : DrawGrid, 
	   (optional)Option : BEGIN   Attributes  END
	 title : string or literal  
 	  use   View or Table  ("['your MS4BI DB tablename']")   ;
  	
	

  		   
  DBconnect{Ms4DB}(LEnvDemoExcelDB); 
   
  FormPlus : DrawGrid 
  Option  : 
BEGIN 
    Style     :$METRO ,
    height    :450,  
    pagesize  :20,
    ColumMenu :yes,
    Pageable  :yes,
    Resizable :yes,
    Sortable  :yes,
    ViewResult:yes,
    filterable:yes
END  
title :"-t01-=014     CHART GRID : BUSINESS EMPLOYEE 2011 Dollars and PRODUCTS   " use   View  ("[ms4EmplTotalBusiness2011]")  ;
 
	

  	 
 	
     Source & Copy Basic DrawGrid    	
 

	

Remarks

IncludeChart.h :
THEME :
CONSTANT_STRING :
theme Form Plus (ONLY)
$theme_default "default",
$theme_bts "bootstrap",
$theme_metro "metro",
$theme_moonlight "moonlight",
$theme_blueopal "blueopal",
$theme_silver "silver",
$theme_uniform "uniform",
$theme_flat "flat";

Prerequisites

DBCONNECT {driver} ("['your MS4BI DB name']")

Remarks

Only MS4 DB
Only FormPlus, FORMMS4, FormPchart ,FORMEXCEL (only office 97 'xls')

Example 2 $MS4DBTMP : Make a group selection: the first 10 employees

  
/* select data : */   
 DBconnect{Ms4DB}(LEnvDemoExcelDB); 
 Ms4_query{ms4db}  option : into  $MS4DBTMP 
 (" SELECT OrderID ,CustomerID,	EmployeeID,	OrderDate,	RequiredDate,	ShippedDate "+
  " from   [ms4EmplConsolidationBusiness]  order by EmployeeID desc limit 10 " ) ;  
  
  DBconnect{Ms4DB}($MS4DBTMP);
  FormMS4 : DrawGrid , title :"-t01-=024   -CHART GRID MS4 : BUSINESS EMPLOYEE 2011 $MS4VIEWDBTMP   "
  use   View  ($MS4VIEWDBTMP)   ;
	

Remarks

MS4QUERY : option : into $MS4DBTMP...."select data "
DBconnect { Ms4DB} ($MS4DBTMP) use View ($MS4VIEWDBTMP)
FormXXX : DRAWGRID...........

See also

MS4_QUERY:WEB, MS4_QUERY:WIN, DASHBOARD
Examples :
driver:\MandragorePlanete\MS4BI\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\2-QUERIES
driver:\MandragorePlanete\MS4BI\zConnectors-ADO, ODBC, SQLITE3

---

KEYWORD : DRAWGRID and COUNT, SUM , AVERAGE

Definition

- Automatic calculation of sums, averages, or numbers of records.
- Creates a WEB query and GRID to interrogate an MS4 DB database based on the selection.

Syntax FormMS4 :SUM OR AVERAGE OR COUNT

   	
	  FormMS4   : DrawGrid, title : string or literal  
	  Option  : 
   BEGIN 
     Footer : Sum  or /and Average or /and Count
   END  
	  use   View  ("['your MS4BI DB tablename']")   ;
  	
	

Example

  		   
   Basic  QueryView : ms4EmplBusinessDollars20111213  " >  ,
             
            FormMS4 :  DrawGrid , title : "" 
             Option  : 
              BEGIN 
                 Footer :  Sum, Count,Average 
            END 
             use View  ("ms4EmplBusinessDollars20111213") 
            ,
          > /* end panel */    
       >/* end Rwd_Col */    
     >;/* end Rwd_Row */ 
	

Grid and View/Table

Basic QueryView : ms4EmplBusinessDollars20111213

LASTNAME	BUSINESSID2011	BUSINESSID2012	BUSINESSID2013
Davolio	38789.00	90061.98	65781.13
Fuller	22834.70	74958.60	78108.96
Leverling	19231.80	110988.61	82030.89
Peacock	53114.80	139257.70	57594.95
Buchanan	21965.20	32595.05	21007.50
Suyama	17731.10	45792.00	14475.00
King	17864.80	66689.14	56362.05
Callahan	23161.40	59776.52	50063.11
Dodsworth	11365.70	29577.55	41280.75

,

LASTNAME	BUSINESSID2011	BUSINESSID2012	BUSINESSID2013
*TOTAL	226058.50	649697.15	466704.34
**COUNT :	9
***AVERAGE	25117.61 ( 226058.50/9)	72188.57 ( 649697.15/9)	51856.04 ( 466704.34/9)

Source & Copy FormMS4 DrawGrid

  	 
  Visualise ALL EXAMPLES : Queries      

  Visualise ALL   EXAMPLES    
	
	

Prerequisites

DBCONNECT {driver} ("['your MS4BI DB name']")

Remarks

only MS4 DB
only FORMMS4

See also

MS4_QUERY:WEB, MS4_QUERY:WIN, EDITLINE(Ms4biDesigner), SelectField(Ms4bi Designer)
Examples :
driver:\MandragorePlanete\MS4BI\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\2-QUERIES

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