{ "ReportGuid": "ac9e2b30b91271e04e1e5ba4563921e1", "ReportName": "Report", "ReportAlias": "Report", "ReportFile": "BookingList.mrt", "ReportCreated": "/Date(1607406636000+0800)/", "ReportChanged": "/Date(1615865766000+0800)/", "EngineVersion": "EngineV2", "CalculationMode": "Interpretation", "ReportUnit": "Centimeters", "PreviewSettings": 268435455, "Dictionary": { "Variables": { "0": { "Value": "Today", "Name": "requestDate", "Alias": "Request Date", "Type": "System.DateTime", "RequestFromUser": true, "InitBy": "Expression" }, "1": { "Name": "bookingStatus", "DialogInfo": { "DateTimeType": "DateAndTime", "AllowUserValues": false, "Keys": { "0": "Open", "1": "Released", "2": "Invoiced", "3": "Cancelled" }, "Values": { "0": "", "1": "", "2": "", "3": "" } }, "Alias": "Status Type", "Type": "Stimulsoft.Report.StringList", "RequestFromUser": true }, "2": { "Value": "(bookingStatus.Count == 0 ? \"(' ')\" : \"(\" + bookingStatus.ToQueryString(\"'\") + \")\")", "Name": "selectedStatuses", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "selectedStatuses", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" } }, "DataSources": { "0": { "Ident": "StiMySqlSource", "Name": "booking", "Alias": "booking", "Columns": { "0": { "Name": "BookingType", "Index": -1, "NameInSource": "BookingType", "Alias": "BookingType", "Type": "System.String" }, "1": { "Name": "CustomerName", "Index": -1, "NameInSource": "CustomerName", "Alias": "CustomerName", "Type": "System.String" }, "2": { "Name": "ReferenceNbr", "Index": -1, "NameInSource": "ReferenceNbr", "Alias": "ReferenceNbr", "Type": "System.String" }, "3": { "Name": "TotalAmount", "Index": -1, "NameInSource": "TotalAmount", "Alias": "TotalAmount", "Type": "System.Decimal" }, "4": { "Name": "RequestDate", "Index": -1, "NameInSource": "RequestDate", "Alias": "RequestDate", "Type": "System.DateTime" }, "5": { "Name": "Status", "Index": -1, "NameInSource": "Status", "Alias": "Status", "Type": "System.String" }, "6": { "Name": "RubixReferenceNbr", "Index": -1, "NameInSource": "RubixReferenceNbr", "Alias": "RubixReferenceNbr", "Type": "System.String" }, "7": { "Name": "created_at", "Index": -1, "NameInSource": "created_at", "Alias": "created_at", "Type": "System.DateTime" }, "8": { "Name": "updated_at", "Index": -1, "NameInSource": "updated_at", "Alias": "updated_at", "Type": "System.DateTime" } }, "NameInSource": "logistics", "SqlCommand": "SELECT\r\n BookingType,\r\n CustomerName,\r\n ReferenceNbr,\r\n TotalAmount,\r\n RequestDate,\r\n Status,\r\n RubixReferenceNbr,\r\n created_at,\r\n updated_at\r\nFROM `booking`\r\nWHERE RequestDate = '{requestDate.ToString(\"yyyy-MM-dd\")}' AND Status IN {selectedStatuses}\r\nORDER BY RequestDate, ReferenceNbr" } }, "Databases": { "0": { "Ident": "StiMySqlDatabase", "Name": "logistics", "Alias": "logistics", "ConnectionStringEncrypted": "41xlCURdWt1tTI2s6kzgH4tw9ctIWdnNbRWhCGMA7F7eOtvrYW2SgWlcuWHoPeBn3V73y8ZcE91yTOhATixlL9R4yelGWdNZaU2lgE4E6Q==" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Page1", "Guid": "9ac2dd07e5cabcf49e263b8581fa1560", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiPageHeaderBand", "Name": "PageHeaderBand1", "ClientRectangle": "0,0.4,23.4,1.4", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text10", "Guid": "20b99fe55b7c99bad695c76172b029be", "ClientRectangle": "0,0,3.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Selected Date:" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";10;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Margins": { "Left": 2, "Right": 2, "Top": 2, "Bottom": 2 }, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text11", "Guid": "c9d18518ef2d0ab6f43bd9764817e990", "ClientRectangle": "0,0.6,3.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Status Type:" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";10;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Margins": { "Left": 2, "Right": 2, "Top": 2, "Bottom": 2 }, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text12", "Guid": "c3b63857e1a7040ba62cf6a44fe10e78", "ClientRectangle": "3.6,0,3,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{requestDate}" }, "VertAlignment": "Center", "Font": ";10;Bold;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCustomFormatService", "StringFormat": "yyyy-MM-dd" }, "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text15", "Guid": "ae8a372129ffc5154951bd1a7bbba356", "ClientRectangle": "3.6,0.6,7.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{selectedStatuses}" }, "VertAlignment": "Center", "Font": ";10;Bold;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text16", "Guid": "c1ee9f6f7c2acb83ede804152564f859", "ClientRectangle": "18.2,0,5.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Count(booking) == 0 ? \"NO DATA\" : \"Item Count: \" + Count(booking)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" } } }, "1": { "Ident": "StiHeaderBand", "Name": "HeaderBand1", "CanShrink": true, "ClientRectangle": "0,2.6,23.4,0.8", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text2", "Guid": "f3674d0ff802349e90057afefc83edc8", "ClientRectangle": "0,0,2.4,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Booking Type" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";10;Bold;", "Border": "All;;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text3", "Guid": "6caf4378d463e1142d7892eaac7b071a", "ClientRectangle": "16.6,0,1.6,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "CBM" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";10;Bold;", "Border": "All;;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text4", "Guid": "e146025fb05c3d7dbd130cd9e50608d3", "ClientRectangle": "12,0,4.6,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Customer Name" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";10;Bold;", "Border": "All;;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text5", "Guid": "1805745cad5762ca5bfb2b65fe62fe45", "ClientRectangle": "2.4,0,3.6,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Reference Number" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";10;Bold;", "Border": "All;;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text6", "Guid": "5f0aab761aae715f5a7ad08890f69c11", "ClientRectangle": "18.2,0,2.4,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Total Amount" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";10;Bold;", "Border": "All;;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text7", "Guid": "4ce438b16f8b82a7bdab019802312aa4", "ClientRectangle": "20.6,0,2.8,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Request Date" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";10;Bold;", "Border": "All;;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "6": { "Ident": "StiText", "Name": "Text8", "Guid": "206c79bc159c5af17e64edbdb364eb03", "ClientRectangle": "6,0,4,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Client RefNbr" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";10;Bold;", "Border": "All;;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text13", "Guid": "bc6d41ea9c4f2b64398b9420b57a64d9", "ClientRectangle": "10,0,2,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Status" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";10;Bold;", "Border": "All;;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" } } }, "2": { "Ident": "StiDataBand", "Name": "Databooking", "CanShrink": true, "ClientRectangle": "0,4.2,23.4,1.8", "Interaction": { "Ident": "StiBandInteraction" }, "Border": "All;;;;;;;solid:0,0,0", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Databooking_BookingType", "Guid": "c71faf2f095a042c98a33cd787030304", "CanGrow": true, "GrowToHeight": true, "ClientRectangle": "0,0,2.4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{booking.BookingType}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Border": "Left, Right;;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Margins": { "Left": 2, "Right": 2, "Top": 2, "Bottom": 2 } }, "1": { "Ident": "StiText", "Name": "Databooking_CBM", "Guid": "dd1e4fc2579759d9bc4b70b75f536f2b", "CanGrow": true, "GrowToHeight": true, "ClientRectangle": "16.6,0,1.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{booking.CBM}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Border": "Left, Right;;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Margins": { "Left": 2, "Right": 2, "Top": 2, "Bottom": 2 }, "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," } }, "2": { "Ident": "StiText", "Name": "Databooking_CustomerName", "Guid": "d7327c70f48b6d58699ba55c7f73bf26", "CanGrow": true, "GrowToHeight": true, "ClientRectangle": "12,0,4.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{booking.CustomerName}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Border": "Left, Right;;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Margins": { "Left": 2, "Right": 2, "Top": 2, "Bottom": 2 } }, "3": { "Ident": "StiText", "Name": "Databooking_ReferenceNbr", "Guid": "accf7d8805b432378ae959ee0b6190e2", "CanGrow": true, "GrowToHeight": true, "ClientRectangle": "2.4,0,3.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{booking.ReferenceNbr}" }, "VertAlignment": "Center", "Border": "Left, Right;;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Margins": { "Left": 2, "Right": 2, "Top": 2, "Bottom": 2 } }, "4": { "Ident": "StiText", "Name": "Databooking_TotalAmount", "Guid": "daa10b7a98be90b7835792847e43084a", "CanGrow": true, "GrowToHeight": true, "ClientRectangle": "18.2,0,2.4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{booking.TotalAmount}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Border": "Left, Right;;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Margins": { "Left": 2, "Right": 2, "Top": 2, "Bottom": 2 }, "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," } }, "5": { "Ident": "StiText", "Name": "Text1", "Guid": "fe3e20ce2cec92c02c33e81b26f35fa4", "GrowToHeight": true, "ClientRectangle": "20.6,0,2.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{booking.RequestDate}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Border": "Left, Right;;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:Black", "Margins": { "Left": 2, "Right": 2, "Top": 2, "Bottom": 2 }, "TextFormat": { "Ident": "StiCustomFormatService", "StringFormat": "yyyy-MM-dd" } }, "6": { "Ident": "StiText", "Name": "Text9", "Guid": "b73b9e039fbcd1b2ee06a53f0f5c0c1d", "CanGrow": true, "GrowToHeight": true, "ClientRectangle": "6,0,4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{booking.RubixReferenceNbr}" }, "VertAlignment": "Center", "Border": "Left, Right;;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Margins": { "Left": 2, "Right": 2, "Top": 2, "Bottom": 2 }, "Type": "DataColumn" }, "7": { "Ident": "StiText", "Name": "Text14", "Guid": "07d9d034cb081b28ea53c4c7a2a94b83", "CanGrow": true, "GrowToHeight": true, "ClientRectangle": "10,0,2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{booking.Status}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Border": "Left, Right;;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Margins": { "Left": 2, "Right": 2, "Top": 2, "Bottom": 2 }, "Type": "DataColumn" } }, "SkipFirst": false, "DataSourceName": "booking" } }, "PaperSize": "Standard10x14", "PageWidth": 25.4, "PageHeight": 35.6, "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 1, "Right": 1, "Top": 1, "Bottom": 1 } } } }