{ "ReportVersion": "2023.3.3", "ReportGuid": "c05ffa663597ed55f98e6a9b32cdf488", "ReportName": "Report", "ReportAlias": "Report", "ReportFile": "TIP Sample", "ReportAuthor": "Eric Poon", "ReportCreated": "/Date(1697178375000-0700)/", "ReportChanged": "/Date(1698291703000-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": "FormatB_JSON_Alt.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": "FormatB_JSON_Alt.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": "FormatB_JSON_Alt.FilterCriteria_planCycles" }, "3": { "Ident": "StiDataTableSource", "Name": "PlanCycle", "Alias": "PlanCycle", "Columns": { "0": { "Name": "ActiveYears", "NameInSource": "ActiveYears", "Alias": "ActiveYears", "Type": "System.String" }, "1": { "Name": "EndYear", "NameInSource": "EndYear", "Alias": "EndYear", "Type": "System.Decimal" }, "2": { "Name": "StartYear", "NameInSource": "StartYear", "Alias": "StartYear", "Type": "System.Decimal" } }, "NameInSource": "FormatB_JSON_Alt.PlanCycle" }, "4": { "Ident": "StiDataTableSource", "Name": "PlanCycle_ActiveYears", "Alias": "PlanCycle_ActiveYears", "Columns": { "0": { "Name": "FiscalYear", "NameInSource": "FiscalYear", "Alias": "FiscalYear", "Type": "System.Decimal" }, "1": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "FormatB_JSON_Alt.PlanCycle_ActiveYears" }, "5": { "Ident": "StiDataTableSource", "Name": "Projects", "Alias": "Projects", "Columns": { "0": { "Name": "CurrentProjectRevisions", "NameInSource": "CurrentProjectRevisions", "Alias": "CurrentProjectRevisions", "Type": "System.String" }, "1": { "Name": "PreviousProjectRevision", "NameInSource": "PreviousProjectRevision", "Alias": "PreviousProjectRevision", "Type": "System.String" } }, "NameInSource": "FormatB_JSON_Alt.Projects" }, "6": { "Ident": "StiDataTableSource", "Name": "Projects_CurrentProjectRevisions", "Alias": "Projects_CurrentProjectRevisions", "Columns": { "0": { "Name": "2020", "NameInSource": "2020", "Alias": "2020", "Type": "System.Decimal" }, "1": { "Name": "2021", "NameInSource": "2021", "Alias": "2021", "Type": "System.Decimal" }, "2": { "Name": "2022", "NameInSource": "2022", "Alias": "2022", "Type": "System.Decimal" }, "3": { "Name": "2023", "NameInSource": "2023", "Alias": "2023", "Type": "System.Decimal" }, "4": { "Name": "2024", "NameInSource": "2024", "Alias": "2024", "Type": "System.Decimal" }, "5": { "Name": "Agency", "NameInSource": "Agency", "Alias": "Agency", "Type": "System.String" }, "6": { "Name": "Beyond", "NameInSource": "Beyond", "Alias": "Beyond", "Type": "System.Decimal" }, "7": { "Name": "CDOTRegion", "NameInSource": "CDOTRegion", "Alias": "CDOTRegion", "Type": "System.String" }, "8": { "Name": "CON", "NameInSource": "CON", "Alias": "CON", "Type": "System.Decimal" }, "9": { "Name": "ChangeReason", "NameInSource": "ChangeReason", "Alias": "ChangeReason", "Type": "System.String" }, "10": { "Name": "ChangeReasonDetails", "NameInSource": "ChangeReasonDetails", "Alias": "ChangeReasonDetails", "Type": "System.String" }, "11": { "Name": "ChangedFedAmount", "NameInSource": "ChangedFedAmount", "Alias": "ChangedFedAmount", "Type": "System.String" }, "12": { "Name": "ChangedFedPercent", "NameInSource": "ChangedFedPercent", "Alias": "ChangedFedPercent", "Type": "System.String" }, "13": { "Name": "ChangedTotalAmount", "NameInSource": "ChangedTotalAmount", "Alias": "ChangedTotalAmount", "Type": "System.String" }, "14": { "Name": "ChangedTotalAmouont", "NameInSource": "ChangedTotalAmouont", "Alias": "ChangedTotalAmouont", "Type": "System.String" }, "15": { "Name": "ChangedTotalPercent", "NameInSource": "ChangedTotalPercent", "Alias": "ChangedTotalPercent", "Type": "System.String" }, "16": { "Name": "County", "NameInSource": "County", "Alias": "County", "Type": "System.String" }, "17": { "Name": "Description", "NameInSource": "Description", "Alias": "Description", "Type": "System.String" }, "18": { "Name": "FMISID", "NameInSource": "FMISID", "Alias": "FMISID", "Type": "System.String" }, "19": { "Name": "Federal", "NameInSource": "Federal", "Alias": "Federal", "Type": "System.Decimal" }, "20": { "Name": "FunctionalClassification", "NameInSource": "FunctionalClassification", "Alias": "FunctionalClassification", "Type": "System.String" }, "21": { "Name": "FundTypes", "NameInSource": "FundTypes", "Alias": "FundTypes", "Type": "System.String" }, "22": { "Name": "LRTPID", "NameInSource": "LRTPID", "Alias": "LRTPID", "Type": "System.String" }, "23": { "Name": "Local", "NameInSource": "Local", "Alias": "Local", "Type": "System.Decimal" }, "24": { "Name": "Municipality", "NameInSource": "Municipality", "Alias": "Municipality", "Type": "System.String" }, "25": { "Name": "Narrative", "NameInSource": "Narrative", "Alias": "Narrative", "Type": "System.String" }, "26": { "Name": "OTH", "NameInSource": "OTH", "Alias": "OTH", "Type": "System.Decimal" }, "27": { "Name": "OtherChangeReasonDetails", "NameInSource": "OtherChangeReasonDetails", "Alias": "OtherChangeReasonDetails", "Type": "System.String" }, "28": { "Name": "PE", "NameInSource": "PE", "Alias": "PE", "Type": "System.Decimal" }, "29": { "Name": "PerformanceMeasures", "NameInSource": "PerformanceMeasures", "Alias": "PerformanceMeasures", "Type": "System.String" }, "30": { "Name": "PlanRevision", "NameInSource": "PlanRevision", "Alias": "PlanRevision", "Type": "System.String" }, "31": { "Name": "PrimaryContactEmail", "NameInSource": "PrimaryContactEmail", "Alias": "PrimaryContactEmail", "Type": "System.String" }, "32": { "Name": "PrimaryContactName", "NameInSource": "PrimaryContactName", "Alias": "PrimaryContactName", "Type": "System.String" }, "33": { "Name": "PrimaryContactOrganization", "NameInSource": "PrimaryContactOrganization", "Alias": "PrimaryContactOrganization", "Type": "System.String" }, "34": { "Name": "PrimaryContactPhone", "NameInSource": "PrimaryContactPhone", "Alias": "PrimaryContactPhone", "Type": "System.String" }, "35": { "Name": "Prior", "NameInSource": "Prior", "Alias": "Prior", "Type": "System.Decimal" }, "36": { "Name": "ProjectRevisionFunding", "NameInSource": "ProjectRevisionFunding", "Alias": "ProjectRevisionFunding", "Type": "System.String" }, "37": { "Name": "ProjectRevisionId", "NameInSource": "ProjectRevisionId", "Alias": "ProjectRevisionId", "Type": "System.String" }, "38": { "Name": "ROW", "NameInSource": "ROW", "Alias": "ROW", "Type": "System.Decimal" }, "39": { "Name": "STIPID", "NameInSource": "STIPID", "Alias": "STIPID", "Type": "System.String" }, "40": { "Name": "Score", "NameInSource": "Score", "Alias": "Score", "Type": "System.String" }, "41": { "Name": "State", "NameInSource": "State", "Alias": "State", "Type": "System.Decimal" }, "42": { "Name": "Title", "NameInSource": "Title", "Alias": "Title", "Type": "System.String" }, "43": { "Name": "TotalCost", "NameInSource": "TotalCost", "Alias": "TotalCost", "Type": "System.Decimal" }, "44": { "Name": "Type", "NameInSource": "Type", "Alias": "Type", "Type": "System.String" }, "45": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "FormatB_JSON_Alt.Projects_CurrentProjectRevisions" }, "7": { "Ident": "StiDataTableSource", "Name": "Projects_CurrentProjectRevisions_ProjectRevisionFunding", "Alias": "Projects_CurrentProjectRevisions_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": "FundCategory", "NameInSource": "FundCategory", "Alias": "FundCategory", "Type": "System.String" }, "4": { "Name": "FundType", "NameInSource": "FundType", "Alias": "FundType", "Type": "System.String" }, "5": { "Name": "ImprovementType", "NameInSource": "ImprovementType", "Alias": "ImprovementType", "Type": "System.String" }, "6": { "Name": "LettingDate", "NameInSource": "LettingDate", "Alias": "LettingDate", "Type": "System.String" }, "7": { "Name": "OTH", "NameInSource": "OTH", "Alias": "OTH", "Type": "System.Decimal" }, "8": { "Name": "PE", "NameInSource": "PE", "Alias": "PE", "Type": "System.Decimal" }, "9": { "Name": "PurchaseOrder", "NameInSource": "PurchaseOrder", "Alias": "PurchaseOrder", "Type": "System.String" }, "10": { "Name": "ROW", "NameInSource": "ROW", "Alias": "ROW", "Type": "System.Decimal" }, "11": { "Name": "Section", "NameInSource": "Section", "Alias": "Section", "Type": "System.String" }, "12": { "Name": "Total", "NameInSource": "Total", "Alias": "Total", "Type": "System.Decimal" }, "13": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "FormatB_JSON_Alt.Projects_CurrentProjectRevisions_ProjectRevisionFunding" }, "8": { "Ident": "StiDataTableSource", "Name": "Projects_PreviousProjectRevision", "Alias": "Projects_PreviousProjectRevision", "Columns": { "0": { "Name": "2020", "NameInSource": "2020", "Alias": "2020", "Type": "System.Decimal" }, "1": { "Name": "2021", "NameInSource": "2021", "Alias": "2021", "Type": "System.Decimal" }, "2": { "Name": "2022", "NameInSource": "2022", "Alias": "2022", "Type": "System.Decimal" }, "3": { "Name": "2023", "NameInSource": "2023", "Alias": "2023", "Type": "System.Decimal" }, "4": { "Name": "2024", "NameInSource": "2024", "Alias": "2024", "Type": "System.Decimal" }, "5": { "Name": "Agency", "NameInSource": "Agency", "Alias": "Agency", "Type": "System.String" }, "6": { "Name": "Beyond", "NameInSource": "Beyond", "Alias": "Beyond", "Type": "System.Decimal" }, "7": { "Name": "CDOTRegion", "NameInSource": "CDOTRegion", "Alias": "CDOTRegion", "Type": "System.String" }, "8": { "Name": "CON", "NameInSource": "CON", "Alias": "CON", "Type": "System.Decimal" }, "9": { "Name": "ChangeReason", "NameInSource": "ChangeReason", "Alias": "ChangeReason", "Type": "System.String" }, "10": { "Name": "ChangeReasonDetails", "NameInSource": "ChangeReasonDetails", "Alias": "ChangeReasonDetails", "Type": "System.String" }, "11": { "Name": "ChangedFedAmount", "NameInSource": "ChangedFedAmount", "Alias": "ChangedFedAmount", "Type": "System.String" }, "12": { "Name": "ChangedFedPercent", "NameInSource": "ChangedFedPercent", "Alias": "ChangedFedPercent", "Type": "System.String" }, "13": { "Name": "ChangedTotalAmount", "NameInSource": "ChangedTotalAmount", "Alias": "ChangedTotalAmount", "Type": "System.String" }, "14": { "Name": "ChangedTotalPercent", "NameInSource": "ChangedTotalPercent", "Alias": "ChangedTotalPercent", "Type": "System.String" }, "15": { "Name": "County", "NameInSource": "County", "Alias": "County", "Type": "System.String" }, "16": { "Name": "Description", "NameInSource": "Description", "Alias": "Description", "Type": "System.String" }, "17": { "Name": "FMISID", "NameInSource": "FMISID", "Alias": "FMISID", "Type": "System.String" }, "18": { "Name": "Federal", "NameInSource": "Federal", "Alias": "Federal", "Type": "System.Decimal" }, "19": { "Name": "FunctionalClassification", "NameInSource": "FunctionalClassification", "Alias": "FunctionalClassification", "Type": "System.String" }, "20": { "Name": "FundTypes", "NameInSource": "FundTypes", "Alias": "FundTypes", "Type": "System.String" }, "21": { "Name": "LRTPID", "NameInSource": "LRTPID", "Alias": "LRTPID", "Type": "System.String" }, "22": { "Name": "Local", "NameInSource": "Local", "Alias": "Local", "Type": "System.Decimal" }, "23": { "Name": "Municipality", "NameInSource": "Municipality", "Alias": "Municipality", "Type": "System.String" }, "24": { "Name": "Narrative", "NameInSource": "Narrative", "Alias": "Narrative", "Type": "System.String" }, "25": { "Name": "OTH", "NameInSource": "OTH", "Alias": "OTH", "Type": "System.Decimal" }, "26": { "Name": "OtherChangeReasonDetails", "NameInSource": "OtherChangeReasonDetails", "Alias": "OtherChangeReasonDetails", "Type": "System.String" }, "27": { "Name": "PE", "NameInSource": "PE", "Alias": "PE", "Type": "System.Decimal" }, "28": { "Name": "PerformanceMeasures", "NameInSource": "PerformanceMeasures", "Alias": "PerformanceMeasures", "Type": "System.String" }, "29": { "Name": "PlanRevision", "NameInSource": "PlanRevision", "Alias": "PlanRevision", "Type": "System.String" }, "30": { "Name": "PrimaryContactEmail", "NameInSource": "PrimaryContactEmail", "Alias": "PrimaryContactEmail", "Type": "System.String" }, "31": { "Name": "PrimaryContactName", "NameInSource": "PrimaryContactName", "Alias": "PrimaryContactName", "Type": "System.String" }, "32": { "Name": "PrimaryContactOrganization", "NameInSource": "PrimaryContactOrganization", "Alias": "PrimaryContactOrganization", "Type": "System.String" }, "33": { "Name": "PrimaryContactPhone", "NameInSource": "PrimaryContactPhone", "Alias": "PrimaryContactPhone", "Type": "System.String" }, "34": { "Name": "Prior", "NameInSource": "Prior", "Alias": "Prior", "Type": "System.Decimal" }, "35": { "Name": "ProjectRevisionFunding", "NameInSource": "ProjectRevisionFunding", "Alias": "ProjectRevisionFunding", "Type": "System.String" }, "36": { "Name": "ProjectRevisionId", "NameInSource": "ProjectRevisionId", "Alias": "ProjectRevisionId", "Type": "System.String" }, "37": { "Name": "ROW", "NameInSource": "ROW", "Alias": "ROW", "Type": "System.Decimal" }, "38": { "Name": "STIPID", "NameInSource": "STIPID", "Alias": "STIPID", "Type": "System.String" }, "39": { "Name": "Score", "NameInSource": "Score", "Alias": "Score", "Type": "System.String" }, "40": { "Name": "State", "NameInSource": "State", "Alias": "State", "Type": "System.Decimal" }, "41": { "Name": "Title", "NameInSource": "Title", "Alias": "Title", "Type": "System.String" }, "42": { "Name": "TotalCost", "NameInSource": "TotalCost", "Alias": "TotalCost", "Type": "System.Decimal" }, "43": { "Name": "Type", "NameInSource": "Type", "Alias": "Type", "Type": "System.String" }, "44": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "FormatB_JSON_Alt.Projects_PreviousProjectRevision" }, "9": { "Ident": "StiDataTableSource", "Name": "Projects_PreviousProjectRevision_ProjectRevisionFunding", "Alias": "Projects_PreviousProjectRevision_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": "FundCategory", "NameInSource": "FundCategory", "Alias": "FundCategory", "Type": "System.String" }, "4": { "Name": "FundType", "NameInSource": "FundType", "Alias": "FundType", "Type": "System.String" }, "5": { "Name": "ImprovementType", "NameInSource": "ImprovementType", "Alias": "ImprovementType", "Type": "System.String" }, "6": { "Name": "LettingDate", "NameInSource": "LettingDate", "Alias": "LettingDate", "Type": "System.String" }, "7": { "Name": "OTH", "NameInSource": "OTH", "Alias": "OTH", "Type": "System.Decimal" }, "8": { "Name": "PE", "NameInSource": "PE", "Alias": "PE", "Type": "System.Decimal" }, "9": { "Name": "PurchaseOrder", "NameInSource": "PurchaseOrder", "Alias": "PurchaseOrder", "Type": "System.String" }, "10": { "Name": "ROW", "NameInSource": "ROW", "Alias": "ROW", "Type": "System.Decimal" }, "11": { "Name": "Section", "NameInSource": "Section", "Alias": "Section", "Type": "System.String" }, "12": { "Name": "Total", "NameInSource": "Total", "Alias": "Total", "Type": "System.Decimal" }, "13": { "Name": "relationId", "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "FormatB_JSON_Alt.Projects_PreviousProjectRevision_ProjectRevisionFunding" } }, "Databases": { "0": { "Ident": "StiJsonDatabase", "Name": "FormatB_JSON_Alt", "Alias": "FormatB_JSON_Alt", "PathData": "/Users/ericpoon/Desktop/FormatB_JSON_Alt.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": "PlanCycle", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "ActiveYears" }, "NameInSource": "PlanCycle_ActiveYears", "Alias": "PlanCycle", "ParentSource": "PlanCycle", "ChildSource": "PlanCycle_ActiveYears" }, "3": { "Name": "Projects", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "CurrentProjectRevisions" }, "NameInSource": "Projects_CurrentProjectRevisions", "Alias": "Projects", "ParentSource": "Projects", "ChildSource": "Projects_CurrentProjectRevisions" }, "4": { "Name": "Projects_CurrentProjectRevisions", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "ProjectRevisionFunding" }, "NameInSource": "Projects_CurrentProjectRevisions_ProjectRevisionFunding", "Alias": "Projects_CurrentProjectRevisions", "ParentSource": "Projects_CurrentProjectRevisions", "ChildSource": "Projects_CurrentProjectRevisions_ProjectRevisionFunding" }, "5": { "Name": "Projects", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "PreviousProjectRevision" }, "NameInSource": "Projects_PreviousProjectRevision", "Alias": "Projects", "ParentSource": "Projects", "ChildSource": "Projects_PreviousProjectRevision" }, "6": { "Name": "Projects_PreviousProjectRevision", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "ProjectRevisionFunding" }, "NameInSource": "Projects_PreviousProjectRevision_ProjectRevisionFunding", "Alias": "Projects_PreviousProjectRevision", "ParentSource": "Projects_PreviousProjectRevision", "ChildSource": "Projects_PreviousProjectRevision_ProjectRevisionFunding" } } }, "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,28,1.18", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text1", "Guid": "e3c1fdba78f8c6a3c6a4cc034b61da51", "ClientRectangle": "0,0,4.4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Listing 2" }, "VertAlignment": "Center", "Font": ";10;Bold;", "Border": ";Transparent;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text6", "Guid": "ecbe476162c2d20f615efc020feb4991", "ClientRectangle": "0,0.6,2.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "TIP ID" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text12", "Guid": "baf1fb72b3c15dc518a04e3060f03e54", "ClientRectangle": "2.2,0.6,6.4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "PROJECT NAME" }, "VertAlignment": "Center", "Font": ";;Bold;", "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": "Text60", "Guid": "32f840cba0836c89783bb3a735827c2d", "ClientRectangle": "10.8,0.6,2.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "FED {Sum(PlanCycle.StartYear)+1}" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text61", "Guid": "b72830faaa7330d9e37623ec0ee99fd0", "ClientRectangle": "13,0.6,2.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "FED {Sum(PlanCycle.StartYear)+2}" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text62", "Guid": "cfc5129cce67434ce8c45ea3ab1d8927", "ClientRectangle": "15.2,0.6,2.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "FED {Sum(PlanCycle.StartYear)+3}" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "6": { "Ident": "StiText", "Name": "Text63", "Guid": "55ce6431896f65f5abcf6424e051bf6a", "ClientRectangle": "17.4,0.6,2.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "FED {Sum(PlanCycle.StartYear)+4}" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text2", "Guid": "05bcde1a7aadeb1708b4d3a659f7c5f8", "ClientRectangle": "8.6,0.6,2.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "FED {PlanCycle.StartYear}" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "Expression" } } }, "1": { "Ident": "StiDataBand", "Name": "DataBand2", "Guid": "029c517884b2db3f81fe344eb4cd590a", "ClientRectangle": "0,2.38,28,0.2", "Enabled": false, "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:" }, "2": { "Ident": "StiDataBand", "Name": "DataBand1", "ClientRectangle": "0,3.38,28,0.6", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{(Line %2 == 0)}" }, "TextColor": "0,0,0", "BackColor": "216,216,216", "BorderSides": "None" } }, "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_CurrentProjectRevisions.ProjectRevisionId}" }, "VertAlignment": "Center", "Font": ";7;;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "Type": "DataColumn" }, "1": { "Ident": "StiText", "Name": "Text14", "Guid": "608552f2c0fe4ab3955b069431836e58", "ClientRectangle": "2.2,0.02,6.4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Projects_CurrentProjectRevisions.Title}" }, "VertAlignment": "Center", "Font": ";7;;", "Border": ";0,255,255,255;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "Type": "DataColumn" } }, "DataSourceName": "Projects_CurrentProjectRevisions" }, "3": { "Ident": "StiDataBand", "Name": "DataBand3", "Guid": "d48ed5944f22edbb66837436a8ae362d", "ClientRectangle": "0,4.78,28,0.2", "Enabled": false, "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "DataSourceName": "Projects_CurrentProjectRevisions_ProjectRevisionFunding", "DataRelationName": "Projects_CurrentProjectRevisions_ProjectRevisionFunding", "MasterComponent": "DataBand1" } }, "PaperSize": "Tabloid", "Orientation": "Landscape", "PageWidth": 30, "PageHeight": 27.89, "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 1, "Right": 1, "Top": 1, "Bottom": 1 } } } }