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 : REPORT : Only 1 table

Form Custom Grid : Overview, Standard, Edit , Select column

Step 1

toolbar

Presentation

Standard

 		   	
		 REPORT  : Form Custom Grid   + Simple Style  
	
	
Simple Report Example
FIRSTNAMENAMEAGESEX
Sheila Arthur 28 F
Steven Buchanan 61 M
John Devis 21 M
Anne Dodsworth 27 F
Andrew Fuller 28 M
Donald Hallan 33 M
Robert King 34 M
Janet Leverling 52 F
Peter Mactree 42 M
patrick Nevada 23 M
Margaret Peacock 42 F
Jack Picsou 57 M
Michael Suyama 26 M
    My Style
     		   	
    		 REPORT  : Form Custom Grid   + Personalize Style  
    	
    	
    
    Implementation 1
    FIRSTNAMENAMEAGESEX
    Sheila Arthur 28 F
    Steven Buchanan 61 M
    John Devis 21 M
    Anne Dodsworth 27 F
    Andrew Fuller 28 M
    Donald Hallan 33 M
    Robert King 34 M
    Janet Leverling 52 F
    Peter Mactree 42 M
    patrick Nevada 23 M
    Margaret Peacock 42 F
    Jack Picsou 57 M
    Michael Suyama 26 M
      Implementation 2
      NAMEREVENUEEXPENSE
      Buchanan 1000 210
      Callahan 36 12
      Davolio 1200 1250
      Devis 50 12
      Dodsworth 540 120
      Fuller 750 500
      Hallan 1280 500
      King 650 56
      Leverling 50 12
      Mactree 2400 1350
      Nevada 450 180
      Peacock 0 0
      Picsou 99 1
      Suyama 500 250
      Arthur 750 120
        Columns : Personalisation

        MyNameIsFIRSTNAMEMyageForM
        Arthur Sheila 28 F
        Buchanan Steven 61 M
        Devis John 21 M
        Dodsworth Anne 27 F
        Fuller Andrew 28 M
        Hallan Donald 33 M
        King Robert 34 M
        Leverling Janet 52 F
        Mactree Peter 42 M
        Nevada patrick 23 M
        Peacock Margaret 42 F
        Picsou Jack 57 M
        Suyama Michael 26 M
          Database : Edit
          Implementation
          FIRSTNAMENAMEAGESEX Options
          Sheila Arthur 28 F Edit
          Steven Buchanan 61 M Edit
          John Devis 21 M Edit
          Anne Dodsworth 27 F Edit
          Andrew Fuller 28 M Edit
          Donald Hallan 33 M Edit
          Robert King 34 M Edit
          Janet Leverling 52 F Edit
          Peter Mactree 42 M Edit
          patrick Nevada 23 M Edit
          Margaret Peacock 42 F Edit
          Jack Picsou 57 M Edit
          Michael Suyama 26 M Edit
            Database: Insert/Delete/Edit

            FIRSTNAMENAMEAGESEX Options Add
            Sheila Arthur 28 F Edit Delete
            Steven Buchanan 61 M Edit Delete
            John Devis 21 M Edit Delete
            Anne Dodsworth 27 F Edit Delete
            Andrew Fuller 28 M Edit Delete
            Donald Hallan 33 M Edit Delete
            Robert King 34 M Edit Delete
            Janet Leverling 52 F Edit Delete
            Peter Mactree 42 M Edit Delete
            patrick Nevada 23 M Edit Delete
            Margaret Peacock 42 F Edit Delete
            Jack Picsou 57 M Edit Delete
            Michael Suyama 26 M Edit Delete
              Database : Edit Line
              Implementation
              FIRSTNAMENAMEAGESEX Options
                Implementation : Edit Line, Insert, Delete
                FIRSTNAMENAMEAGESEX Options Add
                Sheila Arthur F Delete
                Steven Buchanan M Delete
                John Devis M Delete
                Anne Dodsworth F Delete
                Andrew Fuller M Delete
                Donald Hallan M Delete
                Robert King M Delete
                Janet Leverling F Delete
                Peter Mactree M Delete
                patrick Nevada M Delete
                Margaret Peacock F Delete
                Jack Picsou M Delete
                Michael Suyama M Delete
                  TabStrip - Go to see 40 Tabstrip.trs

                  Interested in joining us?? contact@mgplanete.com
                  The Mg Planete team

                  the official sites :
                  www.mgplanete.com
                  getms4bi.com
                  demos.ms4bi.com
                  help.ms4bi.com
                  www.ms4script.com
                  IMPLEMENTATION TAB STRIP/REPORT
                  • Delete/Add/upd.
                  • Edit Line

                  FIRSTNAMENAMEAGESEX Options Add
                  Sheila Arthur 28 F Edit Delete
                  Steven Buchanan 61 M Edit Delete
                  John Devis 21 M Edit Delete
                  Anne Dodsworth 27 F Edit Delete
                  Andrew Fuller 28 M Edit Delete
                  Donald Hallan 33 M Edit Delete
                  Robert King 34 M Edit Delete
                  Janet Leverling 52 F Edit Delete
                  Peter Mactree 42 M Edit Delete
                  patrick Nevada 23 M Edit Delete
                  Margaret Peacock 42 F Edit Delete
                  Jack Picsou 57 M Edit Delete
                  Michael Suyama 26 M Edit Delete

                    FIRSTNAMENAMEAGESEX Options
                    28 F
                    61 M
                    21 M
                    27 F
                    28 M
                    33 M
                    34 M
                    52 F
                    42 M
                    23 M
                    42 F
                    57 M
                    26 M