MySum += 1; Interpretation Loans RPTSA_LoanId,System.Int32 LoanId,System.Int32 BorrowerId,System.Int32 LoanName,System.String BrytState,System.String ClosingDate,System.DateTime InServiceOn,System.DateTime InPreServiceOn,System.DateTime CancelledOn,System.DateTime PaidOffOn,System.DateTime InDefaultOn,System.DateTime PaymentFrequency,System.String ProrateAmount,System.Decimal DaysLate,System.Int32 TotalDueWithPastAndLates,System.Decimal MaturityDate,System.DateTime LastDayInterestPaid,System.DateTime LenderCount,System.String LoanTypeId,System.Int32 LoanType,System.String ReferringVendorId,System.Int32 Title1VendorId,System.Int32 Title2VendorId,System.Int32 NextPaymentAmount,System.Decimal NextPaymentDueOn,System.DateTime NextPaymentInterestDue,System.Decimal NextPaymentPrincipalDue,System.Decimal NextPaymentLateDue,System.Decimal CreatedByUser,System.String FundingMethod,System.Int32 FirstPayinDate,System.DateTime 9d7e71b21c2f4f9cadd25830a757875d Loans Tables.Loans Worksheets RPTSA_WorksheetId,System.Int32 LoanId,System.Int32 WSLoanAmount,System.Decimal WSTotalClosing,System.Decimal WSTotalProceeds,System.Decimal WSPayment,System.Decimal CLTV,System.Decimal Balloon,System.Decimal Amortization,System.Double WSInterestRate,System.Decimal WSTerm,System.Int32 WSLoanPayoff,System.Decimal Valuation,System.Decimal SecuredBy,System.String LoanPosition,System.String ClosingDate,System.DateTime FundedAmount,System.Decimal FundingMethod,System.Int32 9618dc56bac34169bfcf3e0951bf948e Worksheets Tables.Worksheets Investments RPTSA_InvestmentId,System.Int32 LoanId,System.Int32 LenderId,System.Int32 InvestmentId,System.Int32 StartDate,System.DateTime EndDate,System.DateTime LenderName,System.String PayPeriodAmount,System.Decimal DailyShare,System.Double ServicingChargeMethod,System.Int32 InvestmentServingFee,System.Decimal InvestmentServicingRate,System.Decimal 8472fc8f4ded406f89acbf78d29c32d8 Investments Tables.Investments Borrowers RPTSA_BorrowerId,System.Int32 BorrowerId,System.Int32 Vesting,System.String FullName,System.String First,System.String Last,System.String Organization,System.String Title,System.String Signer,System.Boolean Signature,System.String Street1,System.String Street2,System.String City,System.String State,System.String Zip,System.String PhoneNumber,System.String EmailAddress,System.String DefaultBankName,System.String DefaultBankAccount,System.String DefaultBankRouting,System.String 33db570a48fb491098f64de9c19a50ac Borrowers Tables.Borrowers Lenders RPTSA_LenderId,System.Int32 LenderId,System.Int32 Vesting,System.String FullName,System.String First,System.String Last,System.String Organization,System.String Title,System.String Signer,System.Boolean Signature,System.String Street1,System.String Street2,System.String City,System.String State,System.String Zip,System.String PhoneNumber,System.String EmailAddress,System.String DefaultBankName,System.String DefaultBankAccount,System.String DefaultBankRouting,System.String PortfolioTarget,System.Decimal 00d2fd5a002249749265bec3e1200fe6 Lenders Tables.Lenders Udfs RPTSA_UdfId,System.Int32 Category,System.String TextValue,System.String IntegerValue,System.Int32 DecimalValue,System.Decimal DateValue,System.DateTime LoanId,System.Int32 PropertyId,System.Int32 BorrowerId,System.Int32 LenderId,System.Int32 FormattedValue,System.String FieldName,System.String 57fab60e67ea48469a62cfc7af19693e Udfs Tables.Udfs PeriodicLoanSummaries RPTSA_PeriodicLoanSummaryId,System.Int32 AsOfDate,System.DateTime LoanId,System.Int32 CurrentInterestRate,System.Decimal DailyInterestRate360,System.Decimal DailyDefaultInterestRate360,System.Decimal PeriodicInterestRate,System.Decimal PeriodicDefaultInterestRate,System.Decimal DailyInterestAmount360,System.Decimal DailyDefaultInterestAmount360,System.Decimal PeriodicInterestAmount,System.Decimal PeriodicDefaultInterestAmount,System.Decimal FullLoanAmount,System.Decimal ActiveLoanAmount,System.Decimal PrincipalBalance,System.Decimal PrincipalPaid,System.Decimal InterestAccrued,System.Decimal InterestPaid,System.Decimal InterestBalance,System.Decimal LateFeesTotalDue,System.Decimal LateFeesPaid,System.Decimal LateFeesBalance,System.Decimal ManagementFeesTotalDue,System.Decimal ManagementFeesPaid,System.Decimal ManagementFeesBalance,System.Decimal ImpoundFeesCollected,System.Decimal ImpoundFeesPaidOut,System.Decimal ImpoundFeesBalance,System.Decimal LenderAdvancesInterestAccrued,System.Decimal LenderAdvancesInterestPaid,System.Decimal LenderAdvancesInterestBalance,System.Decimal LenderAdvancesPrincipalAccrued,System.Decimal LenderAdvancesPrincipalPaid,System.Decimal LenderAdvancesPrincipalBalance,System.Decimal LenderExpensesTotalDue,System.Decimal LenderExpensesPaid,System.Decimal LenderExpensesBalance,System.Decimal LenderCommissionsTotalDue,System.Decimal LenderCommissionsPaid,System.Decimal LenderCommissionsBalance,System.Decimal TotalLoanBalance,System.Decimal HoldBackReserve,System.Decimal PostPaidAccruedInterest,System.Decimal PostPaidAccruedStdFormLateFees,System.Decimal LoanName,System.String d8686c5588d9487aa1428d269a99e75b PeriodicLoanSummaries Tables.PeriodicLoanSummaries PeriodicInvestmentDetails RPTSA_PeriodicInvestmentDetailsId,System.Int32 AsOfDate,System.DateTime InvestmentId,System.Int32 LoanId,System.Int32 LenderId,System.Int32 LoanName,System.String InvestmentAmount,System.Decimal OwnershipPercentage,System.Double StartDate,System.DateTime EndDate,System.DateTime CalulatedEndDate,System.DateTime PrincipalBalance,System.Decimal InterestEarned,System.Decimal InterestRate,System.Decimal DaysLate,System.Int32 BorrowerName,System.String PeriodicPaidOutInterest,System.Decimal PeriodicPaidOutLates,System.Decimal PeriodicPaidOutPrincipal,System.Decimal PeriodicPaidOutTotal,System.Decimal 24ebbbc6fc804a448ff119198cd14ec5 PeriodicInvestmentDetails Tables.PeriodicInvestmentDetails PayIns RPTSA_PayInId,System.Int32 LoanId,System.Int32 PayInId,System.Int32 PayPeriodId,System.Int32 PayInType,System.Int32 PayInState,System.Int32 TotalAmountPaid,System.Decimal InterestPaid,System.Decimal PrincipalPaid,System.Decimal LateFeesPaid,System.Decimal ImpoundFeesPaid,System.Decimal OutstandingInterestPaid,System.Decimal OutstandingLateFeesPaid,System.Decimal OutstandingManagementFeesPaid,System.Decimal OutstandingLenderAdvancesPaid,System.Decimal OutstandingLenderExpensesPaid,System.Decimal OutstandingLenderCommissionsPaid,System.Decimal ReturnToBorrower,System.Decimal TotalAmountDue,System.Decimal InterestDue,System.Decimal PrincipalDue,System.Decimal LateFeesDue,System.Decimal ImpoundFeesDue,System.Decimal PaidOnDate,System.DateTime EnteredOn,System.DateTime ReadyOn,System.DateTime ProcessedOn,System.DateTime ReconciledOn,System.DateTime CheckNumber,System.String Note,System.String TransferFundsBy,System.Int32 IgnoreHoldPeriod,System.Boolean Source,System.Int32 d4c1442478dd437293d06b367a519aca PayIns Tables.PayIns PayOuts RPTSA_PayOutId,System.Int32 PayOutId,System.Int32 PayInId,System.Int32 LoanId,System.Int32 PayOutType,System.Int32 GeneratedOn,System.DateTime HoldEndsOn,System.DateTime ProcessedOn,System.DateTime ReconciledOn,System.DateTime IgnoreHoldPeriod,System.Boolean InvestmentId,System.Int32 TransferFundsBy,System.Int32 BorrowerId,System.Int32 CheckNumber,System.String PayOutState,System.Int32 VendorId,System.Int32 Amount,System.Decimal Principal,System.Decimal Interest,System.Decimal Late,System.Decimal LenderAdvancePrincipal,System.Decimal LenderAdvanceInterest,System.Decimal LenderExpense,System.Decimal LenderCommission,System.Decimal 02d368daf246481098e209fdd5a33cbd PayOuts Tables.PayOuts PayPeriods RPTSA_PayPeriodId,System.Int32 PayPeriodId,System.Int32 LoanId,System.Int32 InterestRate,System.Decimal LoanAmount,System.Decimal FirstDayOfPeriod,System.DateTime LastDayOfPeriod,System.DateTime DueDate,System.DateTime RequestedPayment,System.Decimal Term,System.Int32 Amortization,System.Double AdditionalPrincipalDue,System.Decimal IsProratePeriod,System.Boolean State,System.Int32 ExtensionIndex,System.Int32 PayPeriodType,System.Int32 4424e9e13f414b9492d3808c38f770e6 PayPeriods Tables.PayPeriods LoanDebits RPTSA_LoanDebitId,System.Int32 LoanDebitEntryId,System.Int32 LoanId,System.Int32 EffectiveOn,System.DateTime EnteredOn,System.DateTime Amount,System.Decimal Note,System.String InvestmentId,System.Int32 VendorId,System.Int32 Target,System.Int32 DailyFundedDebitIntent,System.Int32 CheckNumber,System.String TransferMethod,System.Int32 State,System.Int32 ProcessedOn,System.DateTime ReconciledOn,System.DateTime ReadyOn,System.DateTime RegisterOption,System.Int32 949d08c8c0d04da884c727bf5875a5cc LoanDebits Tables.LoanDebits LoanCredits RPTSA_LoanCreditId,System.Int32 LoanCreditEntryId,System.Int32 LoanId,System.Int32 EffectiveOn,System.DateTime EnteredOn,System.DateTime PayPeriodId,System.Int32 Amount,System.Decimal Note,System.String CreditSource,System.Int32 InvestmentId,System.Int32 VendorId,System.Int32 PayPeriodFundedCreditIntent,System.Int32 CheckNumber,System.String TransferMethod,System.Int32 State,System.Int32 ProcessedOn,System.DateTime ReconciledOn,System.DateTime ReadyOn,System.DateTime RegisterOption,System.Int32 a21bc34d54134409a33a93e42fb5ad88 LoanCredits Tables.LoanCredits Properties RPTSA_PropertyId,System.Int32 PropertyId,System.Int32 LoanId,System.Int32 APN,System.String TypeConstruction,System.String Address1,System.String Address2,System.String City,System.String State,System.String Zip,System.String FullAddress,System.String SquareFeet,System.Int32 Age,System.Int32 Description,System.String LegalDescription,System.String Note,System.String TaxDate,System.DateTime DeedRecordingNumber,System.String DeedRecordingDate,System.DateTime DeedRecordingCounty,System.String Encumbered,System.Boolean 0ac82561b8a6472f9ddaeb75f53d75a4 Properties Tables.Properties Udfs_Investments LoanId Udfs_Investments Udfs_Investments LoanId Borrower_Loans BorrowerId Borrower_Loans Borrower_Loans BorrowerId Lender_Investment LenderId Lender_Investment Lender_Investment LenderId PID_Invest LoanId PID_Invest PID_Invest LoanId Loan_Investment LoanId Loan_Investment Loan_Investment LoanId Properties_Loans LoanId Properties_Loans Properties_Loans LoanId PLSumm_Loans LoanId PLSumm_Loans PLSumm_Loans LoanId Udfs_Loans LoanId Udfs_Loans Udfs_Loans LoanId WS_Loans LoanId WS_Loans WS_Loans LoanId Loans_Borrowers BorrowerId Loans_Borrowers Loans_Borrowers BorrowerId ,MySum,MySum,,System.Int32,,True,False,False,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_DateTimeType_x003E_DateAndTime_x003C__x002F_DateTimeType_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_ EngineV2 aee5baf3655d4d6388e43a02e2c0f862 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,10.22,0.8 ph.Page1 None;[0:0:0];1;Solid;False;4;[0:0:0] Transparent 3.5,0,3.3,0.5 ph.PageHeaderBand1 Arial,18,Bold Center 0,0,0,0 Text11 KLINKLOANS FUND [0:0:0] Expression Center None;[0:0:0];1;Solid;False;4;[0:0:0] Transparent 3.5,0.5,3.3,0.2 ph.PageHeaderBand1 Arial,12,Bold Center 0,0,0,0 Text12 EXPOSURE LIMITS REPORT [0:0:0] Expression Center None;[0:0:0];1;Solid;False;4;[0:0:0] Transparent 9,0.3,1.2,0.2 ph.PageHeaderBand1 Arial,10,Bold Center 0,0,0,0 Text13 {Today.ToString("MM/dd/yyyy")} [0:0:0] Expression Center None;[0:0:0];1;Solid;False;4;[0:0:0] Transparent 9,0.5,1.2,0.2 ph.PageHeaderBand1 Arial,10,Bold 8651f92857344d0988d63fcbfbd987f3 Center 0,0,0,0 Text14 {PageNofM} [0:0:0] Expression Center PageHeaderBand1 Transparent 0,30.58,10.22,0.3 pf.Page1 PageFooterBand1 Transparent 0,1.4,10.22,0.3 rt.Page1 ReportTitleBand1 Top, Bottom;[0:0:0];1;Solid;False;4;[0:0:0] [231:230:230] True 0,2.1,10.22,0.3 h.ap.Page1 Transparent True 0,0,0.5,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_LoanId LoanId Black ,,,,WordWrap=True,A=0 Center Transparent True True 0.6,0,1.6,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_LoanName LoanName Black ,,,,WordWrap=True,A=0 Center Transparent True True 2.3,0,1.5,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_Properties_Loans_Address1 Address Black ,,,,WordWrap=True,A=0 Expression Center Transparent True True 3.9,0,0.9,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_Properties_Loans_City City Black ,,,,WordWrap=True,A=0 Center Transparent True True 4.9,0,0.4,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_Properties_Loans_State State Black ,,,,WordWrap=True,A=0 Center Transparent True True 5.4,0,0.4,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_Properties_Loans_Zip Zip Black ,,,,WordWrap=True,A=0 Center Transparent True True 6.1,0,1,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_PLSumm_Loans_PrincipalBalance Principal Balance Black ,,,,WordWrap=True,A=0 Expression Center Transparent True True 7.4,0,0.9,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_WS_Loans_WSLoanAmount DOT Black ,,,,WordWrap=True,A=0 Expression Center Transparent True True 8.5,0,1,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_PLSumm_Loans_HoldBackReserve Unfunded Draws Black ,,,,WordWrap=True,A=0 Expression Center Transparent True True 9.6,0,0.6,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_WS_Loans_WSInterestRate Interest Rate Black ,,,,WordWrap=True,A=0 Expression Center Transparent True 0,0,0.5,0.3 h.ap.HeaderLoans Arial,10,Bold 60609c0cdb9c4c4a94b1428e0f2f961e 0,0,0,0 Text1 LoanId Black ,,,,WordWrap=True,A=0 Center Transparent True 0,0,0.5,0.3 h.ap.HeaderLoans Arial,10,Bold a285358333b145b5a5efab51e935f692 0,0,0,0 Text2 LoanId Black ,,,,WordWrap=True,A=0 Center Transparent True True 0,0,0.5,0.3 h.ap.HeaderLoans Arial,10,Bold 930175eeea3f49cb902f4bc2440b8e8a 0,0,0,0 Text3 LoanId Black ,,,,WordWrap=True,A=0 Expression Center HeaderFooter HeaderLoans None;[0:0:0];1;Solid;False;4;[0:0:0] Transparent True 0,2.8,10.22,0.3 d.Page1 Transparent True True 0,0,0.5,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_LoanId {Loans.LoanId} Black ,,,,WordWrap=True,A=0 Center Transparent True True 0.6,0,1.6,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_LoanName {Loans.LoanName} Black ,,,,WordWrap=True,A=0 Center Transparent True True 2.3,0,1.5,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_Properties_Loans_Address1 {Loans.Properties_Loans.Address1} Black ,,,,WordWrap=True,A=0 Center Transparent True True 3.9,0,0.9,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_Properties_Loans_City {Loans.Properties_Loans.City} Black ,,,,WordWrap=True,A=0 Center Transparent True True 4.9,0,0.4,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_Properties_Loans_State {Loans.Properties_Loans.State} Black ,,,,WordWrap=True,A=0 Center Transparent True True 5.4,0,0.4,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_Properties_Loans_Zip {Loans.Properties_Loans.Zip} Black ,,,,WordWrap=True,A=0 Center Transparent True True 6.1,0,1,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_PLSumm_Loans_PrincipalBalance {Loans.PLSumm_Loans.PrincipalBalance} Black 2 , 0 0 ,,,,WordWrap=True,A=0 Center Transparent True True 7.4,0,0.9,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_WS_Loans_WSLoanAmount {Loans.WS_Loans.WSLoanAmount} Black 2 , 0 0 ,,,,WordWrap=True,A=0 Center Transparent True True 8.5,0,1,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_PLSumm_Loans_HoldBackReserve {Loans.PLSumm_Loans.HoldBackReserve} Black 2 , 0 0 ,,,,WordWrap=True,A=0 Expression Center Transparent True True 9.6,0,0.6,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_WS_Loans_WSInterestRate {Loans.WS_Loans.WSInterestRate/100} Black 2 , 0 0 % ,,,,WordWrap=True,A=0 Expression Center Loans Even8 _x007B_Loans.BrytState_x003D__x003D__x0022_InService_x0022__x007D_ DataLoans Odd8 ASC LoanName Top, Bottom;[0:0:0];1;Solid;False;4;[0:0:0] [231:230:230] True 0,3.5,10.22,0.3 f.Page1 Transparent True True 0,0,1.4,0.3 f.FooterLoans Arial,10,Bold 0,0,0,0 FooterLoans_LoanId Number of Loans: Black ,,,,WordWrap=True,A=0 Expression Center Transparent True True 6.1,0,1.6,0.3 f.FooterLoans Arial,10,Bold 0,0,0,0 FooterLoans_PLSumm_Loans_TotalLoanBalance {Sum(DataLoans,Loans.PLSumm_Loans.PrincipalBalance)} Black 2 , 0 0 ,,,,WordWrap=True,A=0 Totals Center Transparent True 1.5,0,1.1,0.3 f.FooterLoans Arial,10,Bold 0,0,0,0 FooterBorrowers_BorrowerId {Count(DataLoans)} Black ,,,,WordWrap=True,A=0 Expression HeaderFooter FooterLoans Top, Bottom;[0:0:0];1;Solid;False;4;[0:0:0] [231:230:230] 0,4.2,10.22,0.3 h.ap.Page1 Transparent True 0,0,0.5,0.3 h.ap.HeaderBorrowers Arial,10,Bold 0,0,0,0 HeaderBorrowers_BorrowerId Tag Black Expression Center Transparent True 0.6,0,4.3,0.3 h.ap.HeaderBorrowers Arial,10,Bold 0,0,0,0 HeaderBorrowers_First Borrower Black Expression Center Transparent 5,0,1.2,0.3 h.ap.HeaderBorrowers Arial,10,Bold d3046a65773a4e7dac9e9720e89e9265 0,0,0,0 Text7 # of loans Black Expression Center Transparent 6.4,0,1.4,0.3 h.ap.HeaderBorrowers Arial,10,Bold bb39fead32104665a295d6e0445b01f7 0,0,0,0 Text5 UPB Black Expression Center Transparent True 7.9,0,2.2,0.3 h.ap.HeaderBorrowers Arial,10,Bold d508dc80c15046489e6a3c2eeb00abdf 0,0,0,0 Text8 UPB as Percent of Current Fund Black ,,,,WordWrap=True,A=0 Expression Center HeaderFooter HeaderBorrowers True False Top, Bottom;[0:0:0];1;Solid;False;4;[0:0:0] [222:235:246] True 0,4.9,10.22,0.3 d.Page1 Transparent True True 0,0,0.5,0.3 d.DataBorrowers Arial,8 Center 0,0,0,0 DataBorrowers_BorrowerId BasedOnValueAndTagMerge {Borrowers.First}{Borrowers.Last} {Left(Borrowers.First, 1)}{Left(Borrowers.Last, 1)} Black ,,,,WordWrap=True,A=0 Expression Center Transparent True True 0.6,0,2.1,0.3 d.DataBorrowers Arial,8 Center 0,0,0,0 DataBorrowers_First BasedOnValueAndTagMerge {Borrowers.First}{Borrowers.Last} {Borrowers.First} Black ,,,,WordWrap=True,A=0 Center Transparent True True 2.8,0,2.1,0.3 d.DataBorrowers Arial,8 Center 0,0,0,0 DataBorrowers_Last BasedOnValueAndTagMerge {Borrowers.First}{Borrowers.Last} {Borrowers.Last} Black ,,,,WordWrap=True,A=0 Center Transparent True 5,0,1.2,0.3 d.DataBorrowers Arial,8 64a2611811d24755a7da585099b82f9d Center 0,0,0,0 Text6 BasedOnValueAndTagMerge {Borrowers.First}{Borrowers.Last} {CountIf(DataLoans2, Borrowers.First==Loans.Borrower_Loans.First&&Borrowers.Last==Loans.Borrower_Loans.Last)} Black Expression Center Transparent True 6.4,0,1.4,0.3 d.DataBorrowers Arial,8 b21929bbd1d342b6a3927cf6aba2660c Center 0,0,0,0 Text4 BasedOnValueAndTagMerge {Borrowers.First}{Borrowers.Last} {SumIf(DataLoans2, Loans.PLSumm_Loans.PrincipalBalance, Borrowers.First==Loans.Borrower_Loans.First&&Borrowers.Last==Loans.Borrower_Loans.Last)} Black 2 , 0 0 Expression Center Transparent True True 7.9,0,2.2,0.3 d.DataBorrowers Arial,8 148e049fd01241688307def0e2cbc1a8 Center 0,0,0,0 Text9 BasedOnValueAndTagMerge {Borrowers.First}{Borrowers.Last} {SumIf(DataLoans2, Loans.PLSumm_Loans.PrincipalBalance, Borrowers.First==Loans.Borrower_Loans.First&&Borrowers.Last==Loans.Borrower_Loans.Last)/Sum(DataLoans,Loans.PLSumm_Loans.PrincipalBalance)} Black 2 , 0 0 % ,,,,WordWrap=True,A=0 Expression Center Borrowers DataBorrowers False ASC First ASC Last Top, Bottom;[0:0:0];1;Solid;False;4;[0:0:0] [231:230:230] 0,5.6,10.22,0.3 f.Page1 Transparent True 5,0,1.2,0.3 f.FooterBorrowers Arial,10,Bold Center 0,0,0,0 FooterBorrowers_First {Count(DataLoans)} Black ,,,,WordWrap=True,A=0 Expression Center Transparent True 6.4,0,1.4,0.3 f.FooterBorrowers Arial,10,Bold Center 0,0,0,0 FooterBorrowers_Last {Sum(DataLoans,Loans.PLSumm_Loans.PrincipalBalance)} Black 2 , 0 0 ,,,,WordWrap=True,A=0 Expression Center Transparent 3.7,0,1.2,0.3 f.FooterBorrowers Arial,10,Bold f7d54b99c177456a98f0099ab5025701 Right 0,0,0,0 Text10 Total: Black Expression Center HeaderFooter FooterBorrowers Transparent True True 0,6.3,10.22,0 d.Page1 Loans _x007B_Borrowers.First_x003D__x003D_Loans.Borrower_Loans.First_x0026__x0026_Loans.Borrower_Loans.Last_x003D__x003D_Borrowers.Last_x007D_ _x007B_Loans.BrytState_x003D__x003D__x0022_InService_x0022__x007D_ DataLoans2 False {Borrowers.First}{Borrowers.Last} Transparent 0,6.7,10.22,0.3 h.ap.Page1 Transparent 0,0,1.2,0.3 h.ap.HeaderUdfs Arial,10,Bold 0,0,0,0 HeaderUdfs_FieldName FieldName Black ,,,,WordWrap=True,A=0 Center HeaderUdfs True False Transparent True 0,7.4,10.22,0.3 d.Page1 Transparent True True 0,0,1.6,0.3 d.DataUdfs Arial,8 0,0,0,0 DataUdfs_FieldName BasedOnValueAndTagMerge {Udfs.FieldName} {Udfs.FieldName} Black ,,,,WordWrap=True,A=0 Expression Center Udfs _x007B_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_Construction_x0020_Loan_x0022__x007C__x007C_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_New_x0020_Construction_x0022__x007C__x007C_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_Subdivision_x0022__x007C__x007C_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_Multi-Family_x0020__x0028_2_x002B__x0020_units_x0029__x0022__x007C__x007C_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_Commercial_x0022__x007C__x007C_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_Land_x0022__x007C__x007C_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_Group_x0020_Home_x0022__x007C__x007C_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_Outside_x0020_Maricopa_x0020_County_x0022__x007C__x007C_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_100_x0025__x0020_Loans_x0020_with_x0020_Profit_x0020_Split_x0022__x007C__x007C_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_Group_x0020_Homes_x0022__x007D_ FormattedValue,EqualTo,true,,Boolean DataUdfs MySum++; False Transparent 0,8.1,10.22,0.3 f.Page1 Transparent 0,0,0.9,0.3 f.FooterUdfs Arial,10,Bold Right 0,0,0,0 FooterUdfs_Category Black ,,,,WordWrap=True,A=0 Expression Center Transparent 8.1,0,0.9,0.3 f.FooterUdfs Arial,10,Bold Right 0,0,0,0 FooterUdfs_FormattedValue Black ,,,,WordWrap=True,A=0 Center Transparent 9,0,1.2,0.3 f.FooterUdfs Arial,10,Bold Right 0,0,0,0 FooterUdfs_FieldName Black ,,,,WordWrap=True,A=0 Center FooterUdfs Transparent 0,8.8,10.22,0.3 d.Page1 Transparent True 1.7,0,1.4,0.3 d.DataLoans3 Arial,8 0,0,0,0 DataLoans_LoanName2 {Loans.LoanName} Black ,,,,WordWrap=True,A=0 Center Loans _x007B_Loans.BrytState_x003D__x003D__x0022_InService_x0022__x007D_ _x007B_Loans.LoanId_x003D__x003D_Udfs.LoanId_x007D_ DataLoans3 9dc46a11e7c340c481eaa30cd290d507 True 0.39,0.39,0.39,0.39 Page1 Landscape 8.5 11 Letter System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll ExpoLimTest_[InProg]_v1.2 12/14/2020 10:33:56 PM 12/14/2020 10:33:56 PM 21f3d9e23caf4d07ab48ecabc6393a49 ExpoLimTest_[InProg]_v1.2 Inches 2020.5.1.0 CSharp None;[0:0:0];1;Solid;False;4;[0:0:0] [222:235:246] Arial,8 Odd8 [255:0:0] [0:0:0] None;[0:0:0];1;Solid;False;4;[0:0:0] [242:242:242] Arial,8 Even8 [255:0:0] [0:0:0] Top, Bottom;[0:0:0];1;Solid;False;4;[0:0:0] [231:230:230] Arial,10,Bold HeaderFooter [255:0:0] [0:0:0] Center