{
"ReportVersion": "2022.4.5",
"ReportGuid": "080a98862b65afa9a60c4a1866899492",
"ReportName": "Report",
"ReportAlias": "Report",
"ReportCreated": "/Date(1681894201000+0200)/",
"ReportChanged": "/Date(1707230865000+0100)/",
"EngineVersion": "EngineV2",
"CalculationMode": "Interpretation",
"ReportUnit": "Centimeters",
"CacheAllData": true,
"Dictionary": {
"Variables": {
"0": {
"Name": "MIN",
"DialogInfo": {
"DateTimeType": "DateAndTime",
"SortDirection": "None",
"ItemsInitializationType": "Columns",
"KeysColumn": "Employees.MIN1",
"CheckedColumn": "null;",
"AllowUserValues": false
},
"Alias": "MIN",
"Type": "System.String",
"RequestFromUser": true,
"SelectionMode": "Nothing"
},
"1": {
"Name": "MAX",
"DialogInfo": {
"DateTimeType": "DateAndTime",
"SortDirection": "None",
"ItemsInitializationType": "Columns",
"KeysColumn": "Employees.MAX1",
"CheckedColumn": "null;",
"AllowUserValues": false
},
"Alias": "MAX",
"Type": "System.String",
"RequestFromUser": true,
"SelectionMode": "Nothing"
}
},
"DataSources": {
"0": {
"Ident": "StiSqlSource",
"Name": "EmployeeTerritories",
"Alias": "EmployeeTerritories",
"Key": "a45f238420a14da2bc8bd7337359a4a1",
"Columns": {
"0": {
"Name": "EmployeeID",
"NameInSource": "EmployeeID",
"Alias": "EmployeeID",
"Type": "System.Int32"
},
"1": {
"Name": "TerritoryID",
"NameInSource": "TerritoryID",
"Alias": "TerritoryID",
"Type": "System.String"
}
},
"NameInSource": "Connection_ok",
"SqlCommand": "select * from [EmployeeTerritories]"
},
"1": {
"Ident": "StiSqlSource",
"Name": "Employees",
"Alias": "Employees",
"Key": "ae63d163da514db585cb57a8740f8c4b",
"Columns": {
"0": {
"Name": "IMAGE",
"NameInSource": "IMAGE",
"Alias": "IMAGE",
"Type": "System.String"
},
"1": {
"Name": "MAX1",
"NameInSource": "MAX1",
"Alias": "MAX1",
"Type": "System.String"
},
"2": {
"Name": "MIN1",
"NameInSource": "MIN1",
"Alias": "MIN1",
"Type": "System.String"
},
"3": {
"Name": "EmployeeID",
"NameInSource": "EmployeeID",
"Alias": "EmployeeID",
"Type": "System.String"
},
"4": {
"Name": "LastName",
"NameInSource": "LastName",
"Alias": "LastName",
"Type": "System.String"
},
"5": {
"Name": "FirstName",
"NameInSource": "FirstName",
"Alias": "FirstName",
"Type": "System.String"
},
"6": {
"Name": "Title",
"NameInSource": "Title",
"Alias": "Title",
"Type": "System.String"
},
"7": {
"Name": "TitleOfCourtesy",
"NameInSource": "TitleOfCourtesy",
"Alias": "TitleOfCourtesy",
"Type": "System.String"
},
"8": {
"Name": "BirthDate",
"NameInSource": "BirthDate",
"Alias": "BirthDate",
"Type": "System.String"
},
"9": {
"Name": "HireDate",
"NameInSource": "HireDate",
"Alias": "HireDate",
"Type": "System.String"
},
"10": {
"Name": "Address",
"NameInSource": "Address",
"Alias": "Address",
"Type": "System.String"
},
"11": {
"Name": "City",
"NameInSource": "City",
"Alias": "City",
"Type": "System.String"
},
"12": {
"Name": "Region",
"NameInSource": "Region",
"Alias": "Region",
"Type": "System.String"
},
"13": {
"Name": "PostalCode",
"NameInSource": "PostalCode",
"Alias": "PostalCode",
"Type": "System.String"
},
"14": {
"Name": "Country",
"NameInSource": "Country",
"Alias": "Country",
"Type": "System.String"
},
"15": {
"Name": "HomePhone",
"NameInSource": "HomePhone",
"Alias": "HomePhone",
"Type": "System.String"
},
"16": {
"Name": "Extension",
"NameInSource": "Extension",
"Alias": "Extension",
"Type": "System.String"
},
"17": {
"Name": "Photo",
"NameInSource": "Photo",
"Alias": "Photo",
"Type": "System.String"
},
"18": {
"Name": "Notes",
"NameInSource": "Notes",
"Alias": "Notes",
"Type": "System.String"
},
"19": {
"Name": "ReportsTo",
"NameInSource": "ReportsTo",
"Alias": "ReportsTo",
"Type": "System.String"
},
"20": {
"Name": "PhotoPath",
"NameInSource": "PhotoPath",
"Alias": "PhotoPath",
"Type": "System.String"
},
"21": {
"Name": "EmployeeID",
"NameInSource": "EmployeeID",
"Alias": "EmployeeID",
"Type": "System.String"
},
"22": {
"Name": "TerritoryID",
"NameInSource": "TerritoryID",
"Alias": "TerritoryID",
"Type": "System.String"
}
},
"NameInSource": "Connection_ok",
"SqlCommand": "select 'https://VM171-ARXIVAR/ARXivarNextWebPortal/Images/test.jpg' as IMAGE, (select max(EmployeeTerritories.TerritoryID) from EmployeeTerritories) as MAX1, (select min(EmployeeTerritories.TerritoryID) from EmployeeTerritories) as MIN1 , * from [Employees]\r\ninner join EmployeeTerritories on Employees.EmployeeID = EmployeeTerritories.EmployeeID\r\n"
}
},
"Databases": {
"0": {
"Ident": "StiSqlDatabase",
"Name": "Connection_ok",
"Alias": "Connection_ok",
"Key": "17354d811aaf4e3c8e4f729a520e0f36",
"ConnectionStringEncrypted": "+WbRK+8LAVlsW7Xwatj1595wSetNBZqIRlv1pXjQJS/d2MuhT1zT3ct3TfTxTPafgVqDLM1s09X8TLlsY5zoJ9xWUy1iSzFx4V0h7MMA63vZNMvC1l3zmfgVzWzWHCXv4ejRCVZ9otV6BdVYwz2xJ5x44SnVaEI="
}
}
},
"Pages": {
"0": {
"Ident": "StiDashboard",
"Name": "Dashboard1",
"Guid": "7b9dfee9cd1bea3a66ca33b4eae62a1c",
"Brush": "solid:",
"Components": {
"0": {
"Ident": "StiTableElement",
"Name": "TableElement1",
"Guid": "e4603a09824cd858a7d8a8499f0d9e8a",
"ClientRectangle": "40,60,1120,160",
"Border": ";;;;",
"Columns": {
"0": {
"Ident": "DimensionColumn",
"Key": "b4134c58a089b8acacf6411f33883c63",
"Expression": "Employees.LastName",
"Label": "LastName",
"DashboardInteraction": {
"Ident": "TableColumn",
"OnHover": "None",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"Size": {
"MinWidth": 30,
"MaxWidth": 300
}
},
"1": {
"Ident": "DimensionColumn",
"Key": "874b3a3d682aa5e4758996de4e44b938",
"Expression": "Employees.FirstName",
"Label": "FirstName",
"DashboardInteraction": {
"Ident": "TableColumn",
"OnHover": "None",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"Size": {
"MinWidth": 30,
"MaxWidth": 300
}
},
"2": {
"Ident": "DimensionColumn",
"Key": "5a2d7cc390b6cf68c9aae0959d1e025e",
"Expression": "Employees.TerritoryID",
"Label": "TerritoryID",
"DashboardInteraction": {
"Ident": "TableColumn",
"OnHover": "None",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"Size": {
"MinWidth": 30,
"MaxWidth": 300
}
},
"3": {
"Ident": "DimensionColumn",
"Key": "1e148a9b7ba99de0508373760852bcc7",
"Expression": "ColorValue(\"#55009900\").",
"Label": "IMAGE",
"DashboardInteraction": {
"Ident": "TableColumn",
"OnHover": "None",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"ShowHyperlink": true,
"HyperlinkPattern": "www.google.com",
"Size": {
"MinWidth": 30,
"MaxWidth": 300
}
}
},
"DataFilters": {
"0": {
"Key": "0caa649f8f080d3aedd2875305dd6816",
"Path": "Employees.TerritoryID",
"Value": "{MAX}",
"IsExpression": true
},
"1": {
"Key": "e67ac65d062364dd1f270b9243dd1443",
"Path": "Employees.TerritoryID",
"Value": "{MIN}",
"IsExpression": true
}
},
"HeaderFont": ";10;;",
"FooterFont": ";10;;",
"Title": {
"Text": "Table",
"Visible": false
},
"DashboardInteraction": {
"Ident": "Table",
"OnHover": "ShowToolTip",
"OnClick": "ApplyFilter",
"HyperlinkDestination": "NewTab"
},
"CornerRadius": "0, 0, 0, 0",
"Shadow": ";;;"
},
"1": {
"Ident": "StiTableElement",
"Name": "TableElement2",
"Guid": "ef0c05e5451aa9544d77639e6b674cab",
"ClientRectangle": "40,260,1120,320",
"Border": ";;;;",
"Columns": {
"0": {
"Ident": "DimensionColumn",
"Key": "48344d6e62c0d61c6c4d98b61f25b2db",
"Expression": "Employees.LastName",
"Label": "LastName",
"DashboardInteraction": {
"Ident": "TableColumn",
"OnHover": "None",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"Size": {
"MinWidth": 30,
"MaxWidth": 300
}
},
"1": {
"Ident": "DimensionColumn",
"Key": "0413ed47ff1a8456cd8f9c2c26604c25",
"Expression": "Employees.FirstName",
"Label": "FirstName",
"DashboardInteraction": {
"Ident": "TableColumn",
"OnHover": "None",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"Size": {
"MinWidth": 30,
"MaxWidth": 300
}
},
"2": {
"Ident": "DimensionColumn",
"Key": "4315bb930148e1e4b47ddf137200f34a",
"Expression": "Employees.TerritoryID",
"Label": "TerritoryID",
"DashboardInteraction": {
"Ident": "TableColumn",
"OnHover": "None",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"Size": {
"MinWidth": 30,
"MaxWidth": 300
}
},
"3": {
"Ident": "DimensionColumn",
"Key": "a0761dbdf87b408b1df6cf08a241aee6",
"Expression": "Employees.IMAGE",
"Label": "IMAGE",
"DashboardInteraction": {
"Ident": "TableColumn",
"OnHover": "None",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"Size": {
"MinWidth": 30,
"MaxWidth": 300
}
}
},
"HeaderFont": ";10;;",
"FooterFont": ";10;;",
"Title": {
"Text": "Table",
"Visible": false
},
"DashboardInteraction": {
"Ident": "Table",
"OnHover": "ShowToolTip",
"OnClick": "ApplyFilter",
"HyperlinkDestination": "NewTab"
},
"CornerRadius": "0, 0, 0, 0",
"Shadow": ";;;"
},
"2": {
"Ident": "StiTextElement",
"Name": "TextElement1",
"Guid": "1e0e1410076f100ac72ce0287afd6c0d",
"ClientRectangle": "40,20,100,40",
"Border": ";;;;",
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
},
"Text": "FILTERED",
"CornerRadius": "0, 0, 0, 0",
"Shadow": ";;;",
"Title": {
"Text": "Text",
"Visible": false
}
},
"3": {
"Ident": "StiTextElement",
"Name": "TextElement2",
"Guid": "6af2b037a2a6afb71ce8038d9bbcb8b6",
"ClientRectangle": "40,220,100,40",
"Border": ";;;;",
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
},
"Text": "NOT FILTERED",
"CornerRadius": "0, 0, 0, 0",
"Shadow": ";;;",
"Title": {
"Text": "Text",
"Visible": false
}
},
"4": {
"Ident": "StiButtonElement",
"Name": "ButtonElement1",
"Guid": "c31c3c917712d0836f1c8427576becbe",
"ClientRectangle": "740,0,120,40",
"Border": "All;;2;;",
"CornerRadius": "0, 0, 0, 0",
"Shadow": ";;;",
"Brush": "style",
"TextBrush": "style",
"IconBrush": "style",
"VisualStates": {
"Hover": {
"Brush": "default",
"TextBrush": "default",
"IconBrush": "default"
},
"Pressed": {
"Brush": "default",
"TextBrush": "default",
"IconBrush": "default"
},
"Checked": {
"Brush": "default",
"TextBrush": "default",
"IconBrush": "default"
}
}
},
"5": {
"Ident": "StiComboBoxElement",
"Name": "ComboBoxElement1",
"Guid": "75a5c84dc767554d68f940fe995b00b8",
"ClientRectangle": "200,20,180,40",
"Border": ";;;;",
"KeyMeter": {
"Ident": "KeyComboBoxMeter",
"Key": "4bb1b649c83dad11f82d56c62128a954",
"Expression": "Employees.LastName",
"Label": "LastName"
},
"CornerRadius": "0, 0, 0, 0",
"Shadow": ";;;"
}
},
"Border": ";;2;;;;;solid:Black"
}
}
}