IOrderedQueryable (1 item)••• { "ReportVersion": "2021.1.2.0", "ReportGuid": "11853ebf351d4031baab8cde5a127ca3", "ReportName": "M1_LOAN_Monthly_Statement", "ReportAlias": "M1_LOAN_Monthly_Statement", "ReportCreated": "/Date(1550105912660+0000)/", "ReportChanged": "/Date(1550105912660+0000)/", "EngineVersion": "EngineV2", "CalculationMode": "Interpretation", "ReportUnit": "Inches", "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 LenderStatement : Stimulsoft.Report.StiReport\r\n {\r\n public LenderStatement() {\r\n this.InitializeComponent();\r\n }\r\n\r\n #region StiReport Designer generated code - do not modify\r\n #endregion StiReport Designer generated code - do not modify\r\n }\r\n}\r\n", "Styles": { "0": { "Ident": "StiStyle", "Name": "Style1", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:231,230,230", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:255,0,0" }, "1": { "Ident": "StiStyle", "Name": "Style2", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:251,229,213", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:255,0,0" }, "2": { "Ident": "StiStyle", "Name": "Style3", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:222,235,246", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:255,0,0" }, "3": { "Ident": "StiStyle", "Name": "Style4", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:248,248,255", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:255,0,0" }, "4": { "Ident": "StiStyle", "Name": "Style5", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:244,177,131", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:255,0,0" }, "5": { "Ident": "StiStyle", "Name": "Style6", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:156,195,229", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:255,0,0" }, "6": { "Ident": "StiStyle", "Name": "Style7", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:255,242,204", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:255,0,0" }, "7": { "Ident": "StiStyle", "Name": "Style8", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:242,242,242", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:255,0,0" }, "8": { "Ident": "StiStyle", "Name": "Style9", "Font": ";11;Bold;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:212,175,55", "TextBrush": "solid:0,0,0", "NegativeTextBrush": "solid:255,0,0" } }, "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": { "Value": "((Sum(DataPool_Transactions,Pool_Transactions.Amount))*-1)", "Name": "InterestEarned", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "InterestEarned", "Type": "System.Double", "ReadOnly": true, "InitBy": "Expression" }, "1": { "Value": "(DepositsAll+WithdrawlsAll)", "Name": "PrincipalAsOfDate", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "PrincipalAsOfDate", "Type": "System.Double", "ReadOnly": true, "InitBy": "Expression" }, "2": { "Value": "Sum(DataBand4,Pool_Transactions.Amount)", "Name": "DepositsAll", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "DepositsAll", "Type": "System.Double", "ReadOnly": true, "InitBy": "Expression" }, "3": { "Value": "Sum(DataBand5,Pool_Transactions.Amount)", "Name": "WithdrawlsAll", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "WithdrawlsAll", "Type": "System.Double", "ReadOnly": true, "InitBy": "Expression" }, "4": { "Value": "DateTime,_x0032__x002F_1_x002F_2021_x0020_11:22:43_x0020_AM,_x0032__x002F_28_x002F_2021_x0020_11:22:43_x0020_AM", "Name": "RangeDates", "Alias": "RangeDates", "Type": "Stimulsoft.Report.DateTimeRange", "RequestFromUser": true, "Description": "Filters Pool and Particpants by the RangeDates" }, "5": { "Name": "LenderSelect", "DialogInfo": { "DateTimeType": "DateAndTime", "ItemsInitializationType": "Columns", "KeysColumn": "Pool_Participants_Live.LenderId", "ValuesColumn": "Pool_Participants_Live.ParticipantName", "Keys": { "0": "98", "1": "28", "2": "17", "3": "108", "4": "29", "5": "30", "6": "109", "7": "111", "8": "15", "9": "22", "10": "47", "11": "92", "12": "34", "13": "33", "14": "106", "15": "114", "16": "115", "17": "46", "18": "125", "19": "126", "20": "127", "21": "132" }, "Values": { "0": "Marketplace One, LLC ", "1": "P&L Allen Family Trust | Paul/Linda Allen ", "2": "BBIZ, LLC | Michael Bennett ", "3": "Grob Family Living Trust, dated March 6, 2000, amended June 17, 2015 | Ernest and Dorothy Grob ", "4": "DKAJ Enterprises, LLLP | Mark Allen ", "5": "Mark R. Allen PC Profit Sharing Plan | Mark Allen ", "6": "Mark R. Allen PC Profit Sharing Plan | Dianne Allen ", "7": "Thomas John & Emily Anne Call ", "8": "Steve & Ann Wheeler Trust | Steve/Ann Wheeler ", "9": "Alan G. Fanello Trust under will of the 1997 Louis D. Fanello Family Trust | Alan G. Fanello ", "10": "MARGRET LLC | Mark Poulsen ", "11": "Vahalda LLC | Jake Spellmeyer ", "12": "Candice J. Ohlsen Trust | Candice Ohlsen ", "13": "David A. Ohlsen Trust | David Ohlsen ", "14": "Jonathan & Jennifer Massey ", "15": "The Nicholson Family Trust | Charles Nicholson ", "16": "Karl Mugge ", "17": "Mark & Gretchen Poulsen Revocable Trust | Mark/Gretchen Poulsen ", "18": "The Kelly and Sandra House Family Trust | Norman Kelly House ", "19": "SLM Family Trust dated January 10, 1996 | Steven & Linda Massey ", "20": "Eric and Sarah House ", "21": "RM CAPITAL, LLC " } }, "Alias": "LenderSelect", "Type": "System.Int32", "RequestFromUser": true }, "6": { "Value": "RangeDates.From.Date.AddMonths(+1)", "Name": "StmtMonthBeg", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "Statement Month Beginning + 1 Month", "Type": "System.Int32", "ReadOnly": true, "Description": "Yield Month Start Date Plus 1 Month", "InitBy": "Expression" }, "7": { "Value": "RangeDates.To.AddDays(+30)", "Name": "StmtMonthIssue", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "Statement Month End Date + 30 Days", "Type": "System.Int32", "ReadOnly": true, "Description": "Allows for filter to process an appropriate End Date", "InitBy": "Expression" }, "8": { "Value": "-1", "Name": "PlusXDays", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "PlusXDays", "Type": "System.Int32", "ReadOnly": true }, "9": { "Value": "1", "Name": "PlusYDays", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "PlusYDays", "Type": "System.Int32" }, "10": { "Value": "IIF((Pool_Assets.SoldOn.Date=Pool_Transactions.EffectiveOn.Date}" } }, "1": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{Pool_Transactions.CreditOrDebit.ToString()==\"Debit\"&&Pool_Transactions.PoolDebitType.ToString()==\"ParticipationReinvestment\"}" } }, "2": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{Pool_Transactions.LenderId==LenderSelect}" } } } }, "5": { "Ident": "StiFooterBand", "Name": "FooterReinvestments", "ClientRectangle": "0,6.4,7.72,0.3", "ComponentPlacement": "f.Page1", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text20", "Guid": "5e27ffc965234acc8ec54fc0978f94c6", "ClientRectangle": "4.8,0,1.7,0.2", "ComponentPlacement": "f.FooterReinvestments", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Total Interest Earned:" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text22", "Guid": "e38728af49db483a89e624f5906a210a", "ClientRectangle": "6.6,0,0.9,0.2", "ComponentPlacement": "f.FooterReinvestments", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{((Sum(DataTransactions_Reinvestments,Pool_Transactions.Amount))*-1).ToString(\"C\")}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" } } }, "6": { "Ident": "StiHeaderBand", "Name": "HeaderPool_Transactions", "ClientRectangle": "0,7.1,7.72,0.4", "ComponentPlacement": "h.ap.Page1", "ComponentStyle": "Style8", "Interaction": { "Ident": "StiInteraction" }, "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:242,242,242", "Components": { "0": { "Ident": "StiText", "Name": "HeaderPool_Transactions_TypeDescription", "Guid": "98cc8d6bc7784de1b7c4f3850a70c926", "ClientRectangle": "0.6,0.2,1.8,0.2", "ComponentPlacement": "h.ap.HeaderPool_Transactions", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Description" }, "CanBreak": true, "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "HeaderPool_Transactions_EffectiveOn", "Guid": "e533f4fe0ee241cdb302098a4cdbd0c0", "ClientRectangle": "4.8,0.2,1,0.2", "ComponentPlacement": "h.ap.HeaderPool_Transactions", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Effective On" }, "CanBreak": true, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "HeaderPool_Transactions_TransactionOn", "Guid": "645d25f2ec584acdb370e8e849970675", "ClientRectangle": "2.8,0.2,1,0.2", "ComponentPlacement": "h.ap.HeaderPool_Transactions", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Earned On" }, "CanBreak": true, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "HeaderPool_Transactions_Amount", "Guid": "b6c198fc87f14c6e89b3472d4fb47bbf", "ClientRectangle": "6.6,0.2,0.9,0.2", "ComponentPlacement": "h.ap.HeaderPool_Transactions", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Amount" }, "CanBreak": true, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text58", "Guid": "b3ab6e76b5994cbbb48b3c83cc8a0874", "ClientRectangle": "0,0,2,0.2", "ComponentPlacement": "h.ap.HeaderPool_Transactions", "ComponentStyle": "Style9", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": " Investor Activity - Interest" }, "VertAlignment": "Center", "Font": ";11;Bold;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:212,175,55", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text89", "Guid": "b9668ea685ee41a79ee2ea6c2918658e", "ClientRectangle": "2,0,2,0.2", "ComponentPlacement": "h.ap.HeaderPool_Transactions", "ComponentStyle": "Style9", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "(Yield Through {RangeDates.ToDate.ToString(\"MM/dd/yyyy\")})" }, "VertAlignment": "Center", "Font": ";11;Bold;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:212,175,55", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "6": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive9", "ClientRectangle": "0,0,7.7,0.01", "ComponentPlacement": "h.ap.HeaderPool_Transactions", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" } }, "CanBreak": true }, "7": { "Ident": "StiDataBand", "Name": "DataPool_Transactions", "ClientRectangle": "0,7.9,7.72,0.2", "ComponentPlacement": "d.Page1", "Interaction": { "Ident": "StiBandInteraction" }, "CanBreak": true, "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "DataPool_Transactions_TypeDescription", "Guid": "3c78ee37bd4648c8a36883c81f224e63", "CanGrow": true, "ClientRectangle": "0.6,0,1.8,0.2", "ComponentPlacement": "d.DataPool_Transactions", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Pool_Transactions.TypeDescription}" }, "CanBreak": true, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "DataPool_Transactions_EffectiveOn", "Guid": "d53f0df756f44c858b803332cbcd2e95", "CanGrow": true, "ClientRectangle": "2.8,0,1,0.2", "ComponentPlacement": "d.DataPool_Transactions", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Pool_Transactions.EffectiveOn}" }, "CanBreak": true, "HorAlignment": "Center", "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "TextFormat": { "Ident": "StiDateFormatService" }, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "DataPool_Transactions_TransactionOn", "Guid": "af99b82e69b748438e83fb90d29c8baa", "CanGrow": true, "ClientRectangle": "4.8,0,1,0.2", "ComponentPlacement": "d.DataPool_Transactions", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Pool_Transactions.EffectiveOn}" }, "CanBreak": true, "HorAlignment": "Center", "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "TextFormat": { "Ident": "StiDateFormatService" }, "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "DataPool_Transactions_Amount", "Guid": "d95706619eea4a4f9c9a67507552b8eb", "CanGrow": true, "ClientRectangle": "6.6,0,0.9,0.2", "ComponentPlacement": "d.DataPool_Transactions", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{(Pool_Transactions.Amount*-1)}" }, "CanBreak": true, "HorAlignment": "Right", "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 0, "GroupSeparator": ",", "State": "DecimalDigits", "PositivePattern": 0 }, "Type": "Expression" } }, "DataSourceName": "Pool_Transactions", "EvenStyle": "Style8", "OddStyle": "Style1", "MasterComponent": "DataBand3", "Sort": { "0": "ASC", "1": "TransactionOn" }, "Filters": { "0": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{StmtMonthBeg<=Pool_Transactions.EffectiveOn.Date&&StmtMonthIssue >=Pool_Transactions.EffectiveOn.Date}" } }, "1": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{Pool_Transactions.CreditOrDebit.ToString()==\"Debit\"&&Pool_Transactions.PoolDebitType.ToString()==\"Disbursement\"}" } }, "2": { "Ident": "StiFilter", "Column": "LenderId", "Item": "Expression", "Expression": { "Value": "{Pool_Transactions.LenderId==LenderSelect}" } } } }, "8": { "Ident": "StiFooterBand", "Name": "FooterBand1", "ClientRectangle": "0,8.5,7.72,0.3", "ComponentPlacement": "f.Page1", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text43", "Guid": "14b658cea6fb4eab99a2a77a576778f5", "ClientRectangle": "6.6,0,0.9,0.2", "ComponentPlacement": "f.FooterBand1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{((Sum(DataPool_Transactions,Pool_Transactions.Amount))*-1)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold, Underline;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 0, "GroupSeparator": ",", "PositivePattern": 0 }, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text108", "Guid": "b6c82b6ee93b4ae7a3ca12825852d50d", "ClientRectangle": "5.3,0,1.2,0.2", "ComponentPlacement": "f.FooterBand1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Total Interest Earned: " }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" } } }, "9": { "Ident": "StiHeaderBand", "Name": "HeaderBand1", "Guid": "991907c9ab544b82bcf9d7f773eb0c4d", "ClientRectangle": "0,9.2,7.72,0.4", "ComponentPlacement": "h.ap.Page1", "ComponentStyle": "Style8", "Interaction": { "Ident": "StiInteraction" }, "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:242,242,242", "Components": { "0": { "Ident": "StiText", "Name": "Text6", "Guid": "d987081e12ff433593088109f7b08812", "ClientRectangle": "0.6,0.2,1.8,0.2", "ComponentPlacement": "h.ap.HeaderBand1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Description" }, "CanBreak": true, "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text7", "Guid": "060764eec4184c7d86edcefa68ecd96f", "ClientRectangle": "2.8,0.2,1,0.2", "ComponentPlacement": "h.ap.HeaderBand1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Effective On" }, "CanBreak": true, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text8", "Guid": "357c207aa567408d8b4d92d54faf5b3f", "ClientRectangle": "4.8,0.2,1,0.2", "ComponentPlacement": "h.ap.HeaderBand1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Transaction On" }, "CanBreak": true, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text9", "Guid": "f71c9f4cefd049daa39b7f42d96823f8", "ClientRectangle": "6.6,0.2,0.9,0.2", "ComponentPlacement": "h.ap.HeaderBand1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Amount" }, "CanBreak": true, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } }, "4": { "Ident": "StiText", "Name": "Text81", "Guid": "d31e09a58e6c4b009738c8ebe8e1bc9f", "ClientRectangle": "0,0,4,0.2", "ComponentPlacement": "h.ap.HeaderBand1", "ComponentStyle": "Style9", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": " Investor Activity - Deposits" }, "Font": ";11;Bold;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:212,175,55", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "5": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive10", "ClientRectangle": "0,0,7.7,0.01", "ComponentPlacement": "h.ap.HeaderBand1", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" } }, "CanBreak": true }, "10": { "Ident": "StiDataBand", "Name": "DataBand1", "Guid": "084419d325584f6cb80f2c8f6d775946", "ClientRectangle": "0,10,7.72,0.2", "ComponentPlacement": "d.Page1", "Interaction": { "Ident": "StiBandInteraction" }, "CanBreak": true, "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text15", "Guid": "d630805104ee474783cd874d1a874a8b", "CanGrow": true, "ClientRectangle": "0.6,0,1.8,0.2", "ComponentPlacement": "d.DataBand1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Pool_Transactions.TypeDescription}" }, "CanBreak": true, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } }, "1": { "Ident": "StiText", "Name": "Text16", "Guid": "d8b318f66e474224944faf0cdcb63b8b", "CanGrow": true, "ClientRectangle": "2.8,0,1,0.2", "ComponentPlacement": "d.DataBand1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Pool_Transactions.EffectiveOn}" }, "CanBreak": true, "HorAlignment": "Center", "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "TextFormat": { "Ident": "StiDateFormatService" }, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text17", "Guid": "7293d1857e484a22897c52b889991d1e", "CanGrow": true, "ClientRectangle": "4.8,0,1,0.2", "ComponentPlacement": "d.DataBand1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Pool_Transactions.TransactionOn}" }, "CanBreak": true, "HorAlignment": "Center", "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "TextFormat": { "Ident": "StiDateFormatService" }, "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text18", "Guid": "65e67a73bc3e4418a314016cf30806dc", "CanGrow": true, "ClientRectangle": "6.6,0,0.9,0.2", "ComponentPlacement": "d.DataBand1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Pool_Transactions.Amount}" }, "CanBreak": true, "HorAlignment": "Right", "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 0, "GroupSeparator": ",", "State": "DecimalDigits", "PositivePattern": 0 }, "Type": "Expression" } }, "DataSourceName": "Pool_Transactions", "DataRelationName": "PoolTransactions2ParticipantsLive", "EvenStyle": "Style8", "OddStyle": "Style1", "MasterComponent": "DataBand3", "Sort": { "0": "ASC", "1": "TransactionOn" }, "Filters": { "0": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{RangeDates.FromDate<=Pool_Transactions.TransactionOn&&RangeDates.ToDate>=Pool_Transactions.TransactionOn}" } }, "1": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{Pool_Transactions.CreditOrDebit.ToString()==\"Credit\"&&Pool_Transactions.CreditType.ToString()==\"Participation\"}" } }, "2": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{Pool_Transactions.LenderId==LenderSelect}" } } } }, "11": { "Ident": "StiFooterBand", "Name": "FooterBand2", "ClientRectangle": "0,10.6,7.72,0.3", "ComponentPlacement": "f.Page1", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text107", "Guid": "8468c0c27a2c4d2bbcd135a2cda5f979", "ClientRectangle": "6.6,0,0.9,0.2", "ComponentPlacement": "f.FooterBand2", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1, Pool_Transactions.Amount)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold, Underline;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 0, "GroupSeparator": ",", "PositivePattern": 0 }, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text109", "Guid": "70dff12056824e899f2833b87df6632f", "ClientRectangle": "5,0,1.5,0.2", "ComponentPlacement": "f.FooterBand2", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Total Amount for Deposits: " }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" } } }, "12": { "Ident": "StiHeaderBand", "Name": "HeaderBand2", "Guid": "54757412102f467587f151710fbe6b34", "ClientRectangle": "0,11.3,7.72,0.4", "ComponentPlacement": "h.ap.Page1", "ComponentStyle": "Style8", "Interaction": { "Ident": "StiInteraction" }, "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:242,242,242", "Components": { "0": { "Ident": "StiText", "Name": "Text23", "Guid": "7e934a4150364d3a8fb381c298bc0fdb", "ClientRectangle": "0.6,0.2,1.8,0.2", "ComponentPlacement": "h.ap.HeaderBand2", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Description" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text24", "Guid": "1fa4030d5fac4d5f8a034d01ba1e7096", "ClientRectangle": "2.8,0.2,1,0.2", "ComponentPlacement": "h.ap.HeaderBand2", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Effective On" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text25", "Guid": "39fc4ab9a2ca4d83afb09875142e973d", "ClientRectangle": "4.8,0.2,1,0.2", "ComponentPlacement": "h.ap.HeaderBand2", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Transaction On" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text26", "Guid": "63fad5c73c434f278b80d1a16d4b7810", "ClientRectangle": "6.6,0.2,0.9,0.2", "ComponentPlacement": "h.ap.HeaderBand2", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Amount" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true } }, "4": { "Ident": "StiText", "Name": "Text82", "Guid": "89281daa5c9947d289357f1ddb56de87", "ClientRectangle": "0,0,4,0.2", "ComponentPlacement": "h.ap.HeaderBand2", "ComponentStyle": "Style9", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": " Investor Activity - Withdrawals" }, "Font": ";11;Bold;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:212,175,55", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "5": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive11", "ClientRectangle": "0,0,7.7,0.01", "ComponentPlacement": "h.ap.HeaderBand2", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" } } }, "13": { "Ident": "StiDataBand", "Name": "DataBand2", "Guid": "26d3859ce05d4f41af72bc56db7215fd", "ClientRectangle": "0,12.1,7.72,0.2", "ComponentPlacement": "d.Page1", "Interaction": { "Ident": "StiBandInteraction" }, "CanBreak": true, "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text32", "Guid": "4d1baab0916a47e6b16b8251cc8274dc", "CanGrow": true, "ClientRectangle": "0.6,0,1.8,0.2", "ComponentPlacement": "d.DataBand2", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Pool_Transactions.TypeDescription}" }, "CanBreak": true, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text33", "Guid": "d2f1ef907b9b4696a0c773632a1deccb", "CanGrow": true, "ClientRectangle": "2.8,0,1,0.2", "ComponentPlacement": "d.DataBand2", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Pool_Transactions.EffectiveOn}" }, "CanBreak": true, "HorAlignment": "Center", "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "TextFormat": { "Ident": "StiDateFormatService" }, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text34", "Guid": "bef23d07588b4bba814819140155dc9d", "CanGrow": true, "ClientRectangle": "4.8,0,1,0.2", "ComponentPlacement": "d.DataBand2", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Pool_Transactions.TransactionOn}" }, "CanBreak": true, "HorAlignment": "Center", "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "TextFormat": { "Ident": "StiDateFormatService" }, "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text35", "Guid": "554605ad7fd846488f1604f18d057e5a", "CanGrow": true, "ClientRectangle": "6.6,0,0.9,0.2", "ComponentPlacement": "d.DataBand2", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Pool_Transactions.Amount}" }, "CanBreak": true, "HorAlignment": "Right", "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 0, "GroupSeparator": ",", "State": "DecimalDigits", "PositivePattern": 0 }, "Type": "Expression" } }, "DataSourceName": "Pool_Transactions", "EvenStyle": "Style8", "OddStyle": "Style1", "MasterComponent": "DataBand3", "Sort": { "0": "ASC", "1": "TransactionOn" }, "Filters": { "0": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{RangeDates.FromDate<=Pool_Transactions.TransactionOn&&RangeDates.ToDate>=Pool_Transactions.TransactionOn}" } }, "1": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{Pool_Transactions.CreditOrDebit.ToString()==\"Debit\"&&Pool_Transactions.PoolDebitType.ToString()==\"ParticipationReturn\"}" } }, "2": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{Pool_Transactions.LenderId==LenderSelect}" } } } }, "14": { "Ident": "StiFooterBand", "Name": "FooterBand3", "ClientRectangle": "0,12.7,7.72,0.3", "ComponentPlacement": "f.Page1", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text110", "Guid": "bee552fabde44dffb25d54053e433bcd", "ClientRectangle": "6.6,0,0.9,0.2", "ComponentPlacement": "f.FooterBand3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand2, Pool_Transactions.Amount)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold, Underline;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "TextFormat": { "Ident": "StiCurrencyFormatService", "NegativePattern": 0, "GroupSeparator": ",", "PositivePattern": 0 }, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text111", "Guid": "ce46895be84f488fb60bb55d90c913e5", "ClientRectangle": "4.8,0,1.7,0.2", "ComponentPlacement": "f.FooterBand3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Total Amount of Withdrawals: " }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" } } }, "15": { "Ident": "StiHeaderBand", "Name": "HeaderBand5", "ClientRectangle": "0,13.4,7.72,0.5", "ComponentPlacement": "h.ap.Page1", "ComponentStyle": "Style8", "Interaction": { "Ident": "StiInteraction" }, "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:242,242,242", "Components": { "0": { "Ident": "StiText", "Name": "Text87", "Guid": "719a62b87e634abea8437e4ce9510b1c", "ClientRectangle": "0,0.1,4,0.2", "ComponentPlacement": "h.ap.HeaderBand5", "ComponentStyle": "Style9", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": " Pool Assets (In-Service)" }, "VertAlignment": "Center", "Font": ";11;Bold;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:212,175,55", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text92", "Guid": "416a649d1619431cab8337aeb5bd94fe", "ClientRectangle": "0.6,0.3,2.3,0.2", "ComponentPlacement": "h.ap.HeaderBand5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Asset Name" }, "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text93", "Guid": "92194a5a2e424cac8c79e5937f0dcf56", "ClientRectangle": "3.6,0.3,0.7,0.2", "ComponentPlacement": "h.ap.HeaderBand5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Started On" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text95", "Guid": "169800a857b7412ca28c897e078dcb56", "ClientRectangle": "5.6,0.3,1,0.2", "ComponentPlacement": "h.ap.HeaderBand5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Loan Amount" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text50", "ClientRectangle": "0,0,7.7,0.1", "ComponentPlacement": "h.ap.HeaderBand5", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:255,255,255", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive13", "ClientRectangle": "0,0.1,7.7,0.01", "ComponentPlacement": "h.ap.HeaderBand5", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" } } }, "16": { "Ident": "StiDataBand", "Name": "DataBand6", "ClientRectangle": "0,14.3,7.72,0.3", "ComponentPlacement": "d.Page1", "Expressions": { "0": { "Name": "Enabled", "Expression": "Pool_Participants_Live.EndDate=RangeDates.FromDate&&Pool_Assets.SoldOn<=RangeDates.ToDate)}" } }, "1": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{(Pool_Assets.CategoryName==\"Bryt Pool\")&&(Pool_Assets.Cost==Pool_Assets.PrincipalReturn)&&(Pool_Assets.SoldOn>=RangeDates.FromDate&&Pool_Assets.SoldOn<=RangeDates.ToDate)}" } } } }, "20": { "Ident": "StiFooterBand", "Name": "FooterPoosAssets_PaidOff", "ClientRectangle": "0,17.2,7.72,0.3", "ComponentPlacement": "f.Page1", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:231,230,230", "Components": { "0": { "Ident": "StiText", "Name": "Text40", "Guid": "b07a1f07171c404b9c587366671f00ba", "ClientRectangle": "3.7,0,1.8,0.2", "ComponentPlacement": "f.FooterPoosAssets_PaidOff", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Total Pool Assets (Paid Off):" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";9;Bold;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text60", "Guid": "f071c0b2d9414200844b7e772c037acd", "ClientRectangle": "5.6,0,1,0.2", "ComponentPlacement": "f.FooterPoosAssets_PaidOff", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(Pool_Assets.Cost).ToString(\"C\")}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";9;Bold, Underline;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "empty", "TextBrush": "solid:0,0,0", "Type": "Expression" } } }, "21": { "Ident": "StiDataBand", "Name": "DataBandTransactions_ReinvestmentsPrior", "ClientRectangle": "0,17.9,7.72,0", "ComponentPlacement": "d.Page1", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "DataSourceName": "Pool_Transactions", "MasterComponent": "DataBand3", "Sort": { "0": "ASC", "1": "TransactionOn" }, "Filters": { "0": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{RangeDates.FromDate<=Pool_Transactions.EffectiveOn&&RangeDates.ToDate>=Pool_Transactions.EffectiveOn}" } }, "1": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{Pool_Transactions.CreditOrDebit.ToString()==\"Debit\"&&Pool_Transactions.PoolDebitType.ToString()==\"ParticipationReinvestment\"}" } }, "2": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{Pool_Transactions.LenderId==LenderSelect}" } } } }, "22": { "Ident": "StiDataBand", "Name": "DataBandTransactions_DisbursementsPrior", "ClientRectangle": "0,18.3,7.72,0", "ComponentPlacement": "d.Page1", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "DataSourceName": "Pool_Transactions", "MasterComponent": "DataBand3", "Sort": { "0": "ASC", "1": "TransactionOn" }, "Filters": { "0": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{RangeDates.FromDate<=Pool_Transactions.EffectiveOn&&RangeDates.ToDate>=Pool_Transactions.EffectiveOn}" } }, "1": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{Pool_Transactions.CreditOrDebit.ToString()==\"Debit\"&&Pool_Transactions.PoolDebitType.ToString()==\"Disbursement\"}" } }, "2": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{Pool_Transactions.LenderId==LenderSelect}" } } } }, "23": { "Ident": "StiDataBand", "Name": "DataBandTransactions_ParticipantDepositsPrior", "ClientRectangle": "0,18.7,7.72,0", "ComponentPlacement": "d.Page1", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "DataSourceName": "Pool_Transactions", "MasterComponent": "DataBand3", "Sort": { "0": "ASC", "1": "TransactionOn" }, "Filters": { "0": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{RangeDates.FromDate<= Pool_Transactions.TransactionOn&&RangeDates.ToDate >=Pool_Transactions.TransactionOn}" } }, "1": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{Pool_Transactions.CreditOrDebit.ToString()==\"Credit\"&&Pool_Transactions.CreditType.ToString()==\"Participation\"}" } }, "2": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{Pool_Transactions.LenderId==LenderSelect}" } } } }, "24": { "Ident": "StiDataBand", "Name": "DataBandTransactions_ParticipantWithdrawalsPrior", "ClientRectangle": "0,19.1,7.72,0", "ComponentPlacement": "d.Page1", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "DataSourceName": "Pool_Transactions", "MasterComponent": "DataBand3", "Sort": { "0": "ASC", "1": "TransactionOn" }, "Filters": { "0": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{RangeDates.FromDate<=Pool_Transactions.TransactionOn&&RangeDates.ToDate>=Pool_Transactions.TransactionOn}" } }, "1": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{Pool_Transactions.CreditOrDebit.ToString()==\"Debit\"&&Pool_Transactions.PoolDebitType.ToString()==\"ParticipationReturn\"}" } }, "2": { "Ident": "StiFilter", "Item": "Expression", "Expression": { "Value": "{Pool_Transactions.LenderId==LenderSelect}" } } } }, "25": { "Ident": "StiReportSummaryBand", "Name": "ReportSummaryBand1", "ClientRectangle": "0,19.5,7.72,0.7", "ComponentPlacement": "rs.Page1", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:231,230,230", "Components": { "0": { "Ident": "StiText", "Name": "Text156", "Guid": "80412d6fc3a34365b2035bb5ce0dc332", "ClientRectangle": "0,0.3,7.7,0.4", "ComponentPlacement": "rs.ReportSummaryBand1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": " \"Thank You for Your Membership\"" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Gabriola;18;Bold;", "Border": ";0,0,0;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text155", "Guid": "a078ac4a121a41b18c1083575e9cd032", "ClientRectangle": "0,0,7.7,0.3", "ComponentPlacement": "rs.ReportSummaryBand1", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "* * * End of Pool Statement from {RangeDates.FromDate.ToString(\"MMMM d, yyyy\")} through {RangeDates.ToDate.ToString(\"MMMM d, yyyy\")} * * * " }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";8.5;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" } } }, "26": { "Ident": "StiRectanglePrimitive", "Name": "RectanglePrimitive3", "Guid": "0aca90b9d10d472d8866ff3111089de9", "ClientRectangle": "6,1.2,1.7,0.2", "ComponentPlacement": "p.Page1", "Interaction": { "Ident": "StiInteraction" } }, "27": { "Ident": "StiRectanglePrimitive", "Name": "RectanglePrimitive4", "Guid": "8ab18e13ef734d83a05eea1b5320dcc2", "ClientRectangle": "4.4,1.2,1.6,0.2", "ComponentPlacement": "p.Page1", "Interaction": { "Ident": "StiInteraction" } }, "28": { "Ident": "StiRoundedRectanglePrimitive", "Name": "RoundedRectanglePrimitive1", "Guid": "b3ce46313cca4fe3bc759d07ff8bb546", "ClientRectangle": "0.2,2.8,3.7,1", "ComponentPlacement": "p.Page1", "Interaction": { "Ident": "StiInteraction" } } }, "PaperSize": "Letter", "PageWidth": 8.5, "PageHeight": 11.0, "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 0.39, "Right": 0.39, "Top": 0.39, "Bottom": 0.39 } } } }