{ "ReportVersion": "2021.4.2.0", "ReportGuid": "231a716a862d4911baa6071f88c9aec0", "ReportName": "Current Balance ", "ReportAlias": "AgreementCurrentBalanceReportView", "ReportAuthor": "Riaan van der Westhuizen", "ReportCreated": "/Date(1485158397000+0200)/", "ReportChanged": "/Date(1727953896846+0200)/", "EngineVersion": "EngineV2", "ReportUnit": "Millimeters", "CacheAllData": true, "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": { "Value": "Prepared By", "Name": "PreparedBy", "Alias": "PreparedBy", "Type": "System.String" }, "1": { "Name": "SubscriberLogo", "Alias": "SubscriberLogo", "Type": "System.Drawing.Image" }, "2": { "Value": "Version: 123", "Name": "Version", "Alias": "Version", "Type": "System.String" } }, "BusinessObjects": { "0": { "Columns": { "0": { "Name": "Number", "Index": -1, "NameInSource": "Number", "Alias": "Number", "Type": "System.String", "Key": "e98e6bc1e55146ba8750635868974907" }, "1": { "Name": "BorrowerName1", "Index": -1, "NameInSource": "BorrowerName1", "Alias": "BorrowerName1", "Type": "System.String", "Key": "abc7cab1c42a4acdbe2fb3d363bf87c1" }, "2": { "Name": "AgreementNumber", "Index": -1, "NameInSource": "AgreementNumber", "Alias": "AgreementNumber", "Type": "System.Int64" }, "3": { "Name": "Capital", "Index": -1, "NameInSource": "Capital", "Alias": "Capital", "Type": "System.Decimal" }, "4": { "Name": "Interest", "Index": -1, "NameInSource": "Interest", "Alias": "Interest", "Type": "System.Decimal" }, "5": { "Name": "Insurance", "Index": -1, "NameInSource": "Insurance", "Alias": "Insurance", "Type": "System.Decimal" }, "6": { "Name": "Vat", "Index": -1, "NameInSource": "Vat", "Alias": "Vat", "Type": "System.Decimal" }, "7": { "Name": "InitiationFee", "Index": -1, "NameInSource": "InitiationFee", "Alias": "InitiationFee", "Type": "System.Decimal" }, "8": { "Name": "ServiceFee", "Index": -1, "NameInSource": "ServiceFee", "Alias": "ServiceFee", "Type": "System.Decimal" }, "9": { "Name": "CurrentBalance", "Index": -1, "NameInSource": "CurrentBalance", "Alias": "CurrentBalance", "Type": "System.Decimal", "Ident": "Calc", "Expression": "(CurrentBalanceReportData.Capital + CurrentBalanceReportData.Interest +\r\nCurrentBalanceReportData.InitiationFee +\r\nCurrentBalanceReportData.ServiceFee +\r\nCurrentBalanceReportData.Vat +\r\nCurrentBalanceReportData.Insurance)" }, "10": { "Name": "Surname", "Index": -1, "NameInSource": "Surname", "Alias": "Surname", "Type": "System.String" }, "11": { "Name": "Branch", "Index": -1, "NameInSource": "Branch", "Alias": "Branch", "Type": "System.String" }, "12": { "Name": "EmployerName", "Index": -1, "NameInSource": "EmployerName", "Alias": "EmployerName", "Type": "System.String" }, "13": { "Name": "AgreementStatus", "Index": -1, "NameInSource": "AgreementStatus", "Alias": "AgreementStatus", "Type": "System.String", "Key": "468a6e9540ac4c4c937d2c30761eeaa4" }, "14": { "Name": "ProductName", "Index": -1, "NameInSource": "ProductName", "Alias": "ProductName", "Type": "System.String" } }, "Guid": "0b0bfa94a2e847918428f57733d851f6", "Category": "CurrentBalanceReportData", "Name": "CurrentBalanceReportData", "Alias": "CurrentBalanceReportData" }, "1": { "Columns": { "0": { "Name": "Filter", "Index": -1, "NameInSource": "Filter", "Alias": "Filter", "Type": "System.String" }, "1": { "Name": "Description", "Index": -1, "NameInSource": "Description", "Alias": "Description", "Type": "System.String" } }, "Guid": "635ea82f422446d882d7fe2f7a612864", "Category": "FilterReportData", "Name": "FilterReportData", "Alias": "FilterReportData" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Page1", "Guid": "adbc95caf22b48519e951fd93d85ff9c", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiPageHeaderBand", "Name": "PageHeader", "PrintOn": "OnlyFirstPage", "ClientRectangle": "0,4,276.9,18", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiImage", "Name": "SubscriberImage", "PrintOn": "OnlyFirstPage", "CanShrink": true, "ClientRectangle": "192,0,83,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": "StiText", "Name": "Text1", "ClientRectangle": "0,8,192,10", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{ReportName}" }, "VertAlignment": "Center", "Font": "Calibri;20;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" } } }, "1": { "Ident": "StiPageFooterBand", "Name": "PageFooter", "ClientRectangle": "0,186.1,276.9,4", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text2", "ClientRectangle": "0,0,60,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{PageNofM}" }, "VertAlignment": "Center", "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black" }, "1": { "Ident": "StiText", "Name": "Text3", "ClientRectangle": "186,0,90,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Version}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text4", "ClientRectangle": "60,0,126,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Prepare By: {PreparedBy} on {DateTime.Now}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" } } }, "2": { "Ident": "StiDataBand", "Name": "DataFilterData", "ClientRectangle": "0,30,276.9,4", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "DataStimulsoft_Report_Wpf_NodeTreeViewItem_Header__Items_Count_0", "CanGrow": true, "ClientRectangle": "0,0,276,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{FilterReportData.Filter} : {FilterReportData.Description}" }, "VertAlignment": "Center", "Font": "Calibri;;Italic;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" } }, "PrintIfDetailEmpty": true, "BusinessObjectGuid": "635ea82f422446d882d7fe2f7a612864" }, "3": { "Ident": "StiHeaderBand", "Name": "HeaderBand1", "ClientRectangle": "0,42,276.9,10", "Interaction": { "Ident": "StiInteraction", "SortingEnabled": false }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text5", "ClientRectangle": "0,0,16,8", "Interaction": { "Ident": "StiInteraction", "SortingEnabled": false, "SortingColumn": "{DataBand1.BorrowerNumber}" }, "Text": { "Value": "Borrower\r\nNumber" }, "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text6", "Guid": "6f07b165684941dd9cc29025688bf54f", "ClientRectangle": "16,4,39,4", "Interaction": { "Ident": "StiInteraction", "SortingEnabled": false, "SortingColumn": "{DataBand1.BorrowerName}" }, "Text": { "Value": "Borrower Name" }, "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text9", "Guid": "4574eb2f443145a89af1db9620767800", "ClientRectangle": "119,0,16,8", "Conditions": { "0": { "Ident": "StiCondition", "DataType": "Numeric", "Column": "CurrentBalanceReportData.AgreementNumber", "Value1": "0", "Enabled": false, "TextColor": "0,0,0", "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction", "SortingEnabled": false, "SortingColumn": "{DataBand1.AgreementNumber}" }, "Text": { "Value": "Agreement\r\nNumber" }, "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text16", "Guid": "7727f50a9f4544a397f391ee0f4b1f73", "ClientRectangle": "174,4,21,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Initiation Fee" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text18", "Guid": "b12615c3a36a40f6824a7308fa826ba8", "ClientRectangle": "195,4,21,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Service Fee" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text19", "Guid": "f899aaf64bd4486e8aaf32cb30c06313", "ClientRectangle": "216,4,17,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Insurance" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "6": { "Ident": "StiText", "Name": "Text20", "Guid": "e143f608ec3d4789a6ad798b04c61769", "ClientRectangle": "233,4,15,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "VAT" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text21", "Guid": "b0704782f5624a2e86ac73e382699b5d", "ClientRectangle": "248,4,28,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Current Balance" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text45", "Guid": "2cc7eb8de251421eba3a0f4b421f6660", "ClientRectangle": "136,4,18,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Capital" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "9": { "Ident": "StiText", "Name": "Text46", "Guid": "b7059a54ecee40dda7f8f20f93c46f07", "ClientRectangle": "154,4,20,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Interest" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "10": { "Ident": "StiText", "Name": "Text14", "Guid": "74e37a6d8c884daba8bf2eebc652ea69", "ClientRectangle": "58,4,33,4", "Interaction": { "Ident": "StiInteraction", "SortingEnabled": false, "SortingColumn": "{DataBand1.BorrowerName}" }, "Text": { "Value": "Employer Name" }, "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "11": { "Ident": "StiText", "Name": "Text22", "Guid": "7e1cc7be59314b1baae42e570d6f6d07", "ClientRectangle": "91,4,28,4", "Interaction": { "Ident": "StiInteraction", "SortingEnabled": false, "SortingColumn": "{DataBand1.BorrowerName}" }, "Text": { "Value": "Product Name" }, "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "12": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive1", "ClientRectangle": "0,8,276,0.254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" } }, "PrintIfEmpty": true }, "4": { "Ident": "StiGroupHeaderBand", "Name": "GroupHeaderBand1", "ClientRectangle": "0,60,276.9,6", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text33", "ClientRectangle": "0,0,61,5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{CurrentBalanceReportData.Branch}" }, "Font": "Calibri;10;Bold, Italic;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black" } }, "Condition": { "Value": "{CurrentBalanceReportData.Branch}" } }, "5": { "Ident": "StiGroupHeaderBand", "Name": "GroupHeaderBand2", "ClientRectangle": "0,74,276.9,5", "Interaction": { "Ident": "StiBandInteraction" }, "Border": "Bottom;;;Dot;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text44", "ClientRectangle": "0,0,81,5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{CurrentBalanceReportData.AgreementStatus}" }, "Font": "Calibri;10;Bold, Italic;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "DataColumn" } }, "Condition": { "Value": "{CurrentBalanceReportData.AgreementStatus}" } }, "6": { "Ident": "StiDataBand", "Name": "DataBand1", "ClientRectangle": "0,87,276.9,4", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text11", "ClientRectangle": "15,0,40,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{CurrentBalanceReportData.BorrowerName1} {CurrentBalanceReportData.Surname}" }, "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text12", "ClientRectangle": "119,0,15,4", "Conditions": { "0": { "Ident": "StiCondition", "DataType": "Numeric", "Column": "CurrentBalanceReportData.AgreementNumber", "Value1": "0", "Enabled": false, "TextColor": "0,0,0", "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{CurrentBalanceReportData.AgreementNumber}" }, "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "DataColumn" }, "2": { "Ident": "StiText", "Name": "Text17", "ClientRectangle": "134,0,20,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{CurrentBalanceReportData.Capital}" }, "HorAlignment": "Right", "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," } }, "3": { "Ident": "StiText", "Name": "Text26", "Guid": "68956ddd572a4c90ac6059da1ee64b40", "ClientRectangle": "216,0,17,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{CurrentBalanceReportData.Insurance}" }, "HorAlignment": "Right", "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "DataColumn" }, "4": { "Ident": "StiText", "Name": "Text27", "Guid": "4e55ec9a72dd46d5870501851146ffb4", "ClientRectangle": "233,0,15,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{CurrentBalanceReportData.Vat}" }, "HorAlignment": "Right", "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "DataColumn" }, "5": { "Ident": "StiText", "Name": "Text7", "ClientRectangle": "0,0,16,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{CurrentBalanceReportData.Number}" }, "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black" }, "6": { "Ident": "StiText", "Name": "Text23", "ClientRectangle": "174,0,21,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{CurrentBalanceReportData.InitiationFee}" }, "HorAlignment": "Right", "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," } }, "7": { "Ident": "StiText", "Name": "Text25", "ClientRectangle": "195,0,21,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{CurrentBalanceReportData.ServiceFee}" }, "HorAlignment": "Right", "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "DataColumn" }, "8": { "Ident": "StiText", "Name": "Text10", "Guid": "58d2d3669a90489886fdb70cef88bbe5", "ClientRectangle": "248,0,28,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{CurrentBalanceReportData.CurrentBalance}" }, "HorAlignment": "Right", "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "DataColumn" }, "9": { "Ident": "StiText", "Name": "Text47", "Guid": "f682651c5eea4a12b70bf554c5f5ed66", "ClientRectangle": "154,0,20,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{CurrentBalanceReportData.Interest}" }, "HorAlignment": "Right", "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "DataColumn" }, "10": { "Ident": "StiText", "Name": "Text15", "ClientRectangle": "57,0,34,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{CurrentBalanceReportData.EmployerName}" }, "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "DataColumn" }, "11": { "Ident": "StiText", "Name": "Text48", "ClientRectangle": "90,0,29,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{CurrentBalanceReportData.ProductName}" }, "Font": "Calibri;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "DataColumn" } }, "BusinessObjectGuid": "0b0bfa94a2e847918428f57733d851f6", "Sort": { "0": "ASC", "1": "BorrowerNumber", "2": "ASC", "3": "AgreementNumber" } }, "7": { "Ident": "StiGroupFooterBand", "Name": "GroupFooterBand1", "ClientRectangle": "0,99,276.9,5", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text34", "ClientRectangle": "36,0,93,5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Totals for {CurrentBalanceReportData.Branch}:" }, "HorAlignment": "Right", "Font": "Calibri;;Bold, Italic;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text37", "ClientRectangle": "130,0,24,5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(GroupHeaderBand1,CurrentBalanceReportData.Capital)}" }, "HorAlignment": "Right", "Font": "Calibri;;Bold, Italic;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "Totals" }, "2": { "Ident": "StiText", "Name": "Text38", "ClientRectangle": "154,0,20,5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(GroupHeaderBand1,CurrentBalanceReportData.Interest)}" }, "HorAlignment": "Right", "Font": "Calibri;;Bold, Italic;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "Totals" }, "3": { "Ident": "StiText", "Name": "Text39", "ClientRectangle": "174,0,21,5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(GroupHeaderBand1,CurrentBalanceReportData.InitiationFee)}" }, "HorAlignment": "Right", "Font": "Calibri;;Bold, Italic;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "Totals" }, "4": { "Ident": "StiText", "Name": "Text40", "ClientRectangle": "196,0,20,5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(GroupHeaderBand1,CurrentBalanceReportData.ServiceFee)}" }, "HorAlignment": "Right", "Font": "Calibri;;Bold, Italic;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "Totals" }, "5": { "Ident": "StiText", "Name": "Text41", "ClientRectangle": "216,0,17,5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(GroupHeaderBand1,CurrentBalanceReportData.Insurance)}" }, "HorAlignment": "Right", "Font": "Calibri;;Bold, Italic;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "Totals" }, "6": { "Ident": "StiText", "Name": "Text42", "ClientRectangle": "233,0,15,5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(GroupHeaderBand1,CurrentBalanceReportData.Vat)}" }, "HorAlignment": "Right", "Font": "Calibri;;Bold, Italic;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "Totals" }, "7": { "Ident": "StiText", "Name": "Text43", "ClientRectangle": "248,0,28,5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(GroupHeaderBand1,CurrentBalanceReportData.CurrentBalance)}" }, "HorAlignment": "Right", "Font": "Calibri;;Bold, Italic;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "Totals" } } }, "8": { "Ident": "StiFooterBand", "Name": "FooterBand1", "ClientRectangle": "0,112,276.9,10", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text30", "Guid": "374b024205e54e1db2cb576a102fbd17", "ClientRectangle": "0,4,28,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Number of Borrowers: " }, "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text31", "Guid": "ad1c1b586f2b4278ac0eb003bf72ee5f", "ClientRectangle": "110,4,18,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Grand Total:" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text8", "Guid": "e452577289cb4a938fb186ee12f3f5a9", "ClientRectangle": "28,4,32,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{CountDistinct(DataBand1,CurrentBalanceReportData.Number)}" }, "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Totals" }, "3": { "Ident": "StiText", "Name": "Text28", "Guid": "f9b22b390aa249abbd9c4c8c1418c647", "ClientRectangle": "131,4,23,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1,CurrentBalanceReportData.Capital)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "Totals" }, "4": { "Ident": "StiText", "Name": "Text29", "Guid": "5643a952faae4b09852f9e095f197f59", "ClientRectangle": "154,4,20,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1,CurrentBalanceReportData.Interest)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "Totals" }, "5": { "Ident": "StiText", "Name": "Text35", "Guid": "82658fb279134532ac24cca301ac1eca", "ClientRectangle": "216,4,17,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1,CurrentBalanceReportData.Insurance)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "Totals" }, "6": { "Ident": "StiText", "Name": "Text36", "Guid": "8eb5674938cf4ce689730f9b3752f05a", "ClientRectangle": "233,4,15,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1,CurrentBalanceReportData.Vat)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "Totals" }, "7": { "Ident": "StiText", "Name": "Text24", "Guid": "e55f48bb14044ed9bc6f869159bd4ef3", "ClientRectangle": "174,4,21,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1,CurrentBalanceReportData.InitiationFee)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "Totals" }, "8": { "Ident": "StiText", "Name": "Text32", "Guid": "5b27a391f1ba4edb89e9ef7393d2a54c", "ClientRectangle": "196,4,20,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1,CurrentBalanceReportData.ServiceFee)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "Totals" }, "9": { "Ident": "StiText", "Name": "Text13", "Guid": "40a5ecc1816947cf9ae462e918aa5c43", "ClientRectangle": "248,4,28,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1,CurrentBalanceReportData.CurrentBalance)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "Totals" }, "10": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive2", "ClientRectangle": "0,4,276,0.254", "Interaction": { "Ident": "StiInteraction" }, "Style": "Double", "StartCap": ";;;", "EndCap": ";;;" } }, "PrintIfEmpty": true } }, "PaperSize": "A4", "Orientation": "Landscape", "PageWidth": 296.9, "PageHeight": 210.1, "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 10.0, "Right": 10.0, "Top": 10.0, "Bottom": 10.0 } } } }