{ "ReportVersion": "2019.3.1.0", "ReportGuid": "fc92ecc02daa4c3080d22054ebce036e", "ReportName": "Affordability", "ReportAlias": "DocAffordabilityReportView", "ReportCreated": "/Date(1485158397000+0200)/", "ReportChanged": "/Date(1627978731518+0200)/", "EngineVersion": "EngineV2", "ReportUnit": "Millimeters", "PreviewSettings": 268435455, "Script": "using System;\r\nusing System.Drawing;\r\nusing System.Windows.Forms;\r\nusing System.Data;\r\nusing Stimulsoft.Controls;\r\nusing Stimulsoft.Base.Drawing;\r\nusing Stimulsoft.Report;\r\nusing Stimulsoft.Report.Dialogs;\r\nusing Stimulsoft.Report.Components;\r\n\r\nnamespace Reports\r\n{\r\n public class Report : Stimulsoft.Report.StiReport\r\n {\r\n public Report() {\r\n this.InitializeComponent();\r\n }\r\n\r\n #region StiReport Designer generated code - do not modify\r\n\t\t#endregion StiReport Designer generated code - do not modify\r\n }\r\n}\r\n", "ReferencedAssemblies": { "0": "System.Dll", "1": "System.Drawing.Dll", "2": "System.Windows.Forms.Dll", "3": "System.Data.Dll", "4": "System.Xml.Dll", "5": "Stimulsoft.Controls.Dll", "6": "Stimulsoft.Base.Dll", "7": "Stimulsoft.Report.Dll" }, "Dictionary": { "Variables": { "0": { "Name": "BorrowerSign1", "Alias": "BorrowerSign1", "Type": "System.Drawing.Image" }, "1": { "Value": "Prepared By", "Name": "PreparedBy", "Alias": "PreparedBy", "Type": "System.String" }, "2": { "Name": "SubscriberLogo", "Alias": "SubscriberLogo", "Type": "System.Drawing.Image" }, "3": { "Value": "Version: 123", "Name": "Version", "Alias": "Version", "Type": "System.String" }, "4": { "Name": "SignedAt1", "Alias": "SignedAt1", "Type": "System.Drawing.Image" } }, "DataSources": { "0": { "Ident": "StiBusinessObjectSource", "Name": "FilterData", "Alias": "FilterData", "Key": "d1440a3de38248da908ee4341c940e81", "Columns": { "0": { "Name": "Description", "Index": -1, "NameInSource": "Description", "Alias": "Description", "Type": "System.String" }, "1": { "Name": "Filter", "Index": -1, "NameInSource": "Filter", "Alias": "Filter", "Type": "System.String" } }, "NameInSource": "FilterData" }, "1": { "Ident": "StiBusinessObjectSource", "Name": "IncomeExpense", "Alias": "IncomeExpense", "Key": "cb7b7f03533742dc94d2ab9500acb982", "Columns": { "0": { "Name": "AffordabilityDate", "Index": -1, "NameInSource": "AffordabilityDate", "Alias": "AffordabilityDate", "Type": "System.DateTime" }, "1": { "Name": "Amount", "Index": -1, "NameInSource": "Amount", "Alias": "Amount", "Type": "System.Decimal" }, "2": { "Name": "BorrowerFamilyName", "Index": -1, "NameInSource": "BorrowerFamilyName", "Alias": "BorrowerFamilyName", "Type": "System.String" }, "3": { "Name": "BorrowerIdPassport", "Index": -1, "NameInSource": "BorrowerIdPassport", "Alias": "BorrowerIdPassport", "Type": "System.String" }, "4": { "Name": "BorrowerName", "Index": -1, "NameInSource": "BorrowerName", "Alias": "BorrowerName", "Type": "System.String" }, "5": { "Name": "CalcAmount", "Index": -1, "NameInSource": "CalcAmount", "Alias": "CalcAmount", "Type": "System.Decimal", "Ident": "Calc", "Expression": "(IncomeExpense.Section == \"Income\") ? IncomeExpense.Amount : (IncomeExpense.Amount * -1m)" }, "6": { "Name": "Description", "Index": -1, "NameInSource": "Description", "Alias": "Description", "Type": "System.String" }, "7": { "Name": "GrandExpense", "Index": -1, "NameInSource": "GrandExpense", "Alias": "GrandExpense", "Type": "System.Decimal", "Ident": "Calc", "Expression": "(IncomeExpense.NeccessaryExpenses + IncomeExpense.NonNeccessaryExpenses)" }, "8": { "Name": "Group", "Index": -1, "NameInSource": "Group", "Alias": "Group", "Type": "System.String" }, "9": { "Name": "IncMinusExp", "Index": -1, "NameInSource": "IncMinusExp", "Alias": "IncMinusExp", "Type": "System.Decimal" }, "10": { "Name": "Income-Expense", "Index": -1, "NameInSource": "Income-Expense", "Alias": "Income-Expense", "Type": "System.Decimal", "Ident": "Calc", "Expression": "(IncomeExpense.TotalIncome) - (IncomeExpense.GrandExpense)" }, "11": { "Name": "MinRegMinusIncome", "Index": -1, "NameInSource": "MinRegMinusIncome", "Alias": "MinRegMinusIncome", "Type": "System.Decimal", "Ident": "Calc", "Expression": "(IncomeExpense.TotalIncome - IncomeExpense.MinRegulatory_NonNecc)" }, "12": { "Name": "MinRegulatory+NonNecc", "Index": -1, "NameInSource": "MinRegulatory+NonNecc", "Alias": "MinRegulatory+NonNecc", "Type": "System.Decimal", "Ident": "Calc", "Expression": "(IncomeExpense.MinRegulatoryAmount + IncomeExpense.NonNeccessaryExpenses) " }, "13": { "Name": "MinRegulatoryAmount", "Index": -1, "NameInSource": "MinRegulatoryAmount", "Alias": "MinRegulatoryAmount", "Type": "System.Decimal" }, "14": { "Name": "NeccessaryExpenses", "Index": -1, "NameInSource": "NeccessaryExpenses", "Alias": "NeccessaryExpenses", "Type": "System.Decimal" }, "15": { "Name": "Necessary", "Index": -1, "NameInSource": "Necessary", "Alias": "Necessary", "Type": "System.Nullable`1[System.Boolean]" }, "16": { "Name": "NonNeccessaryExpenses", "Index": -1, "NameInSource": "NonNeccessaryExpenses", "Alias": "NonNeccessaryExpenses", "Type": "System.Decimal" }, "17": { "Name": "Number", "Index": -1, "NameInSource": "Number", "Alias": "Number", "Type": "System.String" }, "18": { "Name": "OverrideReason", "Index": -1, "NameInSource": "OverrideReason", "Alias": "OverrideReason", "Type": "System.String" }, "19": { "Name": "OverrideReasonId", "Index": -1, "NameInSource": "OverrideReasonId", "Alias": "OverrideReasonId", "Type": "System.Int32" }, "20": { "Name": "ProviderCity", "Index": -1, "NameInSource": "ProviderCity", "Alias": "ProviderCity", "Type": "System.String" }, "21": { "Name": "Section", "Index": -1, "NameInSource": "Section", "Alias": "Section", "Type": "System.String" }, "22": { "Name": "SplitPercentage", "Index": -1, "NameInSource": "SplitPercentage", "Alias": "SplitPercentage", "Type": "System.Decimal" }, "23": { "Name": "TotalExpenses", "Index": -1, "NameInSource": "TotalExpenses", "Alias": "TotalExpenses", "Type": "System.Decimal" }, "24": { "Name": "TotalIncome", "Index": -1, "NameInSource": "TotalIncome", "Alias": "TotalIncome", "Type": "System.Decimal" } }, "NameInSource": "IncomeExpense" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Page1", "Guid": "adbc95caf22b48519e951fd93d85ff9c", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiPageHeaderBand", "Name": "PageHeader", "ClientRectangle": "0,4,190.1,18", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text1", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,10,104,8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{ReportName}" }, "VertAlignment": "Center", "Font": "Calibri;20;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "ShrinkFontToFit": true, "ShrinkFontToFitMinimumSize": 7.0, "Type": "Expression" }, "1": { "Ident": "StiImage", "Name": "SubscriberImage", "PrintOn": "OnlyFirstPage", "CanShrink": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "104,0,85,18", "Interaction": { "Ident": "StiInteraction" }, "HorAlignment": "Right", "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:0,255,255,255", "Stretch": true, "AspectRatio": true, "ImageData": { "Value": "{SubscriberLogo}" } } } }, "1": { "Ident": "StiPageFooterBand", "Name": "PageFooter", "ClientRectangle": "0,272.9,190.1,4", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text2", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0,40,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{PageNofM}" }, "VertAlignment": "Center", "Font": "Calibri;7;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black" }, "1": { "Ident": "StiText", "Name": "Text3", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "150,0,40,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Version}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;7;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black" }, "2": { "Ident": "StiText", "Name": "Text4", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "40,0,110,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Prepare By: {PreparedBy} on {DateTime.Now}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;7;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" } } }, "2": { "Ident": "StiHeaderBand", "Name": "HeaderBand1", "ClientRectangle": "0,30,190.1,16", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text6", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "44,4,144,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IncomeExpense.BorrowerName} {IncomeExpense.BorrowerFamilyName}" }, "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text7", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0,44,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Application / Borrower Number:" }, "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text8", "Guid": "339c67b1650f467082309d92755fbf39", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,4,44,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Borrower Name:" }, "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text9", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "44,0,144,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IncomeExpense.Number}" }, "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black" }, "4": { "Ident": "StiText", "Name": "Text29", "Guid": "225d9425c0ff4cf4a50ec17e1f7e06c4", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,12,44,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Override Reason:" }, "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text28", "Guid": "5405554485774330a9e99f7e67e932b6", "CanGrow": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "44,12,144,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IncomeExpense.OverrideReason}" }, "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "DataColumn" }, "6": { "Ident": "StiText", "Name": "Text31", "Guid": "b374ff58d85143ceabbaf4762e72d0a1", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,8,44,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "ID / Passport: " }, "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text32", "Guid": "7170746551a44abeb964aa030295a4e3", "CanGrow": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "44,8,144,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IncomeExpense.BorrowerIdPassport}" }, "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "DataColumn" }, "8": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive1", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,16,188,0.254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" } } }, "3": { "Ident": "StiGroupHeaderBand", "Name": "GroupHeaderBand1", "ClientRectangle": "0,54,190.1,4", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text10", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0,188,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IncomeExpense.Section}" }, "Font": "Calibri;10;Bold, Italic;", "Border": "All;;;;;;;solid:Black", "Brush": "solid:242,242,242", "TextBrush": "solid:Black" } }, "Condition": { "Value": "{IncomeExpense.Section}" } }, "4": { "Ident": "StiGroupHeaderBand", "Name": "GroupHeaderBand2", "ClientRectangle": "0,66,190.1,0", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:" }, "5": { "Ident": "StiDataBand", "Name": "DataIncomeExpense", "ClientRectangle": "0,74,190.1,4", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "DataIncomeExpense_Description", "CanGrow": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0,74,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IncomeExpense.Description}" }, "VertAlignment": "Center", "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } }, "1": { "Ident": "StiText", "Name": "DataIncomeExpense_Amount", "CanGrow": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "152,0,36,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IncomeExpense.Amount.ToString(\"N2\", System.Globalization.CultureInfo.DefaultThreadCurrentCulture)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" } }, "PrintIfDetailEmpty": true, "DataSourceName": "IncomeExpense", "Filters": { "0": { "Ident": "StiFilter", "Condition": "NotEqualTo", "DataType": "Numeric", "Column": "Amount", "Value1": "0" } } }, "6": { "Ident": "StiGroupFooterBand", "Name": "GroupFooterBand2", "ClientRectangle": "0,86,190.1,6", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text12", "Guid": "28b12bb7e9f64b5c938031f30443877f", "CanGrow": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "152,0,36,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(GroupHeaderBand2,IncomeExpense.Amount).ToString(\"N2\", System.Globalization.CultureInfo.DefaultThreadCurrentCulture)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text5", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "86,0,66,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Total:" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text20", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "50,0,0,6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IncomeExpense.MinRegulatoryAmount == 0 ? 0 : IncomeExpense.MinRegulatory_NonNecc}" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "3": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive8", "Guid": "75742ece67544b98ae245e792f7c9de4", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "152,4,36,0.254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" } } }, "7": { "Ident": "StiFooterBand", "Name": "FooterBand1", "ClientRectangle": "0,100,190.1,86", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text13", "Guid": "c693439b3e35435d919bf943e8c599a7", "CanGrow": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "152,10,36,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Switch(IncomeExpense.OverrideReasonId > 0, IncomeExpense.Income_Expense, IncomeExpense.MinRegulatoryAmount > IncomeExpense.NeccessaryExpenses, IncomeExpense.MinRegMinusIncome, IncomeExpense.MinRegulatoryAmount < IncomeExpense.NeccessaryExpenses, IncomeExpense.Income_Expense)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": " ", "UseLocalSetting": false }, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text14", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "122,10,30,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Nett Income:" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text15", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,12,56,6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Declaration by Borrower:" }, "Font": "Calibri;10;Bold, Underline;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text16", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6,22,138,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "I confirm that these income and expenditure details of my spouse and I are true, accurate and complete." }, "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text17", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "6,42,32,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Signature of Borrower:" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text18", "Guid": "f9c5ec8c3d0943788aedfbe7b47c6507", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "8,56,30,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Date:" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "6": { "Ident": "StiText", "Name": "Text19", "Guid": "743dc757b49c455c85c521a3128bf065", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "8,76,30,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Signed At:" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "7": { "Ident": "StiRichText", "Name": "RichText1", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "64,4,124,6", "Conditions": { "0": { "Ident": "StiCondition", "DataType": "Numeric", "Column": "IncomeExpense.MinRegulatoryAmount", "Value1": "0", "Enabled": false, "TextColor": "0,0,0", "BackColor": "0,255,255,255", "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "__LP___x005C_rtf1_x005C_ansi_x005C_ansicpg1252_x005C_deff0_x005C_deflang7177__LP___x005C_fonttbl__LP___x005C_f0_x005C_fnil_x005C_fcharset0_x0020_Calibri_x003B___RP____LP___x005C_f1_x005C_fnil_x005C_fcharset0_x0020_Microsoft_x0020_Sans_x0020_Serif_x003B___RP____RP___x000D__x000A__x005C_viewkind4_x005C_uc1_x005C_pard_x005C_b_x005C_f0_x005C_fs17_x0020_Minimum_x0020_Regulatory_x0020__x0020__x0028__x0020__x007B_IncomeExpense.MinRegulatoryAmount.ToString_x0028__x0022_N2_x0022__x002C__x0020_System.Globalization.CultureInfo.DefaultThreadCurrentCulture_x0029__x007D__x0020__x0020__x0020__x002B__x0020__x0020__x007B_IncomeExpense.NonNeccessaryExpenses.ToString_x0028__x0022_N2_x0022__x002C__x0020_System.Globalization.CultureInfo.DefaultThreadCurrentCulture_x0029__x007D__x0020__x0029__x0020__x0020_Amount_x005C_b0_x005C_f1_x005C_par_x000D__x000A___RP___x000D__x000A_" }, "Border": ";;;;;;;solid:Black", "BackColor": "Transparent" }, "8": { "Ident": "StiText", "Name": "Text21", "Guid": "e184135e1dc7445999f2366a53a67a5f", "CanGrow": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "152,0,36,4", "Conditions": { "0": { "Ident": "StiMultiCondition", "TextColor": "Black", "Font": ";8.25;;", "BorderSides": "None", "Filters": { "0": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{IncomeExpense.MinRegulatoryAmount > IncomeExpense.GrandExpense}" } }, "1": { "Ident": "StiFilter", "Condition": "IsNull", "Column": "IncomeExpense.OverrideReason" } } } }, "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IncomeExpense.GrandExpense.ToString(\"N2\", System.Globalization.CultureInfo.DefaultThreadCurrentCulture)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "9": { "Ident": "StiText", "Name": "Text23", "Guid": "8f6777f4bbdd4d2c91f91071532ffe07", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "86,0,66,4", "Conditions": { "0": { "Ident": "StiMultiCondition", "TextColor": "Black", "Font": "Calibri;8.25;;", "BorderSides": "None", "Filters": { "0": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{IncomeExpense.MinRegulatoryAmount > IncomeExpense.GrandExpense}" } }, "1": { "Ident": "StiFilter", "Condition": "IsNull", "Column": "IncomeExpense.OverrideReason" } } } }, "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Total Expenses:" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "10": { "Ident": "StiText", "Name": "Text11", "Guid": "ffe8d9e60ac74273ab49ac7e9cdd9782", "CanGrow": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "122,6,66,4", "Conditions": { "0": { "Ident": "StiCondition", "Condition": "IsNotNull", "Column": "IncomeExpense.OverrideReason", "TextColor": "0,0,0", "BackColor": "0,255,255,255", "Font": "Calibri;;;", "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "HideZeros": true, "Text": { "Value": "{Switch(IncomeExpense.MinRegulatoryAmount > IncomeExpense.GrandExpense,decimal.Round(IncomeExpense.MinRegulatory_NonNecc, 2),0)}\r\n\r\n\r\n\r\n" }, "HorAlignment": "Right", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "GroupSeparator": " ", "UseLocalSetting": false }, "Type": "Expression" }, "11": { "Ident": "StiImage", "Name": "Image1", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "40,30,62,16", "Interaction": { "Ident": "StiInteraction" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Stretch": true, "AspectRatio": true, "ImageData": { "Value": "{BorrowerSign1}" } }, "12": { "Ident": "StiText", "Name": "Text27", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "40,56,72,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IncomeExpense.AffordabilityDate.ToShortDateString()}" }, "VertAlignment": "Bottom", "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "13": { "Ident": "StiImage", "Name": "Image2", "Guid": "2ebd1ed378e24425beb5f9267e133aa8", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "40,64,62,16", "Interaction": { "Ident": "StiInteraction" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Stretch": true, "AspectRatio": true, "ImageData": { "Value": "{SignedAt1}" } }, "14": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive3", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,10,188,0.254", "Interaction": { "Ident": "StiInteraction" }, "Style": "Double", "StartCap": ";;;", "EndCap": ";;;" }, "15": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive4", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "40,46,72,0.254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "16": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive5", "Guid": "f55e87ba8d2d435182b069cc576744b6", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "40,60,72,0.254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "17": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive7", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "152,14,36,0.254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "18": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive2", "Guid": "c2c9f423523f476788ce8edd7ea74d1c", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "152,4,36,0.254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "19": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive6", "Guid": "666f21003a304049853035330104e748", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "40,80,72,0.254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" } } } }, "PaperSize": "A4", "PageWidth": 210.1, "PageHeight": 296.9, "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 10.0, "Right": 10.0, "Top": 10.0, "Bottom": 10.0 } } } }