{ "ReportGuid": "35c61deac456bf49581109c5f8f227d3", "ReportName": "Report", "ReportAlias": "Report", "ReportFile": "427_64902cba66103?v=20230619203814.mrt", "ReportCreated": "/Date(1548453801000+0200)/", "ReportChanged": "/Date(1687199863000+0200)/", "EngineVersion": "EngineV2", "CalculationMode": "Interpretation", "ReportUnit": "Centimeters", "PreviewSettings": 268435455, "Styles": { "0": { "Ident": "StiChartStyle", "Description": "Style based on formating of ChartElement1 component", "Name": "Style1", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:255,255,255", "BrushType": "Solid", "StyleColors": { "0": "52,152,219", "1": "239,113,122", "2": "109,203,179", "3": "242,129,97", "4": "252,205,27" }, "BasicStyleColor": "255,255,255", "ChartAreaBrush": "solid:255,255,255", "ChartAreaBorderColor": "Transparent", "SeriesLabelsBrush": "empty", "SeriesLabelsColor": "0,0,0", "SeriesLabelsBorderColor": "Transparent", "TrendLineColor": "0,0,0", "TrendLineShowShadow": true, "LegendBrush": "empty", "LegendLabelsColor": "0,0,0", "LegendBorderColor": "Transparent", "LegendTitleColor": "Transparent", "AxisLabelsColor": "0,0,0", "MarkerVisible": false, "InterlacingHorBrush": "solid:10,155,155,155", "InterlacingVertBrush": "solid:10,155,155,155", "GridLinesHorColor": "100,105,105,105", "GridLinesVertColor": "100,105,105,105" } }, "Dictionary": { "DataSources": { "0": { "Ident": "StiMySqlSource", "Name": "ReportOrganisation", "Alias": "ReportOrganisation", "NameInSource": "e-RRAM", "SqlCommand": "SELECT o.* ,\r\nolf.base64 as logo_image\r\nFROM organisation o\r\n\r\nLEFT JOIN file olf\r\nON o.logo_file_id = olf.id\r\n\r\nWHERE \r\no.id = {reportOrganisationId}" }, "1": { "Ident": "StiMySqlSource", "Name": "ServiceCallsClosedNoWONational", "Alias": "ServiceCallsClosedNoWONational", "Columns": { "0": { "Name": "48_hrs_deadline", "Index": -1, "NameInSource": "48_hrs_deadline", "Alias": "48_hrs_deadline", "Type": "System.String" }, "1": { "Name": "call_location", "Index": -1, "NameInSource": "call_location", "Alias": "call_location", "Type": "System.String" }, "2": { "Name": "closed_date", "Index": -1, "NameInSource": "closed_date", "Alias": "closed_date", "Type": "System.String" }, "3": { "Name": "created_date", "Index": -1, "NameInSource": "created_date", "Alias": "created_date", "Type": "System.String" }, "4": { "Name": "created_user", "Index": -1, "NameInSource": "created_user", "Alias": "created_user", "Type": "System.String" }, "5": { "Name": "created_year", "Index": -1, "NameInSource": "created_year", "Alias": "created_year", "Type": "System.String" }, "6": { "Name": "customer_contact_number", "Index": -1, "NameInSource": "customer_contact_number", "Alias": "customer_contact_number", "Type": "System.String" }, "7": { "Name": "customer_email", "Index": -1, "NameInSource": "customer_email", "Alias": "customer_email", "Type": "System.String" }, "8": { "Name": "customer_name", "Index": -1, "NameInSource": "customer_name", "Alias": "customer_name", "Type": "System.String" }, "9": { "Name": "days_open", "Index": -1, "NameInSource": "days_open", "Alias": "days_open", "Type": "System.String" }, "10": { "Name": "description", "Index": -1, "NameInSource": "description", "Alias": "description", "Type": "System.String" }, "11": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "12": { "Name": "is_sales_call", "Index": -1, "NameInSource": "is_sales_call", "Alias": "is_sales_call", "Type": "System.String" }, "13": { "Name": "last_activity_timeframe", "Index": -1, "NameInSource": "last_activity_timeframe", "Alias": "last_activity_timeframe", "Type": "System.String" }, "14": { "Name": "local_region", "Index": -1, "NameInSource": "local_region", "Alias": "local_region", "Type": "System.String" }, "15": { "Name": "reference_number", "Index": -1, "NameInSource": "reference_number", "Alias": "reference_number", "Type": "System.String" }, "16": { "Name": "service_call_note", "Index": -1, "NameInSource": "service_call_note", "Alias": "service_call_note", "Type": "System.String" }, "17": { "Name": "service_call_note_date", "Index": -1, "NameInSource": "service_call_note_date", "Alias": "service_call_note_date", "Type": "System.String" }, "18": { "Name": "service_call_status", "Index": -1, "NameInSource": "service_call_status", "Alias": "service_call_status", "Type": "System.String" }, "19": { "Name": "service_call_type", "Index": -1, "NameInSource": "service_call_type", "Alias": "service_call_type", "Type": "System.String" }, "20": { "Name": "service_centre", "Index": -1, "NameInSource": "service_centre", "Alias": "service_centre", "Type": "System.String" }, "21": { "Name": "site", "Index": -1, "NameInSource": "site", "Alias": "site", "Type": "System.String" }, "22": { "Name": "unit_id", "Index": -1, "NameInSource": "unit_id", "Alias": "unit_id", "Type": "System.String" }, "23": { "Name": "updated_datetime", "Index": -1, "NameInSource": "updated_datetime", "Alias": "updated_datetime", "Type": "System.String" } }, "NameInSource": "e-RRAM", "SqlCommand": "select * from `ServiceCallsClosedNoWONational`" }, "2": { "Ident": "StiMySqlSource", "Name": "ServiceCallsNationalKPI", "Alias": "ServiceCallsNationalKPI", "Columns": { "0": { "Name": "48_hrs_deadline", "Index": -1, "NameInSource": "48_hrs_deadline", "Alias": "48_hrs_deadline", "Type": "System.String" }, "1": { "Name": "call_location", "Index": -1, "NameInSource": "call_location", "Alias": "call_location", "Type": "System.String" }, "2": { "Name": "created_date", "Index": -1, "NameInSource": "created_date", "Alias": "created_date", "Type": "System.String" }, "3": { "Name": "created_user", "Index": -1, "NameInSource": "created_user", "Alias": "created_user", "Type": "System.String" }, "4": { "Name": "created_year", "Index": -1, "NameInSource": "created_year", "Alias": "created_year", "Type": "System.String" }, "5": { "Name": "customer_contact_number", "Index": -1, "NameInSource": "customer_contact_number", "Alias": "customer_contact_number", "Type": "System.String" }, "6": { "Name": "customer_email", "Index": -1, "NameInSource": "customer_email", "Alias": "customer_email", "Type": "System.String" }, "7": { "Name": "customer_name", "Index": -1, "NameInSource": "customer_name", "Alias": "customer_name", "Type": "System.String" }, "8": { "Name": "days_open", "Index": -1, "NameInSource": "days_open", "Alias": "days_open", "Type": "System.String" }, "9": { "Name": "description", "Index": -1, "NameInSource": "description", "Alias": "description", "Type": "System.String" }, "10": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "11": { "Name": "is_sales_call", "Index": -1, "NameInSource": "is_sales_call", "Alias": "is_sales_call", "Type": "System.String" }, "12": { "Name": "last_activity_timeframe", "Index": -1, "NameInSource": "last_activity_timeframe", "Alias": "last_activity_timeframe", "Type": "System.String" }, "13": { "Name": "local_region", "Index": -1, "NameInSource": "local_region", "Alias": "local_region", "Type": "System.String" }, "14": { "Name": "reference_number", "Index": -1, "NameInSource": "reference_number", "Alias": "reference_number", "Type": "System.String" }, "15": { "Name": "service_call_note", "Index": -1, "NameInSource": "service_call_note", "Alias": "service_call_note", "Type": "System.String" }, "16": { "Name": "service_call_note_date", "Index": -1, "NameInSource": "service_call_note_date", "Alias": "service_call_note_date", "Type": "System.String" }, "17": { "Name": "service_call_status", "Index": -1, "NameInSource": "service_call_status", "Alias": "service_call_status", "Type": "System.String" }, "18": { "Name": "service_call_type", "Index": -1, "NameInSource": "service_call_type", "Alias": "service_call_type", "Type": "System.String" }, "19": { "Name": "service_centre", "Index": -1, "NameInSource": "service_centre", "Alias": "service_centre", "Type": "System.String" }, "20": { "Name": "site", "Index": -1, "NameInSource": "site", "Alias": "site", "Type": "System.String" }, "21": { "Name": "unit_id", "Index": -1, "NameInSource": "unit_id", "Alias": "unit_id", "Type": "System.String" }, "22": { "Name": "updated_datetime", "Index": -1, "NameInSource": "updated_datetime", "Alias": "updated_datetime", "Type": "System.String" } }, "NameInSource": "e-RRAM", "SqlCommand": "select * from `ServiceCallsNationalKPI`" } }, "Databases": { "0": { "Ident": "StiMySqlDatabase", "Name": "e-RRAM", "Alias": "e-RRAM", "ConnectionStringEncrypted": "1TC3DGlq" } } }, "Pages": { "0": { "Ident": "StiDashboard", "Name": "Dashboard1", "Guid": "882458e3252cad1dfa9d716b2eae624d", "Brush": "solid:255,255,255", "Components": { "0": { "Ident": "StiIndicatorElement", "Name": "IndicatorElement1", "Guid": "7f9d345d653b43a7dc97464f10359819", "ClientRectangle": "6,22,160,160", "Border": ";;;;", "Value": { "Ident": "ValueIndicatorMeter", "Key": "72dcabe5abb93be5708f2779f36b9881", "Expression": "Count(ServiceCallsNationalKPI.id)", "Label": "id" }, "Title": { "Text": "Total Calls" }, "Font": ";13;;", "DashboardInteraction": { "Ident": "Indicator", "OnHover": "ShowToolTip", "OnClick": "None", "HyperlinkDestination": "NewTab" } }, "1": { "Ident": "StiIndicatorElement", "Name": "IndicatorElement2", "Guid": "e274542685912afeef76d93513eca922", "ClientRectangle": "199,25,160,160", "Border": ";;;;", "Value": { "Ident": "ValueIndicatorMeter", "Key": "f7cf61a07879e9ccd928f7e3a79bb377", "Expression": "Count(ServiceCallsNationalKPI.id)", "Label": "id" }, "Title": { "Text": "Indicator" }, "Font": ";13;;", "DashboardInteraction": { "Ident": "Indicator", "OnHover": "ShowToolTip", "OnClick": "None", "HyperlinkDestination": "NewTab" } } }, "Border": ";;2;;;;;solid:Black", "BackColor": "255,255,255" } } }