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 
      
     BASIC HELP : MS4BI by MS4script   
   2022 version 1.10

Chapter 8 : REPORT

KEY WORD : REPORTFORM:DESIGN

Definition

Customise your reports: automatic sort breaks, group headers, group footers, grand total

Syntax 

   
		REPORTINPUT :   DBconnect { Ms4DB} ($MS4DBTMP) use View  ($ms4ViewDBtmp)  
		OR 
		REPORTINPUT :   DBconnect {Ms4DB}(your MS4BI DB) use View  ("['your MS4BI DB tablename']") 
	 
		REPORTFORM:DESIGN  
	Group  Order  by   : level 01  , level 02
			LinkCss :    ........
 			Start_Design :
			Totalise
					$total01  as VarNameA  
 	 		End_Totalise
 
			Header_Report(optional)
				........ 	
			End_Header_Report

				Header_Group  :  01    ** EMPLOYEE level level : 01   etc..
					........	
				End_Header_Group  
				Header_Group  : 02    ** CITY level : 02   etc..
					..........
				End_Header_Group  
  
			      Break_Group  : 02  (optional) ** CITY
					........total city (by employee)
				End_Break_Group   (optional)
				Break_Group  : 01 ** Employee
					........total by employee..
				End_Break_Group  

	TOTALReport  (optional)
				.......
	End_TotalReport 
 
	End_Report ;

Report Design : Automatic sort breaks, group headers, group footers, grand total

Generate by Mandragore Planete

Mandragore Planete - Trial Version : BUSINESS 2011 Report : Employee by Country, By Orders

08/28/2220:45:59 ( update style Css : \MandragorePlanete\MS4BI\zInclude\css\StyleReportDesign\xxxxxxxxxxxx.css)
##Break Employee : 1 Davolio Total Price Units : 1691.40 Total Quantity : 1620.00 Total business : 38789.00total Orders: 26 Total country 14
##Break Employee : 2 Fuller Total Price Units : 822.20 Total Quantity : 1085.00 Total business : 22834.70total Orders: 16 Total country 9
##Break Employee : 3 Leverling Total Price Units : 812.60 Total Quantity : 940.00 Total business : 19231.80total Orders: 18 Total country 12
##Break Employee : 4 Peacock Total Price Units : 2340.40 Total Quantity : 2212.00 Total business : 53114.80total Orders: 31 Total country 14
##Break Employee : 5 Buchanan Total Price Units : 701.70 Total Quantity : 778.00 Total business : 21965.20total Orders: 11 Total country 8
##Break Employee : 6 Suyama Total Price Units : 778.30 Total Quantity : 963.00 Total business : 17731.10total Orders: 15 Total country 10
##Break Employee : 7 King Total Price Units : 631.10 Total Quantity : 455.00 Total business : 17864.80total Orders: 11 Total country 8
##Break Employee : 8 Callahan Total Price Units : 1352.30 Total Quantity : 923.00 Total business : 23161.40total Orders: 19 Total country 11
##Break Employee : 9 Dodsworth Total Price Units : 272.20 Total Quantity : 575.00 Total business : 11365.70total Orders: 5 Total country 5

TOTAL ORDERS: 152

TOTAL EMPLOYEE: 9

$TOTAL03: Business
226058.50$

$TOTAL01: Price Unit
9402.20$

$TOTAL02: qte
9551.00






Example 

   
   Source Report Design   	
   Source & Copy Report Design   	

	 	 
   Visualise ALL Report EXAMPLES : Menu      

   Visualise ALL Report EXAMPLES : Explorer

Pre-requisites

MS4QUERY (optional) : ORDER BY automatic sort breaks for REPORTINPUT : and ===> DBconnect { Ms4DB} ($MS4DBTMP) use View ($MS4VIEWDBTMP)
BEGIN_REPORT
REPORTINPUT : DBCONNECT
REPORTFORM:DESIGN...........
END_REPORT

Remarks

- No constraints

- Formula is possible in section


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

Copyright 2022 by Mandragore Planete

the official sites :
mgplanete.com
getms4bi.com
demos.ms4bi.com
help.ms4bi.com
ms4script.com

Download

official site :
getms4bi.com

Our purpose : Keep it simple !


written with ms4script
  • help 01.010.2022.8

MS4BI in 5 minutes