{ "ReportVersion": "2023.3.3", "ReportGuid": "d97f20bbeb4df512e1232fc00d66a16d", "ReportName": "081523_MappedJSON_Postman_Download", "ReportAlias": "081523_MappedJSON_Postman_Download", "ReportFile": "OverView.mrt", "ReportAuthor": "Eric Poon", "ReportCreated": "/Date(0-0800)/", "ReportChanged": "/Date(1697832028000-0700)/", "EngineVersion": "EngineV2", "CalculationMode": "Interpretation", "ReportUnit": "Centimeters", "ScriptLanguage": "CSharp", "Dictionary": { "DataSources": { "0": { "Ident": "StiDataTableSource", "Name": "FilterCriteria", "Alias": "FilterCriteria", "Columns": { "0": { "Name": "calculateDeliveryStatus", "NameInSource": "calculateDeliveryStatus", "Alias": "calculateDeliveryStatus", "Type": "System.Boolean" }, "1": { "Name": "includeCompletedProjects", "NameInSource": "includeCompletedProjects", "Alias": "includeCompletedProjects", "Type": "System.Boolean" }, "2": { "Name": "includeGroupProjects", "NameInSource": "includeGroupProjects", "Alias": "includeGroupProjects", "Type": "System.Boolean" }, "3": { "Name": "includePartialIdMatches", "NameInSource": "includePartialIdMatches", "Alias": "includePartialIdMatches", "Type": "System.Boolean" }, "4": { "Name": "includeProjectChanges", "NameInSource": "includeProjectChanges", "Alias": "includeProjectChanges", "Type": "System.Boolean" }, "5": { "Name": "includeRemovedProjects", "NameInSource": "includeRemovedProjects", "Alias": "includeRemovedProjects", "Type": "System.Boolean" }, "6": { "Name": "includeSubProjects", "NameInSource": "includeSubProjects", "Alias": "includeSubProjects", "Type": "System.Boolean" }, "7": { "Name": "isAcceptedLimitedToProjectLatest", "NameInSource": "isAcceptedLimitedToProjectLatest", "Alias": "isAcceptedLimitedToProjectLatest", "Type": "System.Boolean" }, "8": { "Name": "isFromReports", "NameInSource": "isFromReports", "Alias": "isFromReports", "Type": "System.Boolean" }, "9": { "Name": "isLimitedToProjectLatest", "NameInSource": "isLimitedToProjectLatest", "Alias": "isLimitedToProjectLatest", "Type": "System.Boolean" }, "10": { "Name": "page", "NameInSource": "page", "Alias": "page", "Type": "System.Decimal" }, "11": { "Name": "pageSize", "NameInSource": "pageSize", "Alias": "pageSize", "Type": "System.Decimal" }, "12": { "Name": "planCycles", "NameInSource": "planCycles", "Alias": "planCycles", "Type": "System.String" }, "13": { "Name": "sortColumn", "NameInSource": "sortColumn", "Alias": "sortColumn", "Type": "System.String" }, "14": { "Name": "sortDirection", "NameInSource": "sortDirection", "Alias": "sortDirection", "Type": "System.String" }, "15": { "Name": "useProjectDeliveryMode", "NameInSource": "useProjectDeliveryMode", "Alias": "useProjectDeliveryMode", "Type": "System.Boolean" } }, "NameInSource": "102023DataSource.FilterCriteria" }, "1": { "Ident": "StiDataTableSource", "Name": "FilterCriteria_planCycles", "Alias": "FilterCriteria_planCycles", "Columns": { "0": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" }, "1": { "Name": "value", "NameInSource": "value", "Alias": "value", "Type": "System.String" } }, "NameInSource": "102023DataSource.FilterCriteria_planCycles" }, "2": { "Ident": "StiDataTableSource", "Name": "Projects", "Alias": "Projects", "Columns": { "0": { "Name": "(CF)ContractNumber", "NameInSource": "(CF)ContractNumber", "Alias": "(CF)ContractNumber", "Type": "System.String" }, "1": { "Name": "BridgeNumber", "NameInSource": "BridgeNumber", "Alias": "BridgeNumber", "Type": "System.String" }, "2": { "Name": "County", "NameInSource": "County", "Alias": "County", "Type": "System.String" }, "3": { "Name": "DOTDistrict", "NameInSource": "DOTDistrict", "Alias": "DOTDistrict", "Type": "System.String" }, "4": { "Name": "Description", "NameInSource": "Description", "Alias": "Description", "Type": "System.String" }, "5": { "Name": "From", "NameInSource": "From", "Alias": "From", "Type": "System.String" }, "6": { "Name": "LeadAgency", "NameInSource": "LeadAgency", "Alias": "LeadAgency", "Type": "System.String" }, "7": { "Name": "Length", "NameInSource": "Length", "Alias": "Length", "Type": "System.String" }, "8": { "Name": "LocationType", "NameInSource": "LocationType", "Alias": "LocationType", "Type": "System.String" }, "9": { "Name": "MPO", "NameInSource": "MPO", "Alias": "MPO", "Type": "System.String" }, "10": { "Name": "Municipality", "NameInSource": "Municipality", "Alias": "Municipality", "Type": "System.String" }, "11": { "Name": "PlanRevision", "NameInSource": "PlanRevision", "Alias": "PlanRevision", "Type": "System.String" }, "12": { "Name": "ProjectFunding", "NameInSource": "ProjectFunding", "Alias": "ProjectFunding", "Type": "System.String" }, "13": { "Name": "ProjectFundingLabels", "NameInSource": "ProjectFundingLabels", "Alias": "ProjectFundingLabels", "Type": "System.String" }, "14": { "Name": "ProjectType", "NameInSource": "ProjectType", "Alias": "ProjectType", "Type": "System.String" }, "15": { "Name": "Route/RoadName", "NameInSource": "Route/RoadName", "Alias": "Route/RoadName", "Type": "System.String" }, "16": { "Name": "System", "NameInSource": "System", "Alias": "System", "Type": "System.String" }, "17": { "Name": "Title", "NameInSource": "Title", "Alias": "Title", "Type": "System.String" }, "18": { "Name": "To", "NameInSource": "To", "Alias": "To", "Type": "System.String" }, "19": { "Name": "TotalCost", "NameInSource": "TotalCost", "Alias": "TotalCost", "Type": "System.String" } }, "NameInSource": "102023DataSource.Projects" }, "3": { "Ident": "StiDataTableSource", "Name": "Projects_ProjectFunding", "Alias": "Projects_ProjectFunding", "Columns": { "0": { "Name": "FundSource", "NameInSource": "FundSource", "Alias": "FundSource", "Type": "System.String" }, "1": { "Name": "Future", "NameInSource": "Future", "Alias": "Future", "Type": "System.Decimal" }, "2": { "Name": "Phase", "NameInSource": "Phase", "Alias": "Phase", "Type": "System.String" }, "3": { "Name": "Prior", "NameInSource": "Prior", "Alias": "Prior", "Type": "System.Decimal" }, "4": { "Name": "Total", "NameInSource": "Total", "Alias": "Total", "Type": "System.Decimal" }, "5": { "Name": "Year1", "NameInSource": "Year1", "Alias": "Year1", "Type": "System.Decimal" }, "6": { "Name": "Year2", "NameInSource": "Year2", "Alias": "Year2", "Type": "System.Decimal" }, "7": { "Name": "Year3", "NameInSource": "Year3", "Alias": "Year3", "Type": "System.Decimal" }, "8": { "Name": "Year4", "NameInSource": "Year4", "Alias": "Year4", "Type": "System.Decimal" }, "9": { "Name": "Year5", "NameInSource": "Year5", "Alias": "Year5", "Type": "System.Decimal" }, "10": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "102023DataSource.Projects_ProjectFunding" }, "4": { "Ident": "StiDataTableSource", "Name": "Projects_ProjectFundingLabels", "Alias": "Projects_ProjectFundingLabels", "Columns": { "0": { "Name": "Year1", "NameInSource": "Year1", "Alias": "Year1", "Type": "System.String" }, "1": { "Name": "Year2", "NameInSource": "Year2", "Alias": "Year2", "Type": "System.String" }, "2": { "Name": "Year3", "NameInSource": "Year3", "Alias": "Year3", "Type": "System.String" }, "3": { "Name": "Year4", "NameInSource": "Year4", "Alias": "Year4", "Type": "System.String" }, "4": { "Name": "Year5", "NameInSource": "Year5", "Alias": "Year5", "Type": "System.String" }, "5": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "102023DataSource.Projects_ProjectFundingLabels" } }, "Databases": { "0": { "Ident": "StiJsonDatabase", "Name": "102023DataSource", "Alias": "102023DataSource", "PathData": "/Users/ericpoon/Desktop/102023DataSource.json", "HeadersString": "YyoQVHvZXeyY3LY5ASN05g==" } }, "Relations": { "0": { "Name": "FilterCriteria", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "planCycles" }, "NameInSource": "FilterCriteria_planCycles", "Alias": "FilterCriteria", "ParentSource": "FilterCriteria", "ChildSource": "FilterCriteria_planCycles" }, "1": { "Name": "Projects", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "ProjectFunding" }, "NameInSource": "Projects_ProjectFunding", "Alias": "Projects", "ParentSource": "Projects", "ChildSource": "Projects_ProjectFunding" }, "2": { "Name": "Projects", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "ProjectFundingLabels" }, "NameInSource": "Projects_ProjectFundingLabels", "Alias": "Projects", "ParentSource": "Projects", "ChildSource": "Projects_ProjectFundingLabels" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Page1", "Guid": "e47e884b8b7246eaa5c8749eeda9e7d0", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiPageHeaderBand", "Name": "PageHeaderBand1", "Guid": "8eadad2a82e34a88b60566d2c7bd99b7", "ClientRectangle": "0,0.4,25.9,1.6", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text23", "Guid": "bceed5a67ae84b43a65c918953ef6bfc", "ClientRectangle": "23.2,0.8,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Total" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";10;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text22", "Guid": "9c6bef922b334e629cf049ba568d106d", "ClientRectangle": "20.6,0.8,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectFundingLabels.Year5}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";10;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "DataColumn" }, "2": { "Ident": "StiText", "Name": "Text7", "Guid": "4e73bb23615246a6ba3b96388c23b1b9", "ClientRectangle": "18,0.8,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectFundingLabels.Year4}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";10;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "DataColumn" }, "3": { "Ident": "StiText", "Name": "Text6", "Guid": "f2f8a696ca664ab8bb520a98b8c09f5c", "ClientRectangle": "15.4,0.8,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectFundingLabels.Year3}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";10;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "DataColumn" }, "4": { "Ident": "StiText", "Name": "Text5", "Guid": "5e18dac345a64f508bb736e77d690568", "ClientRectangle": "12.8,0.8,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectFundingLabels.Year2}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";10;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "DataColumn" }, "5": { "Ident": "StiText", "Name": "Text4", "Guid": "4391e620b2a5462c9f89a6c663f79da5", "ClientRectangle": "10.2,0.8,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectFundingLabels.Year1}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";10;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "DataColumn" }, "6": { "Ident": "StiText", "Name": "Text3", "Guid": "4857bee27aa447619f4301f794011e0a", "ClientRectangle": "4.1,0.8,6.1,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Fund Source" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";10;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text1", "Guid": "a85198c5a8cf43449eda8097c7865bb9", "ClientRectangle": "0,0.8,4.1,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Phase" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";10;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text11", "Guid": "1e8fa8e396584475bf9bc23bb9e03108", "ClientRectangle": "0,0,21.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Placeholder Header Text" }, "VertAlignment": "Center", "Font": ";;Italic;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" } } }, "1": { "Ident": "StiPageFooterBand", "Name": "PageFooterBand1", "Guid": "5d533ff8d27340d4a324e13f91ea6b1e", "ClientRectangle": "0,18.8,25.9,0.8", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text21", "Guid": "756caa3d753a43a39c6f270aa866728e", "ClientRectangle": "7.8,0.2,10.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{PageNumber}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "SystemVariables" }, "1": { "Ident": "StiShape", "Name": "Shape3", "Guid": "6760251276954f558d54cc0a874b479a", "ClientRectangle": "0,0,26,0.2", "Interaction": { "Ident": "StiInteraction" }, "Brush": "solid:", "ShapeType": { "Ident": "StiHorizontalLineShapeType" }, "Font": ";;Italic;", "HorAlignment": "Left" }, "2": { "Ident": "StiText", "Name": "Text19", "Guid": "b48f4165479846ad934328d3b8d31fdd", "ClientRectangle": "0,0.2,7.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Placeholder Left Footer" }, "VertAlignment": "Center", "Font": ";;Italic;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text20", "Guid": "7213b553ca09486db63e292c62dc63e6", "ClientRectangle": "18,0.2,7.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Placeholder Right Footer" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Italic;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" } } }, "2": { "Ident": "StiDataBand", "Name": "DataBand1", "Guid": "23c04183485943a982873dd73b93d7b8", "ClientRectangle": "0,2.8,25.9,2.2", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text10", "ClientRectangle": "0,0,25.9,2", "Interaction": { "Ident": "StiInteraction" }, "VertAlignment": "Center", "Font": ";7;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:242,242,242", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text24", "Guid": "79341315609a4dfe94ffba9cb26f857b", "ClientRectangle": "0,0.2,21.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects.Title}" }, "VertAlignment": "Center", "Font": ";9;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "DataColumn" }, "2": { "Ident": "StiText", "Name": "Text25", "Guid": "2816593d1dce4b20a8a33c70871e1a86", "ClientRectangle": "21.2,0.2,4.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects.SIS}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";9;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "DataColumn" }, "3": { "Ident": "StiText", "Name": "Text26", "Guid": "4a654130e3994b38a386d653e8c82bd3", "ClientRectangle": "0,0.8,21.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects.ProjectType}" }, "VertAlignment": "Center", "Font": ";9;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "DataColumn" }, "4": { "Ident": "StiText", "Name": "Text27", "Guid": "7405e78e727d4a8895445c7e38f1c1b1", "ClientRectangle": "21.2,0.8,4.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Length: {Projects.RouteLength}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";9;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text28", "Guid": "dd6f12fb26284410aff19494e7cdce9f", "ClientRectangle": "0,1.4,25.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Responsible Agency: {projects.leadAgency}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";9;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "6": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive2", "Guid": "3a58223b223367237bc004f5a7c962ba", "ClientRectangle": "0,0,25.9,0.0254", "Interaction": { "Ident": "StiInteraction" }, "Size": 2, "StartCap": ";;;", "EndCap": ";;;" } }, "KeepDetails": "KeepDetailsTogether", "DataSourceName": "Projects", "KeepDetailsTogether": true }, "3": { "Ident": "StiDataBand", "Name": "DataBand2", "Guid": "ee42012ad4b04698bb4cd0d61b472d8b", "ClientRectangle": "0,5.8,25.9,0.4", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text38", "Guid": "123bcd88f92c457f832ce45546ec4634", "CanShrink": true, "ClientRectangle": "0,0,4.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectFunding.Phase}" }, "Border": "Top, Left, Right;Transparent;;None;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "TextFormat": { "Ident": "StiCurrencyFormatService", "GroupSeparator": "," }, "Type": "DataColumn" }, "1": { "Ident": "StiText", "Name": "Text39", "Guid": "1edeb661eada47d5a0e4f1c20fbe6de1", "CanShrink": true, "CanGrow": true, "ClientRectangle": "4.2,0,6,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectFunding.FundSource}" }, "Border": "Top, Left, Right;Transparent;;None;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "State": "DecimalDigits" }, "Type": "DataColumn" }, "2": { "Ident": "StiText", "Name": "Text40", "Guid": "84e7893620214b6389fa6065432979c6", "CanShrink": true, "ClientRectangle": "10.2,0,2.6,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectFunding.Year1}" }, "HorAlignment": "Right", "Border": "Top, Left, Right;Transparent;;None;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "UseLocalSetting": false, "State": "DecimalDigits" }, "Type": "DataColumn" }, "3": { "Ident": "StiText", "Name": "Text42", "Guid": "23f4a03744a647589ae2d80ea5aca234", "CanShrink": true, "ClientRectangle": "15.4,0,2.6,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectFunding.Year3}" }, "HorAlignment": "Right", "Border": "Top, Left, Right;Transparent;;None;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "UseLocalSetting": false, "State": "DecimalDigits" }, "Type": "DataColumn" }, "4": { "Ident": "StiText", "Name": "Text43", "Guid": "5fa4c1e46d1f49ab8cc5ed3314e5f75b", "CanShrink": true, "ClientRectangle": "18,0,2.6,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectFunding.Year4}" }, "HorAlignment": "Right", "Border": "Top, Left, Right;Transparent;;None;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "UseLocalSetting": false, "State": "DecimalDigits" }, "Type": "DataColumn" }, "5": { "Ident": "StiText", "Name": "Text44", "Guid": "d4d770a3769f4400bf7b98238d850487", "CanShrink": true, "ClientRectangle": "20.6,0,2.6,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectFunding.Year5}" }, "HorAlignment": "Right", "Border": "Top, Left, Right;Transparent;;None;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "UseLocalSetting": false, "State": "DecimalDigits" }, "Type": "DataColumn" }, "6": { "Ident": "StiText", "Name": "Text45", "Guid": "29cbd425d81d43558752c2cf4d9b0ddb", "CanShrink": true, "ClientRectangle": "23.2,0,2.6,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectFunding.Year1 + Projects_ProjectFunding.Year2 + Projects_ProjectFunding.Year3 + Projects_ProjectFunding.Year4 + Projects_ProjectFunding.Year5}" }, "HorAlignment": "Right", "Font": ";;Bold;", "Border": "Top, Left, Right;Transparent;;None;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "UseLocalSetting": false, "State": "DecimalDigits" }, "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text41", "Guid": "cbc027f93a6a46a1ac02ae250181ff81", "CanShrink": true, "ClientRectangle": "12.8,0,2.6,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectFunding.Year2}" }, "HorAlignment": "Right", "Border": "Top, Left, Right;Transparent;;None;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "UseLocalSetting": false, "State": "DecimalDigits" }, "Type": "DataColumn" } }, "DataSourceName": "Projects_ProjectFunding", "DataRelationName": "Projects_ProjectFunding", "FilterMode": "Or", "FilterOn": false, "MasterComponent": "DataBand1", "Filters": { "0": { "Ident": "StiFilter", "Condition": "NotContaining", "Column": "Phase", "Value1": "Total" } } }, "4": { "Ident": "StiDataBand", "Name": "DataBand4", "Guid": "63d91911b8cc484ab124efb3cef50f39", "ClientRectangle": "0,7,25.9,1.4", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text2", "Guid": "2778c37098b4472e85d26f7e898706a2", "ClientRectangle": "23.2,0.6,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects.TotalCost}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Italic;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "UseLocalSetting": false, "State": "DecimalDigits, PositivePattern, NegativePattern", "NegativePattern": 1 }, "Type": "DataColumn" }, "1": { "Ident": "StiText", "Name": "Text9", "Guid": "fa8f892948a34e6caed1424084c6612e", "ClientRectangle": "20.4,0.6,2.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Total Project Cost" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Italic;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text31", "Guid": "32f9f5677d074ab591ba50836c54e0b6", "ClientRectangle": "4.2,0,6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Total" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text32", "Guid": "7a5a29cd04824f1f83819eb6720362b3", "ClientRectangle": "10.2,0,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand2,Projects_ProjectFunding.Year1)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "UseLocalSetting": false, "State": "DecimalDigits" }, "Type": "Totals" }, "4": { "Ident": "StiText", "Name": "Text33", "Guid": "b5e19a94353645ea85d248f5533c2ec1", "ClientRectangle": "12.8,0,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand2,Projects_ProjectFunding.Year2)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "UseLocalSetting": false, "State": "DecimalDigits" }, "Type": "Totals" }, "5": { "Ident": "StiText", "Name": "Text34", "Guid": "d56d48a545ad43e487660e6395ac1f3f", "ClientRectangle": "15.4,0,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand2,Projects_ProjectFunding.Year3)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "UseLocalSetting": false, "State": "DecimalDigits" }, "Type": "Totals" }, "6": { "Ident": "StiText", "Name": "Text35", "Guid": "f1a17fcd1aeb4cca9f8c13e6be068c87", "ClientRectangle": "18,0,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand2,Projects_ProjectFunding.Year4)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "UseLocalSetting": false, "State": "DecimalDigits" }, "Type": "Totals" }, "7": { "Ident": "StiText", "Name": "Text36", "Guid": "a7e3438f9e914cd79125be13414e12da", "ClientRectangle": "20.6,0,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand2,Projects_ProjectFunding.Year5)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "UseLocalSetting": false, "State": "DecimalDigits" }, "Type": "Totals" }, "8": { "Ident": "StiText", "Name": "Text37", "Guid": "f95b0b713cea4f7dbcddb8ea2ad50b80", "ClientRectangle": "23.2,0,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand2,Projects_ProjectFunding.Year1) + Sum(DataBand2,Projects_ProjectFunding.Year2) + Sum(DataBand2,Projects_ProjectFunding.Year3) + Sum(DataBand2,Projects_ProjectFunding.Year4) + Sum(DataBand2,Projects_ProjectFunding.Year5) }" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "UseLocalSetting": false, "State": "DecimalDigits" }, "Type": "Expression" }, "9": { "Ident": "StiText", "Name": "Text8", "Guid": "9a1e77639cf447e09c86da0973f04e3a", "ClientRectangle": "15.4,0.6,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand2,Projects_ProjectFunding.Future)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Italic;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "UseLocalSetting": false, "State": "DecimalDigits, PositivePattern, NegativePattern", "NegativePattern": 1 }, "Type": "Totals" }, "10": { "Ident": "StiText", "Name": "Text16", "Guid": "e2c6b8e2435146799688d7b013c5b0d8", "ClientRectangle": "12.8,0.6,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Future Cost >" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Italic;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "11": { "Ident": "StiText", "Name": "Text15", "Guid": "3b1c405eebe04fed98948f77257bfe5f", "ClientRectangle": "10.2,0.6,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand2,Projects_ProjectFunding.Prior)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Italic;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "UseLocalSetting": false, "State": "DecimalDigits, PositivePattern, NegativePattern", "NegativePattern": 1 }, "Type": "Totals" }, "12": { "Ident": "StiText", "Name": "Text14", "Guid": "6d4d570fbd814462ba485d8197fed3cd", "ClientRectangle": "6.7,0.6,3.5,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Prior Cost < {projects_projectFundingLabels.year1}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Italic;", "Border": "Top, Left, Right;Transparent;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "13": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive1", "ClientRectangle": "4.2,0.6,21.6,0.0254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" } }, "MasterComponent": "DataBand1" } }, "PaperSize": "Letter", "Orientation": "Landscape", "PageWidth": 27.9, "PageHeight": 21.6, "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 1, "Right": 1, "Top": 1, "Bottom": 1 } } } }