MS4BI®

MS4BI HELP 2022

by MS4script
01-Introduction
Preface & Copyright
Getting started
Informations + Cmd/param Server
Demos Simple
02- Declarations
Structure
Type
03- Instructions
Conditions if,do,while..
Char/Text functions Char or Text..()
Get + Include functions Get, Include..
String functions String# (hashtag)
Date-Time Day, Time, Year.
Display
Call
Formulas Complex
04- Database
Connector Ado, Odbc, Dsn, SAP, Ms4
DB Connect Create, delete
Import DataSource Import, Consolidation
Administration Admin, User
05- Sql-Query
Sql
Query Form : BTS,Plus
Grid option
06- Charts
Forms Plus, 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.
DrawWindow [web]
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 Custom
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

Designer

00-OverView
01-Transaction
02-Setting
05-Import
10-Formula
15-Report-Part1
16-Report-Part2
20-Query-Part1
21-Query-Part2
25-Report-Query-Style
30-QrCodeImage
31-Windows
32-Frame
40-TabStrip
50-Collapse
60-BeginForm
63-Input-SubmitBox
70-Input-Select
71-Input-Insert
72-Input-Update
73-Input-Delete
75-Input-Query
77-ListComBo
81-Button-Link
82-Button-DataList
86-Sticky-Label
91-Insert-PhpJsHtml
92-Insert-MS4script
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
MS4BI 
     
     BASIC HELP : MS4BI Designer by MS4script   
   2021 version 1

Part 1 : QUERY : Special Grid

Overview, Standard, Style , Edit Line

Step 1

toolbar 
    
    Examples

∑ REVENUE∑EXPENSEBALANCE%EXPENSE
9755.00 €4073.00 €5682.00 €expense/revenue : 41.75 %

NAMEFIRSTNAMESEXAGEREVENUEEXPENSE Options
Arthur Sheila F 28
Buchanan Steven M 61
Callahan Laura F 36
Davolio Nancy F 39
Devis John M 21
Dodsworth Anne F 27
Fuller Andrew M 28
Hallan Donald M 33
King Robert M 34
Leverling Janet F 52
Mactree Peter M 42
Nevada patrick M 23
Peacock Margaret F 42
Picsou Jack M 57
Suyama Michael M 26
    Implementation 5
    NAMEFIRSTNAMESEXAGEREVENUEEXPENSE Options
    Arthur Sheila F 28
    Buchanan Steven M 61
    Callahan Laura F 36
    Davolio Nancy F 39
    Devis John M 21
    Dodsworth Anne F 27
    Fuller Andrew M 28
    Hallan Donald M 33
    King Robert M 34
    Leverling Janet F 52
    Mactree Peter M 42
    Nevada patrick M 23
    Peacock Margaret F 42
    Picsou Jack M 57
    Suyama Michael M 26

      nameexpense
      Buchanan210
      Buchanan : Subtotal Expense :210
      Davolio1250
      Davolio : Subtotal Expense :1250
      Fuller500
      Fuller : Subtotal Expense :500
      Mactree1350
      Mactree : Subtotal Expense :1350
      Suyama250
      Suyama : Subtotal Expense :250

        Presentation