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 7 : DASHBOARDS

KEYWORD : ..

Definition

Creates an RWD type dashboard including charts and reports (RWD : RESPONSIVE WEB DESIGN)

Syntax

  	
	
Use RESPONSIVE (RWD) instructions :
RWD_ROW,RWD_COL,<DIV... 	
SEE HELP UI
	

Example

 		   
<Rwd_Row    :  2 /* 2 : optional */
    <Rwd_Col :   lg:4 ,"text-left" :  
            <div $widget + $bg_primary + "no-padding" :
                <div  "class='p-m " :
                     <Text : ""     , "    Population by Province   " > ,
                     <Text :  ""     , "  China    " > ,
                >  /* end div */
                           ConnectDB {Ms4DB} (Lcurrentdb) ,
                           FormMorris :  DrawPIE,   title :"" ,  
                           TYPE : $DONUT, FORMAT: "Th"  use View  ("[ms4TotalPopulByProvince]")   			   
            >  /* end div */
    >  /* end col lg:4 */
    <Rwd_Col :   lg:8 ,"text-left" : 
            <div $widget + $bg_info + "no-padding" :
                    <div  "class='p-m " :
                        <Text : ""     , "   Population by Province (TOP 15)     " >  
                        <Text :  ""    , "      (BAR )  " >  
                        <Text :  ""     , "   China    " >  
                     >  /* end div */
                        ConnectDB{Ms4DB}(Lcurrentdb), 
                        Ms4_Query{ms4db}  option : into  $MS4DBTMP 
                       (" SELECT  *   from  [ms4TotalPopulByProvince]  order by "+
                        "TOTALThousandPopulationByProvince desc limit 15 " ) , ** TOP 15
                        ConnectDB{Ms4DB}($MS4DBTMP),
                        FormMorris :	DrawBar ,  title :"" ,TYPE :  $HORIZONTAL   , FORMAT :"Th"  
                        use   View  ($MS4VIEWDBTMP)  		 		>, /* end div */
        >  /* end col lg:8 */
>;  /* end Row */
	

Prerequisites

driver:\MondaySoftware\MS4BI\zIncludeIncludeChart.h :

See also

BEGIN_DASHBOARD, MS4_QUERY:WEB, MS4_QUERY:WIN, FORMXXX
Examples :
driver:\MondaySoftware\MS4BI\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\90-OTHERS-UI
driver:\MondaySoftware\MS4BI\01-GETTING-STARTED-UNICODE



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


Copyright 2019 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.00.0005.02.2019
  • MS4BIRE v.00.0005.02.2019
  • MS4SCRIPT v.00.0005.02.2019
  • help 02/2019

MS4BI in 5 minutes