MS4BI HELP 2019

by MS4script
01-Introduction
Preface & Copyright
Getting started
Demos Simple
02- Declarations
Structure
Type
03- Instructions
Conditions if,do,while..
String functions Str..()
Get + Include functions Get, Include..
Date-Time Day, Time, Year.
Display
Call
Formulas Complex
04- Database
Connector Ado, Odbc, Dsn, SAP, Ms4
Connect DB Create, delete
Import DataSource Import, Consolidation
Administration Admin, User
05- Sql-Query
Sql
Query Form : BTS,SHOW
Grid option
06- Charts
Forms Show, Win, Image, Excel, Morris...
Pie Std, Donut, 3D...
Bar Std, Stack, Line, Area, Plot
Radar
QrCode, Gauge
Step, Stock...
,Google,Leaflet... GeoMap
,Gantt,Timeline,Org.
07- Dashboard
Form tab, no tab
Responsive UI
08- Report
Report Hierarchy
Report Design
09- Filters
Dialogue + Call
10- Menus
Menu Design
Menu Frameset
Menu Special
11-UI : Responsive
Tables Responsive,Frame,position
List Group
Text
Panel Header, body, Footer
Button Button, Progress Bar
Icon & Button
Collapse Group, Panel
Notifications
12- Encryption
Encrypt
Decrypt
13- Windows
Dialogue
Picture, Frame, Button..
MsgBox
Grid
14- Cloud.
Account Open
15- Css, html, Php, js.
Insert Native language Begin_sw..End_Sw
16-Install + tools.
Installation & Configuration This Menu
Generate Native... Php, Html, js..
Code Generator Ms4 Script
MarkDown Ms4 Script
Source Code Menu Help This Menu
written with ms4script
     

BASIC HELP : MS4BI by MS4script 2019 version 1

Chapter 5 : SQL and QUERIES

KEYWORD : DRAWGRID

Definition

Creates a WEB query and grid to interrogate an MS4 DB database

Syntax

  	
	  FormXXX   : DrawGrid, title : string or literal  
 	  use   View  ("['your MS4BI DB tablename']")   ;
  	
	

Example 1

 		   
    ConnectDB {Ms4DB} (Lcurrentdb) ;                  
    FormShow : DrawGrid, title :"MS4 DB : View 1 :  Total population/province : Drag & Drop Column "    use   View  ("[ms4TotalPopulByProvince]")  ;
 
	

Prerequisites

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

Remarks

Only MS4 DB
Only FORMSHOW, FORMMS4, FORMIMAGE ,FORMEXCEL (only office 97 'xls')

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

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

Remarks

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

See also

MS4_QUERY:WEB, MS4_QUERY:WIN, DASHBOARD
Examples :
driver:\MondaySoftware\MS4BI\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\2-QUERIES
driver:\MondaySoftware\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

 		   
 < Rwd_Row + $color_Success :  1
       Basic  QueryView : ms4EmplBusinessDollars20111213  " >  ,
             
            FormMS4 :  DrawGrid , title : "" 
             Option  : 
              BEGIN 
                 Footer : Sum, Count,A verage
            END 
             use View  ("ms4EmplBusinessDollars20111213") 
            ,
          > /* end panel */    
       >/* end Rwd_Col */    
     >;/* end Rwd_Row */ 
	

Prerequisites

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

Remarks

only MS4 DB
only FORMMS4

See also

MS4_QUERY:WEB, MS4_QUERY:WIN, DASHBOARD
Examples :
driver:\MondaySoftware\MS4BI\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\2-QUERIES

Interested in our project? contact@monday-software.com
The Monday Software team


Copyright 2020 by Monday Software

the official sites :
www.monday-software.com
www.ms4bi.com
demos.ms4bi.com
getms4bi.com
getms4bifree.com
cloud.ms4bi.com
cloud.testing.ms4bi.com
www.ms4script.com

Our purpose : Keep it simple !


written with ms4script
  • MS4BI v.01.0027.01.2020
  • MS4BIRE v.01.0021.10.2019
  • MS4SCRIPT v.01.0027.01.2020
  • help 06/2019

MS4BI in 5 minutes