{ "ReportVersion": "2023.3.3", "ReportGuid": "3c6b6c73c7c944f08b1a3987d5a9d6ab", "ReportName": "Report", "ReportAlias": "Report", "ReportFile": "NDOT_Work Program Report", "ReportAuthor": "Eric Poon", "ReportCreated": "/Date(1697178375000-0700)/", "ReportChanged": "/Date(1697578320000-0700)/", "EngineVersion": "EngineV2", "CalculationMode": "Interpretation", "ReportUnit": "Centimeters", "Dictionary": { "DataSources": { "0": { "Ident": "StiDataTableSource", "Name": "FilterCriteria", "Alias": "FilterCriteria", "Columns": { "0": { "Name": "calculateDeliveryStatus", "NameInSource": "calculateDeliveryStatus", "Alias": "calculateDeliveryStatus", "Type": "System.Boolean" }, "1": { "Name": "clientProjectId", "NameInSource": "clientProjectId", "Alias": "clientProjectId", "Type": "System.String" }, "2": { "Name": "countyIds", "NameInSource": "countyIds", "Alias": "countyIds", "Type": "System.String" }, "3": { "Name": "doCarryOverCalculation", "NameInSource": "doCarryOverCalculation", "Alias": "doCarryOverCalculation", "Type": "System.Boolean" }, "4": { "Name": "includeCompletedProjects", "NameInSource": "includeCompletedProjects", "Alias": "includeCompletedProjects", "Type": "System.Boolean" }, "5": { "Name": "includeGroupProjects", "NameInSource": "includeGroupProjects", "Alias": "includeGroupProjects", "Type": "System.Boolean" }, "6": { "Name": "includePartialIdMatches", "NameInSource": "includePartialIdMatches", "Alias": "includePartialIdMatches", "Type": "System.Boolean" }, "7": { "Name": "includeRemovedProjects", "NameInSource": "includeRemovedProjects", "Alias": "includeRemovedProjects", "Type": "System.Boolean" }, "8": { "Name": "includeSubProjects", "NameInSource": "includeSubProjects", "Alias": "includeSubProjects", "Type": "System.Boolean" }, "9": { "Name": "isAcceptedLimitedToProjectLatest", "NameInSource": "isAcceptedLimitedToProjectLatest", "Alias": "isAcceptedLimitedToProjectLatest", "Type": "System.Boolean" }, "10": { "Name": "isFromReports", "NameInSource": "isFromReports", "Alias": "isFromReports", "Type": "System.Boolean" }, "11": { "Name": "isLimitedToProjectLatest", "NameInSource": "isLimitedToProjectLatest", "Alias": "isLimitedToProjectLatest", "Type": "System.Boolean" }, "12": { "Name": "orderBy", "NameInSource": "orderBy", "Alias": "orderBy", "Type": "System.String" }, "13": { "Name": "planCycles", "NameInSource": "planCycles", "Alias": "planCycles", "Type": "System.String" }, "14": { "Name": "sortColumn", "NameInSource": "sortColumn", "Alias": "sortColumn", "Type": "System.String" }, "15": { "Name": "sortDirection", "NameInSource": "sortDirection", "Alias": "sortDirection", "Type": "System.String" }, "16": { "Name": "useJSReport", "NameInSource": "useJSReport", "Alias": "useJSReport", "Type": "System.Boolean" }, "17": { "Name": "useProjectDeliveryMode", "NameInSource": "useProjectDeliveryMode", "Alias": "useProjectDeliveryMode", "Type": "System.Boolean" } }, "NameInSource": "eTracker_Generic JSON.FilterCriteria" }, "1": { "Ident": "StiDataTableSource", "Name": "FilterCriteria_countyIds", "Alias": "FilterCriteria_countyIds", "Columns": { "0": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" }, "1": { "Name": "value", "NameInSource": "value", "Alias": "value", "Type": "System.String" } }, "NameInSource": "eTracker_Generic JSON.FilterCriteria_countyIds" }, "2": { "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": "eTracker_Generic JSON.FilterCriteria_planCycles" }, "3": { "Ident": "StiDataTableSource", "Name": "Projects", "Alias": "Projects", "Columns": { "0": { "Name": "ProjectRevisions", "NameInSource": "ProjectRevisions", "Alias": "ProjectRevisions", "Type": "System.String" } }, "NameInSource": "eTracker_Generic JSON.Projects" }, "4": { "Ident": "StiDataTableSource", "Name": "Projects_ProjectRevisions", "Alias": "Projects_ProjectRevisions", "Columns": { "0": { "Name": "ADOT", "NameInSource": "ADOT", "Alias": "ADOT", "Type": "System.Decimal" }, "1": { "Name": "ChangeReason", "NameInSource": "ChangeReason", "Alias": "ChangeReason", "Type": "System.String" }, "2": { "Name": "County", "NameInSource": "County", "Alias": "County", "Type": "System.String" }, "3": { "Name": "Description", "NameInSource": "Description", "Alias": "Description", "Type": "System.String" }, "4": { "Name": "EA", "NameInSource": "EA", "Alias": "EA", "Type": "System.Decimal" }, "5": { "Name": "FEDERALPROJECT", "NameInSource": "FEDERALPROJECT", "Alias": "FEDERALPROJECT", "Type": "System.Decimal" }, "6": { "Name": "FederalProjectNumber", "NameInSource": "FederalProjectNumber", "Alias": "FederalProjectNumber", "Type": "System.Decimal" }, "7": { "Name": "FiscalYearEnd", "NameInSource": "FiscalYearEnd", "Alias": "FiscalYearEnd", "Type": "System.Decimal" }, "8": { "Name": "FiscalYearStart", "NameInSource": "FiscalYearStart", "Alias": "FiscalYearStart", "Type": "System.Decimal" }, "9": { "Name": "GrandTotal", "NameInSource": "GrandTotal", "Alias": "GrandTotal", "Type": "System.Decimal" }, "10": { "Name": "LeadAgency", "NameInSource": "LeadAgency", "Alias": "LeadAgency", "Type": "System.String" }, "11": { "Name": "LocalID", "NameInSource": "LocalID", "Alias": "LocalID", "Type": "System.Decimal" }, "12": { "Name": "MPO", "NameInSource": "MPO", "Alias": "MPO", "Type": "System.String" }, "13": { "Name": "MPOID", "NameInSource": "MPOID", "Alias": "MPOID", "Type": "System.Decimal" }, "14": { "Name": "Municipality", "NameInSource": "Municipality", "Alias": "Municipality", "Type": "System.String" }, "15": { "Name": "NarrativeDescriptionOfChanges", "NameInSource": "NarrativeDescriptionOfChanges", "Alias": "NarrativeDescriptionOfChanges", "Type": "System.String" }, "16": { "Name": "PCEMS", "NameInSource": "PCEMS", "Alias": "PCEMS", "Type": "System.Decimal" }, "17": { "Name": "PSAMS", "NameInSource": "PSAMS", "Alias": "PSAMS", "Type": "System.String" }, "18": { "Name": "Plan", "NameInSource": "Plan", "Alias": "Plan", "Type": "System.String" }, "19": { "Name": "PlanCycle", "NameInSource": "PlanCycle", "Alias": "PlanCycle", "Type": "System.String" }, "20": { "Name": "PlanOwner", "NameInSource": "PlanOwner", "Alias": "PlanOwner", "Type": "System.String" }, "21": { "Name": "PlanRevision", "NameInSource": "PlanRevision", "Alias": "PlanRevision", "Type": "System.String" }, "22": { "Name": "PlanRevisionType", "NameInSource": "PlanRevisionType", "Alias": "PlanRevisionType", "Type": "System.String" }, "23": { "Name": "PrimaryEmail", "NameInSource": "PrimaryEmail", "Alias": "PrimaryEmail", "Type": "System.String" }, "24": { "Name": "PrimaryName", "NameInSource": "PrimaryName", "Alias": "PrimaryName", "Type": "System.String" }, "25": { "Name": "PrimaryOrganization", "NameInSource": "PrimaryOrganization", "Alias": "PrimaryOrganization", "Type": "System.String" }, "26": { "Name": "PrimaryPhone", "NameInSource": "PrimaryPhone", "Alias": "PrimaryPhone", "Type": "System.String" }, "27": { "Name": "ProjectId", "NameInSource": "ProjectId", "Alias": "ProjectId", "Type": "System.Decimal" }, "28": { "Name": "ProjectIdentifier", "NameInSource": "ProjectIdentifier", "Alias": "ProjectIdentifier", "Type": "System.String" }, "29": { "Name": "ProjectRevisionFunding", "NameInSource": "ProjectRevisionFunding", "Alias": "ProjectRevisionFunding", "Type": "System.String" }, "30": { "Name": "ProjectRevisionId", "NameInSource": "ProjectRevisionId", "Alias": "ProjectRevisionId", "Type": "System.String" }, "31": { "Name": "ProjectRevisionLocations", "NameInSource": "ProjectRevisionLocations", "Alias": "ProjectRevisionLocations", "Type": "System.String" }, "32": { "Name": "ProjectRevisionTypeCategory", "NameInSource": "ProjectRevisionTypeCategory", "Alias": "ProjectRevisionTypeCategory", "Type": "System.String" }, "33": { "Name": "ProjectType", "NameInSource": "ProjectType", "Alias": "ProjectType", "Type": "System.String" }, "34": { "Name": "SECT", "NameInSource": "SECT", "Alias": "SECT", "Type": "System.Decimal" }, "35": { "Name": "SPONSORID", "NameInSource": "SPONSORID", "Alias": "SPONSORID", "Type": "System.Decimal" }, "36": { "Name": "SecondaryEmail", "NameInSource": "SecondaryEmail", "Alias": "SecondaryEmail", "Type": "System.String" }, "37": { "Name": "SecondaryName", "NameInSource": "SecondaryName", "Alias": "SecondaryName", "Type": "System.String" }, "38": { "Name": "SecondaryOrganization", "NameInSource": "SecondaryOrganization", "Alias": "SecondaryOrganization", "Type": "System.String" }, "39": { "Name": "SecondaryPhone", "NameInSource": "SecondaryPhone", "Alias": "SecondaryPhone", "Type": "System.String" }, "40": { "Name": "Title", "NameInSource": "Title", "Alias": "Title", "Type": "System.String" }, "41": { "Name": "YearsIncluded", "NameInSource": "YearsIncluded", "Alias": "YearsIncluded", "Type": "System.String" }, "42": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "eTracker_Generic JSON.Projects_ProjectRevisions" }, "5": { "Ident": "StiDataTableSource", "Name": "Projects_ProjectRevisions_ProjectRevisionFunding", "Alias": "Projects_ProjectRevisions_ProjectRevisionFunding", "Columns": { "0": { "Name": "AcAccpFlag", "NameInSource": "AcAccpFlag", "Alias": "AcAccpFlag", "Type": "System.String" }, "1": { "Name": "CON", "NameInSource": "CON", "Alias": "CON", "Type": "System.Decimal" }, "2": { "Name": "FiscalYear", "NameInSource": "FiscalYear", "Alias": "FiscalYear", "Type": "System.Decimal" }, "3": { "Name": "FundType", "NameInSource": "FundType", "Alias": "FundType", "Type": "System.String" }, "4": { "Name": "ImprovementType", "NameInSource": "ImprovementType", "Alias": "ImprovementType", "Type": "System.String" }, "5": { "Name": "LettingDate", "NameInSource": "LettingDate", "Alias": "LettingDate", "Type": "System.String" }, "6": { "Name": "OTH", "NameInSource": "OTH", "Alias": "OTH", "Type": "System.Decimal" }, "7": { "Name": "PE", "NameInSource": "PE", "Alias": "PE", "Type": "System.Decimal" }, "8": { "Name": "PurchaseOrder", "NameInSource": "PurchaseOrder", "Alias": "PurchaseOrder", "Type": "System.String" }, "9": { "Name": "ROW", "NameInSource": "ROW", "Alias": "ROW", "Type": "System.Decimal" }, "10": { "Name": "Section", "NameInSource": "Section", "Alias": "Section", "Type": "System.String" }, "11": { "Name": "Total", "NameInSource": "Total", "Alias": "Total", "Type": "System.Decimal" }, "12": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "eTracker_Generic JSON.Projects_ProjectRevisions_ProjectRevisionFunding" }, "6": { "Ident": "StiDataTableSource", "Name": "Projects_ProjectRevisions_ProjectRevisionLocations", "Alias": "Projects_ProjectRevisions_ProjectRevisionLocations", "Columns": { "0": { "Name": "BridgeNumber", "NameInSource": "BridgeNumber", "Alias": "BridgeNumber", "Type": "System.String" }, "1": { "Name": "LocationType", "NameInSource": "LocationType", "Alias": "LocationType", "Type": "System.String" }, "2": { "Name": "RouteRoadName", "NameInSource": "RouteRoadName", "Alias": "RouteRoadName", "Type": "System.String" }, "3": { "Name": "System", "NameInSource": "System", "Alias": "System", "Type": "System.String" }, "4": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "eTracker_Generic JSON.Projects_ProjectRevisions_ProjectRevisionLocations" }, "7": { "Ident": "StiDataTableSource", "Name": "Projects_ProjectRevisions_YearsIncluded", "Alias": "Projects_ProjectRevisions_YearsIncluded", "Columns": { "0": { "Name": "FiscalYear", "NameInSource": "FiscalYear", "Alias": "FiscalYear", "Type": "System.Decimal" }, "1": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "eTracker_Generic JSON.Projects_ProjectRevisions_YearsIncluded" } }, "Databases": { "0": { "Ident": "StiJsonDatabase", "Name": "eTracker_Generic JSON", "Alias": "eTracker_Generic JSON", "PathData": "/Users/ericpoon/Desktop/eTracker_Generic JSON.json", "HeadersString": "YyoQVHvZXeyY3LY5ASN05g==" } }, "Relations": { "0": { "Name": "FilterCriteria", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "countyIds" }, "NameInSource": "FilterCriteria_countyIds", "Alias": "FilterCriteria", "ParentSource": "FilterCriteria", "ChildSource": "FilterCriteria_countyIds" }, "1": { "Name": "FilterCriteria", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "planCycles" }, "NameInSource": "FilterCriteria_planCycles", "Alias": "FilterCriteria", "ParentSource": "FilterCriteria", "ChildSource": "FilterCriteria_planCycles" }, "2": { "Name": "Projects", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "ProjectRevisions" }, "NameInSource": "Projects_ProjectRevisions", "Alias": "Projects", "ParentSource": "Projects", "ChildSource": "Projects_ProjectRevisions" }, "3": { "Name": "Projects_ProjectRevisions", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "ProjectRevisionFunding" }, "NameInSource": "Projects_ProjectRevisions_ProjectRevisionFunding", "Alias": "Projects_ProjectRevisions", "ParentSource": "Projects_ProjectRevisions", "ChildSource": "Projects_ProjectRevisions_ProjectRevisionFunding" }, "4": { "Name": "Projects_ProjectRevisions", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "ProjectRevisionLocations" }, "NameInSource": "Projects_ProjectRevisions_ProjectRevisionLocations", "Alias": "Projects_ProjectRevisions", "ParentSource": "Projects_ProjectRevisions", "ChildSource": "Projects_ProjectRevisions_ProjectRevisionLocations" }, "5": { "Name": "Projects_ProjectRevisions", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "YearsIncluded" }, "NameInSource": "Projects_ProjectRevisions_YearsIncluded", "Alias": "Projects_ProjectRevisions", "ParentSource": "Projects_ProjectRevisions", "ChildSource": "Projects_ProjectRevisions_YearsIncluded" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Page1", "Guid": "26067fe579389442fce6c8c4e1f2987b", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiPageHeaderBand", "Name": "PageHeaderBand1", "Guid": "0c6d6b80e3cd555370d3fe1f30bc7a60", "ClientRectangle": "0,0.4,44,2.78", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text12", "Guid": "815383fc4e04a6dd067eec4062eaf505", "ClientRectangle": "0,0,44,1.6", "Interaction": { "Ident": "StiInteraction" }, "Font": "Segoe UI;;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:44,77,117", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text1", "Guid": "e3c1fdba78f8c6a3c6a4cc034b61da51", "ClientRectangle": "0,0.2,12.3,0.59", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Nevada DOT Header Text" }, "VertAlignment": "Center", "Font": ";10;Bold;", "Border": ";Transparent;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:255,255,255", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text2", "Guid": "052938e7ee7c73dc571c495628b62a8d", "ClientRectangle": "0,0.79,12.3,0.61", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "STIP and Work Program Prioritization Results" }, "VertAlignment": "Center", "Font": ";10;Bold;", "Border": ";Transparent;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:255,255,255", "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text6", "Guid": "ecbe476162c2d20f615efc020feb4991", "ClientRectangle": "0,1.6,2.2,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "TIP ID" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "solid:58,102,155", "TextBrush": "solid:255,255,255", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text5", "Guid": "c36e4a1694e8ca38dcb1fe96dab8e5f2", "ClientRectangle": "2.2,1.6,2.2,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "PCEMS" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "solid:58,102,155", "TextBrush": "solid:255,255,255", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text7", "Guid": "41b40d0823c881c7785b97a2c81dad5e", "ClientRectangle": "4.4,1.6,2.2,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "PSAMS" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "solid:58,102,155", "TextBrush": "solid:255,255,255", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "6": { "Ident": "StiText", "Name": "Text8", "Guid": "8fc47ec7fd3a4c2d656501d3dc137955", "ClientRectangle": "6.6,1.6,5.8,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "PROJECT TITLE" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "solid:58,102,155", "TextBrush": "solid:255,255,255", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text18", "Guid": "f6320a08496c0dd5fdff39f8918e1b5d", "ClientRectangle": "34.4,1.6,2.6,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectRevisions.FiscalYearStart}-{Projects_ProjectRevisions.FiscalYearEnd} \r\nFunding" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "solid:58,102,155", "TextBrush": "solid:255,255,255", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text19", "Guid": "69567f27d58439fb80567087ecba7155", "ClientRectangle": "37,1.6,2.4,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "County" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "solid:58,102,155", "TextBrush": "solid:255,255,255", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "9": { "Ident": "StiText", "Name": "Text20", "Guid": "661b0985078ab45f08cefb3fc9bd038c", "ClientRectangle": "39.4,1.6,4.6,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Primary Project Type" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "solid:58,102,155", "TextBrush": "solid:255,255,255", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "10": { "Ident": "StiText", "Name": "Text9", "Guid": "4975046860e8badddbc85ce3bed28720", "ClientRectangle": "12.4,1.6,2.2,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectRevisions.FiscalYearStart} Funding PE / ROW" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "solid:200,95,41", "TextBrush": "solid:255,255,255", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "11": { "Ident": "StiText", "Name": "Text10", "Guid": "2e760f3ff5d5c2dca548066920acb524", "ClientRectangle": "14.6,1.6,2.2,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(Projects_ProjectRevisions.FiscalYearStart)+1} Funding PE / ROW" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "solid:200,95,41", "TextBrush": "solid:255,255,255", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "12": { "Ident": "StiText", "Name": "Text11", "Guid": "d0a22457b2ebb4cb32e0a91227316bd5", "ClientRectangle": "16.8,1.6,2.2,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(Projects_ProjectRevisions.FiscalYearStart)+2} Funding PE / ROW" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "solid:200,95,41", "TextBrush": "solid:255,255,255", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "13": { "Ident": "StiText", "Name": "Text13", "Guid": "ba072f0b693b2ca2b288adb4589dbfd2", "ClientRectangle": "19,1.6,2.2,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(Projects_ProjectRevisions.FiscalYearStart)+3} Funding PE / ROW" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "solid:200,95,41", "TextBrush": "solid:255,255,255", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "14": { "Ident": "StiText", "Name": "Text14", "Guid": "c7e17533aa32f5516cab0fb642a1d691", "ClientRectangle": "23.4,1.6,2.2,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectRevisions.FiscalYearStart} Funding CON / OTHER" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "solid:200,95,41", "TextBrush": "solid:255,255,255", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "15": { "Ident": "StiText", "Name": "Text15", "Guid": "018c6703b5f9b08b35e6b4bcaa803449", "ClientRectangle": "25.6,1.6,2.2,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(Projects_ProjectRevisions.FiscalYearStart)+1} Funding CON / OTHER" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "solid:200,95,41", "TextBrush": "solid:255,255,255", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "16": { "Ident": "StiText", "Name": "Text16", "Guid": "6d84a0f636e8bd4f3ebb081b1f4e3931", "ClientRectangle": "27.8,1.6,2.2,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(Projects_ProjectRevisions.FiscalYearStart)+2} Funding CON / OTHER" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "solid:200,95,41", "TextBrush": "solid:255,255,255", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "17": { "Ident": "StiText", "Name": "Text17", "Guid": "b54e1cc8e5b403372efeda43fa12aade", "ClientRectangle": "30,1.6,2.2,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(Projects_ProjectRevisions.FiscalYearStart)+3} Funding CON / OTHER" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "solid:200,95,41", "TextBrush": "solid:255,255,255", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "18": { "Ident": "StiText", "Name": "Text36", "Guid": "9ac18c8462b7d17f58e8a5d20b11313f", "ClientRectangle": "21.2,1.6,2.2,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(Projects_ProjectRevisions.FiscalYearStart)+4} Funding PE / ROW" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "solid:200,95,41", "TextBrush": "solid:255,255,255", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "19": { "Ident": "StiText", "Name": "Text37", "Guid": "dce8a7af727fdf3cbf872426ffa9b513", "ClientRectangle": "32.2,1.6,2.2,1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(Projects_ProjectRevisions.FiscalYearStart)+4} Funding CON / OTHER" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "solid:200,95,41", "TextBrush": "solid:255,255,255", "TextOptions": { "WordWrap": true }, "Type": "Expression" } } }, "1": { "Ident": "StiPanel", "Name": "Panel2", "ClientRectangle": "2.6,8,25.2,6", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiCrossDataBand", "Name": "CrossDataBand2", "ClientRectangle": "0,0,2,6", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text3", "ClientRectangle": "0,0,2,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectRevisions_YearsIncluded.FiscalYear}" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "DataColumn" } }, "DataSourceName": "Projects_ProjectRevisions_YearsIncluded" } } }, "2": { "Ident": "StiDataBand", "Name": "DataBand2", "Guid": "029c517884b2db3f81fe344eb4cd590a", "ClientRectangle": "0,3.98,44,0.2", "Enabled": false, "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:" }, "3": { "Ident": "StiDataBand", "Name": "DataBand1", "ClientRectangle": "0,4.98,44,0.6", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text21", "Guid": "628adf1ef6957f5d6b1ce18573c2d303", "ClientRectangle": "0,0.02,2.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectRevisions.ProjectId}" }, "VertAlignment": "Center", "Font": ";7;;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "DataColumn" }, "1": { "Ident": "StiText", "Name": "Text22", "Guid": "b4d7b3d3307405b0d3dd40149b429759", "ClientRectangle": "2.2,0.02,2.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectRevisions.PCEMS}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";7;;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "DataColumn" }, "2": { "Ident": "StiText", "Name": "Text23", "Guid": "654d6c22bc96ade2209f55b5576c838f", "ClientRectangle": "4.4,0.02,2.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectRevisions.PSAMS}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";7;;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text24", "Guid": "6f1c18f2aaff6a04eeab4a76f14284e8", "ClientRectangle": "6.6,0.02,5.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectRevisions.Title}" }, "VertAlignment": "Center", "Font": ";7;;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "DataColumn" }, "4": { "Ident": "StiText", "Name": "Text34", "Guid": "2474c0e9d03dc4ffb5935bab2f89bb57", "ClientRectangle": "37,0.02,2.4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectRevisions.County}" }, "VertAlignment": "Center", "Font": ";7;;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "DataColumn" }, "5": { "Ident": "StiText", "Name": "Text35", "Guid": "0197d841296f36e54f48d4f584d9728b", "ClientRectangle": "39.4,0.02,4.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectRevisions.ProjectType}" }, "VertAlignment": "Center", "Font": ";7;;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "DataColumn" }, "6": { "Ident": "StiPanel", "Name": "Panel1", "ClientRectangle": "12.4,0.02,11,0.6", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiCrossDataBand", "Name": "CrossDataBand1", "ClientRectangle": "0,0,2.2,0.6", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text25", "ClientRectangle": "0,0,2.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectRevisions_ProjectRevisionFunding.PE + Projects_ProjectRevisions_ProjectRevisionFunding.ROW}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";7;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "State": "DecimalDigits" }, "Type": "Expression" } }, "DataSourceName": "Projects_ProjectRevisions_ProjectRevisionFunding", "DataRelationName": "Projects_ProjectRevisions_ProjectRevisionFunding", "FilterOn": false, "MasterComponent": "DataBand1" } } }, "7": { "Ident": "StiPanel", "Name": "Panel3", "Guid": "4bdc8cafe9bfa91740880a8add3eb4d8", "ClientRectangle": "23.4,0.02,11,0.6", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiCrossDataBand", "Name": "CrossDataBand3", "Guid": "f9415d91c8a076a21730e3a7d232bb98", "ClientRectangle": "0,0,2.2,0.6", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text40", "Guid": "35640d4b57432cd95107c1b6e20597e7", "ClientRectangle": "0,0,2.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectRevisions_ProjectRevisionFunding.CON + Projects_ProjectRevisions_ProjectRevisionFunding.OTH}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";7;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "State": "DecimalDigits" }, "Type": "Expression" } }, "DataSourceName": "Projects_ProjectRevisions_ProjectRevisionFunding", "DataRelationName": "Projects_ProjectRevisions_ProjectRevisionFunding", "FilterOn": false, "MasterComponent": "DataBand1" } } }, "8": { "Ident": "StiText", "Name": "Text38", "Guid": "4fa43aa324a2244268bd2dae489e50bb", "ClientRectangle": "34.4,0.02,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_ProjectRevisions.GrandTotal}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";7;;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "TextFormat": { "Ident": "StiCurrencyFormatService", "DecimalDigits": 0, "GroupSeparator": ",", "State": "DecimalDigits" }, "Type": "DataColumn" } }, "DataSourceName": "Projects_ProjectRevisions" } }, "PaperSize": "Tabloid", "Orientation": "Landscape", "PageWidth": 46, "PageHeight": 27.89, "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 1, "Right": 1, "Top": 1, "Bottom": 1 } } } }