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..
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
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
Laura Callahan 36 F
Nancy Davolio 39 F
John Devis 21 M
Anne Dodsworth 27 F
Andrew Fuller 28 M
Donald Hallan 33 M
Robert King 34 M
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
    Laura Callahan 36 F
    Nancy Davolio 39 F
    John Devis 21 M
    Anne Dodsworth 27 F
    Andrew Fuller 28 M
    Donald Hallan 33 M
    Robert King 34 M
    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 0
      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
        Callahan Laura 36 F
        Davolio Nancy 39 F
        Devis John 21 M
        Dodsworth Anne 27 F
        Fuller Andrew 28 M
        Hallan Donald 33 M
        King Robert 34 M
        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
          Laura Callahan 36 F Edit
          Nancy Davolio 39 F 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
          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
            Laura Callahan 36 F Edit Delete
            Nancy Davolio 39 F 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
            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
                Laura Callahan F Delete
                Nancy Davolio F Delete
                John Devis M Delete
                Anne Dodsworth F Delete
                Andrew Fuller M Delete
                Donald Hallan M Delete
                Robert King M 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
                  Laura Callahan 36 F Edit Delete
                  Nancy Davolio 39 F 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
                  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
                    36 F
                    39 F
                    21 M
                    27 F
                    28 M
                    33 M
                    34 M
                    42 M
                    23 M
                    42 F
                    57 M
                    26 M