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 14 : Css, html, Php, js

Definition

Block defining the possibility of inserting: Javascript, php, html, ajax, css.. web source code.

Syntax

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

Example

 		   
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 :   ConnectDB {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 ;	
	

Remarks

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



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

dddddddddd