MS4BI HELP 2022

by MS4script
2-GRID-QUERY
01-Select-MS4DB-FormNice.ms4
02-Select-MS4DB-PositAbsolue.ms4
03-Select-MS4DB-WinWeb.ms4
04-Select-QueryWeb-Excel-ScriptWeb.ms4
06-Ms4QueryWeb.ms4
07-Select-FormNice-Theme.ms4
230-01-FormNice-Grid.ms4
233-01-FormNice-Grid-Selectfied.ms4
233-02-FormNice-Grid-EditInline.ms4
235-02-FormNice-Grid-$DBTMP.ms4
235-03-FormBts-Grid-$DBTMP.ms4
400-01-Ms4Query-Custom.ms4
400-02-Ms4Query-Custom-Rwd.ms4
402-04-Ms4Query-Custom-EditInLine.ms4
450-FormCustom-Grid-MS4DB.ms4
451-FormCustom-Grid-Edit-Add-Delete.ms4
452-FormCustom-Grid-EditInLine-Add-Delete.ms4
453-FormCustom-Grid-DrawPanel.ms4
454-FormCustom-Grid-Selectfied.ms4
456-FormCustom-Grid-Selectfied-InlineEdit.ms4
500-FormMs4-Grid-Simple.ms4
500-FormMs4-Query-Excel.ms4
500-FormMs4-Query-ToolBarFiles.ms4
501-FormMs4-Grid-SUM.ms4
502-FormMs4-Grid-AVERAGE.ms4
503-FormMs4-Grid-COUNT.ms4
504-FormMs4-Grid-SUMAVGCOUNT-Rwd-FontSize.ms4
505-FormMs4-Grid-SUMAVGCOUNT-Rwd.ms4
514-FormMs4-Grid-SumCountAverage.ms4
520-FormMs4-Grid-BigInfo.ms4
528-FormBTS-Query-Standard.ms4
529-FormBTS-Grid-SUM.ms4
530-FormBTS-Grid-Basic.ms4
531-FormBTS-Grid-DrawPanel.ms4
690-Google-Grid-StandardEx1.ms4
691-Grid-Pchart.ms4
930-FormExcel-Grid-Simple.ms4
931-FormExcel-Grid-Simple-bigInfo.ms4
938-FormExcel-Grid-LoadFileSimple.ms4
MS4BI Trial Version
MG Planete :
https://getms4bi.com
×

Step 6 : Pie Bar.. Charts Win&Web

grid 1
ORDERIDCUSTOMERIDEMPLOYEEIDORDERDATEREQUIREDDATESHIPPEDDATE
10255RICSU92011-07-122011-08-092011-07-15
10255RICSU92011-07-122011-08-092011-07-15
10255RICSU92011-07-122011-08-092011-07-15
10255RICSU92011-07-122011-08-092011-07-15
10263ERNSH92011-07-232011-08-202011-07-31
10263ERNSH92011-07-232011-08-202011-07-31
10263ERNSH92011-07-232011-08-202011-07-31
10263ERNSH92011-07-232011-08-202011-07-31
10324SAVEA92011-10-082011-11-052011-10-10
10324SAVEA92011-10-082011-11-052011-10-10
10324SAVEA92011-10-082011-11-052011-10-10
10324SAVEA92011-10-082011-11-052011-10-10
10324SAVEA92011-10-082011-11-052011-10-10
10331BONAP92011-10-162011-11-272011-10-21
10386FAMIA92011-12-182012-01-012011-12-25
    grid 2
    EMPLOYEEIDLASTNAMEFIRSTNAMETITLETITLEOFCOURTESYBIRTHDATEHIREDATEADDRESSCITYREGIONPOSTALCODECOUNTRYHOMEPHONEEXTENSIONPHOTOREPORTSTOPHOTOPATHORDERIDCUSTOMERIDEMPLOYEEIDDUPLICATE1ORDERDATEREQUIREDDATESHIPPEDDATESHIPVIAFREIGHTSHIPNAMESHIPADDRESSSHIPCITYSHIPREGIONSHIPPOSTALCODESHIPCOUNTRYORDERIDDUPLICATE1PRODUCTIDUNITPRICEQUANTITYDISCOUNTPRODUCTIDDUPLICATE1PRODUCTNAMESUPPLIERIDCATEGORYIDQUANTITYPERUNITUNITPRICEDUPLICATE1UNITSINSTOCKUNITSONORDERREORDERLEVELDISCONTINUED
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10255RICSU92011-07-122011-08-092011-07-153148.33Richter SupermarktStarenweg 5Genève1204Switzerland10255215.2202Bottles Defix1124 - 12 oz bottles16174025
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10255RICSU92011-07-122011-08-092011-07-153148.33Richter SupermarktStarenweg 5Genève1204Switzerland102551613.93516Pavlova7332 - 500 g boxes17.4529100
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10255RICSU92011-07-122011-08-092011-07-153148.33Richter SupermarktStarenweg 5Genève1204Switzerland102553615.22536Inlagd Sill17824 - 250 g jars19112200
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10255RICSU92011-07-122011-08-092011-07-153148.33Richter SupermarktStarenweg 5Genève1204Switzerland1025559443059Raclette Courdavault2845 kg pkg.55790
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10263ERNSH92011-07-232011-08-202011-07-313146.06Ernst HandelKirchgasse 6Graz8010Austria10263243.62824Guarana¡ Fanta¡stica10112 - 355 ml cans4.5201
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10263ERNSH92011-07-232011-08-202011-07-313146.06Ernst HandelKirchgasse 6Graz8010Austria102633020.7600.2530Nord-Ost Matjeshering13810 - 200 g glasses25.8910150
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10263ERNSH92011-07-232011-08-202011-07-313146.06Ernst HandelKirchgasse 6Graz8010Austria102631613.9600.2516Pavlova7332 - 500 g boxes17.4529100
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10263ERNSH92011-07-232011-08-202011-07-313146.06Ernst HandelKirchgasse 6Graz8010Austria10263748360.2574Longlife Tofu475 kg pkg.1042050
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10324SAVEA92011-10-082011-11-052011-10-101214.27Save-a-lot Markets187 Suffolk Ln.BoiseID83720USA103246335.1800.1563Vegie-spread7215 - 625 g jars43.92450
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10324SAVEA92011-10-082011-11-052011-10-101214.27Save-a-lot Markets187 Suffolk Ln.BoiseID83720USA103241613.9210.1516Pavlova7332 - 500 g boxes17.4529100
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10324SAVEA92011-10-082011-11-052011-10-101214.27Save-a-lot Markets187 Suffolk Ln.BoiseID83720USA103245944400.1559Raclette Courdavault2845 kg pkg.55790
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10324SAVEA92011-10-082011-11-052011-10-101214.27Save-a-lot Markets187 Suffolk Ln.BoiseID83720USA103243514.4700.1535Steeleye Stout16124 - 12 oz bottles1820150
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10324SAVEA92011-10-082011-11-052011-10-101214.27Save-a-lot Markets187 Suffolk Ln.BoiseID83720USA10324469.63046Spegesild2184 - 450 g glasses12950
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10331BONAP92011-10-162011-11-272011-10-21110.19Bon app-12, rue des BouchersMarseille13008France10331545.91554Tourtiare25616 pies7.4521100
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10386FAMIA92011-12-182012-01-012011-12-25313.99Familia ArquibaldoRua Orós, 92Sao PauloSP05442-030Brazil103863411.21034Sasquatch Ale16124 - 12 oz bottles14111150
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10386FAMIA92011-12-182012-01-012011-12-25313.99Familia ArquibaldoRua Orós, 92Sao PauloSP05442-030Brazil10386243.61524Guarana¡ Fanta¡stica10112 - 355 ml cans4.5201
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10411BOTTM92012-01-102012-02-072012-01-21323.65Bottom-Dollar Markets23 Tsawassen Blvd.TsawassenBCT2F 8M4Canada10411594490.259Raclette Courdavault2845 kg pkg.55790
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10411BOTTM92012-01-102012-02-072012-01-21323.65Bottom-Dollar Markets23 Tsawassen Blvd.TsawassenBCT2F 8M4Canada104114415.5400.244Gula Malacca20220 - 2 kg bags19.4527150
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10411BOTTM92012-01-102012-02-072012-01-21323.65Bottom-Dollar Markets23 Tsawassen Blvd.TsawassenBCT2F 8M4Canada10411417.7250.241Jack's New England Clam Chowder19812 - 12 oz cans9.6585100
    9DodsworthAnneSales RepresentativeMs.1966-01-271994-11-157 Houndstooth Rd.LondonWG2 7LTUK(71) 555-4444452[Blob]5http://accweb/emmployees/davolio.bmp10475SUPRD92012-03-142012-04-112012-04-04168.52Suprêmes délicesBoulevard Tirou, 255CharleroiB-6000Belgium104756613.6600.1566Louisiana Hot Spiced Okra2224 - 8 oz jars174100200