{ "ReportVersion": "2024.4.5", "ReportGuid": "c619562f952c98887cf13605ae3fe3a6", "ReportName": "Report", "ReportAlias": "Report", "ReportFile": "rptLEDGERREPORT.mrt", "ReportCreated": "/Date(0+0530)/", "ReportChanged": "/Date(1733487085000+0530)/", "EngineVersion": "EngineV2", "ReportUnit": "Millimeters", "ScriptLanguage": "CSharp", "CalculationMode": "Interpretation", "Dictionary": { "Variables": { "0": { "Name": "FromDate", "Alias": "FromDate", "Type": "System.String" }, "1": { "Name": "ToDate", "Alias": "ToDate", "Type": "System.String" }, "2": { "Value": "''", "Name": "PGROUPBY1", "Alias": "PGROUPBY1", "Type": "System.String" }, "3": { "Value": "0", "Name": "RunningBalance", "Alias": "RunningBalance", "Type": "System.Double" } }, "DataSources": { "0": { "Ident": "StiDataTableSource", "Name": "DT_COMPANYMASTER", "Alias": "DT_COMPANYMASTER", "Columns": { "0": { "Name": "Comp_Name", "NameInSource": "Comp_Name", "Alias": "Comp_Name", "Type": "System.String" }, "1": { "Name": "Group_Name", "NameInSource": "Group_Name", "Alias": "Group_Name", "Type": "System.String" }, "2": { "Name": "Address1", "NameInSource": "Address1", "Alias": "Address1", "Type": "System.String" }, "3": { "Name": "Address2", "NameInSource": "Address2", "Alias": "Address2", "Type": "System.String" }, "4": { "Name": "Country_Name", "NameInSource": "Country_Name", "Alias": "Country_Name", "Type": "System.String" }, "5": { "Name": "State_Name", "NameInSource": "State_Name", "Alias": "State_Name", "Type": "System.String" }, "6": { "Name": "City_Name", "NameInSource": "City_Name", "Alias": "City_Name", "Type": "System.String" }, "7": { "Name": "Pin_No", "NameInSource": "Pin_No", "Alias": "Pin_No", "Type": "System.String" }, "8": { "Name": "Mobile_No", "NameInSource": "Mobile_No", "Alias": "Mobile_No", "Type": "System.String" }, "9": { "Name": "Phone_No", "NameInSource": "Phone_No", "Alias": "Phone_No", "Type": "System.String" }, "10": { "Name": "Email", "NameInSource": "Email", "Alias": "Email", "Type": "System.String" }, "11": { "Name": "Website", "NameInSource": "Website", "Alias": "Website", "Type": "System.String" }, "12": { "Name": "GST_TIN_NO", "NameInSource": "GST_TIN_NO", "Alias": "GST_TIN_NO", "Type": "System.String" }, "13": { "Name": "PAN_No", "NameInSource": "PAN_No", "Alias": "PAN_No", "Type": "System.String" }, "14": { "Name": "AddharNo", "NameInSource": "AddharNo", "Alias": "AddharNo", "Type": "System.String" }, "15": { "Name": "Acc_BankName", "NameInSource": "Acc_BankName", "Alias": "Acc_BankName", "Type": "System.String" }, "16": { "Name": "Acc_Bank_Branch", "NameInSource": "Acc_Bank_Branch", "Alias": "Acc_Bank_Branch", "Type": "System.String" }, "17": { "Name": "Acc_ACNo", "NameInSource": "Acc_ACNo", "Alias": "Acc_ACNo", "Type": "System.String" }, "18": { "Name": "Acc_IFSC", "NameInSource": "Acc_IFSC", "Alias": "Acc_IFSC", "Type": "System.String" }, "19": { "Name": "EwayId", "NameInSource": "EwayId", "Alias": "EwayId", "Type": "System.String" }, "20": { "Name": "EwayPass", "NameInSource": "EwayPass", "Alias": "EwayPass", "Type": "System.String" }, "21": { "Name": "GstrId", "NameInSource": "GstrId", "Alias": "GstrId", "Type": "System.String" }, "22": { "Name": "GstrPass", "NameInSource": "GstrPass", "Alias": "GstrPass", "Type": "System.String" }, "23": { "Name": "BusinessType", "NameInSource": "BusinessType", "Alias": "BusinessType", "Type": "System.String" }, "24": { "Name": "Company_Logo", "NameInSource": "Company_Logo", "Alias": "Company_Logo", "Type": "System.Byte[]" } }, "NameInSource": "DsLedgerPrint.DT_COMPANYMASTER" }, "1": { "Ident": "StiDataTableSource", "Name": "DataTable1", "Alias": "DataTable1", "Columns": { "0": { "Name": "MDate", "NameInSource": "MDate", "Alias": "MDate", "Type": "System.DateTime" }, "1": { "Name": "PARTYNAME", "NameInSource": "PARTYNAME", "Alias": "PARTYNAME", "Type": "System.String" }, "2": { "Name": "ACCOUNTNAME", "NameInSource": "ACCOUNTNAME", "Alias": "ACCOUNTNAME", "Type": "System.String" }, "3": { "Name": "BROKERNAME", "NameInSource": "BROKERNAME", "Alias": "BROKERNAME", "Type": "System.String" }, "4": { "Name": "CITYNAME", "NameInSource": "CITYNAME", "Alias": "CITYNAME", "Type": "System.String" }, "5": { "Name": "AREANAME", "NameInSource": "AREANAME", "Alias": "AREANAME", "Type": "System.String" }, "6": { "Name": "CHEQUEBILLNO", "NameInSource": "CHEQUEBILLNO", "Alias": "CHEQUEBILLNO", "Type": "System.String" }, "7": { "Name": "REMARKS", "NameInSource": "REMARKS", "Alias": "REMARKS", "Type": "System.String" }, "8": { "Name": "DEBIT", "NameInSource": "DEBIT", "Alias": "DEBIT", "Type": "System.Double" }, "9": { "Name": "CREDIT", "NameInSource": "CREDIT", "Alias": "CREDIT", "Type": "System.Double" }, "10": { "Name": "Address", "NameInSource": "Address", "Alias": "Address", "Type": "System.String" }, "11": { "Name": "EFROM", "NameInSource": "EFROM", "Alias": "EFROM", "Type": "System.String" }, "12": { "Name": "VNO", "NameInSource": "VNO", "Alias": "VNO", "Type": "System.String" }, "13": { "Name": "Ord", "NameInSource": "Ord", "Alias": "Ord", "Type": "System.Int32" }, "14": { "Name": "GROUPNAME", "NameInSource": "GROUPNAME", "Alias": "GROUPNAME", "Type": "System.String" }, "15": { "Name": "MAINGROUPNAME", "NameInSource": "MAINGROUPNAME", "Alias": "MAINGROUPNAME", "Type": "System.String" }, "16": { "Name": "InOut", "NameInSource": "InOut", "Alias": "InOut", "Type": "System.String" }, "17": { "Name": "Annexture", "NameInSource": "Annexture", "Alias": "Annexture", "Type": "System.Int32" }, "18": { "Name": "GSTINNO", "NameInSource": "GSTINNO", "Alias": "GSTINNO", "Type": "System.String" }, "19": { "Name": "PANNO", "NameInSource": "PANNO", "Alias": "PANNO", "Type": "System.String" }, "20": { "Name": "ACCOUNTID", "NameInSource": "ACCOUNTID", "Alias": "ACCOUNTID", "Type": "System.Int32" }, "21": { "Name": "RunningBalance", "NameInSource": "RunningBalance", "Alias": "RunningBalance", "Type": "System.String" }, "22": { "Name": "CRDR", "NameInSource": "CRDR", "Alias": "CRDR", "Type": "System.String" } }, "NameInSource": "DsLedgerPrint.DataTable1" }, "2": { "Ident": "StiDataTableSource", "Name": "VariableList", "Alias": "VariableList", "Columns": { "0": { "Name": "FromDate", "NameInSource": "FromDate", "Alias": "FromDate", "Type": "System.String" }, "1": { "Name": "ToDate", "NameInSource": "ToDate", "Alias": "ToDate", "Type": "System.String" } }, "NameInSource": "DsLedgerPrint" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Page1", "Guid": "27fbd621f5a94412afcaa4015bc95e7c", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiPageHeaderBand", "Name": "PageHeaderBand1", "PrintOn": "OnlyFirstPage", "CanGrow": true, "ClientRectangle": "0,4,197.3,24", "Interaction": { "Ident": "StiInteraction" }, "Border": "All;;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text2", "ClientRectangle": "0,0,197,6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DT_COMPANYMASTER.Comp_Name}" }, "VertAlignment": "Center", "Font": "Times New Roman;12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black" }, "1": { "Ident": "StiText", "Name": "Text5", "Guid": "e62f6d894fd44af281e5765bd91047ec", "ClientRectangle": "0,18,197,6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Ledger Report From Date : {FromDate} To {ToDate}" }, "VertAlignment": "Center", "Font": ";9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiDateFormatService", "StringFormat": "dd/MM/yyyy" }, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text69", "Guid": "4a21809b9a944b5e9f0109b7dd1c3e80", "CanGrow": true, "ClientRectangle": "0,6,189,12", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DT_COMPANYMASTER.Address1}\nPh :- {DT_COMPANYMASTER.Mobile_No},{DT_COMPANYMASTER.Phone_No}" }, "Font": "Times New Roman;11;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "3": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive8", "Guid": "2b0561217d3b4bef8501f2d5a1749435", "ClientRectangle": "0,0,197.2,0.254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" } } }, "1": { "Ident": "StiPageFooterBand", "Name": "PageFooterBand1", "CanGrow": true, "ClientRectangle": "0,276.3,197.3,8", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text30", "Guid": "8c65303008554241b1d6e9f49cb362c4", "ClientRectangle": "167,0,30,6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{PageNofM}" }, "HorAlignment": "Right", "Font": "Times New Roman;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "SystemVariables" } } }, "2": { "Ident": "StiGroupHeaderBand", "Name": "GroupHeaderBand1", "CanGrow": true, "ClientRectangle": "0,36,197.3,2", "BeforePrintEvent": { "Script": "RunningBalance=0" }, "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "SortDirection": "None", "Condition": { "Value": "{Switch( PGROUPBY1== \"BROKER1\",DataTable1.BROKERNAME,\n\t\tPGROUPBY1== \"CITY\",DataTable1.CITYNAME,\n\t\tPGROUPBY1== \"AREA\",DataTable1.AREANAME,\n\t\tPGROUPBY1== \"ACCOUNGROUP\",DataTable1.GROUPNAME,\n\t\tPGROUPBY1== \"\",\"\"\n)}" } }, "3": { "Ident": "StiGroupHeaderBand", "Name": "GroupHeaderBand2", "CanGrow": true, "ClientRectangle": "0,46,197.3,16", "BeforePrintEvent": { "Script": "RunningBalance=0" }, "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text22", "Guid": "6ca93ce1ac4949b0a8783016a123e139", "ClientRectangle": "0,12,20,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Date" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text24", "Guid": "124feb8516b24007a2ffa63d8e3f5497", "ClientRectangle": "20,12,25,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Cheq/Bill No" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": ";9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text25", "Guid": "33c2034fb288491795a87e19471c8e0b", "ClientRectangle": "45,12,72,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "A/c Name" }, "VertAlignment": "Center", "Font": ";9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text27", "Guid": "8550593d22014feca2b1ab68e00b5556", "ClientRectangle": "142,12,25,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Credit" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text28", "Guid": "5d35d9bddb344626be23e8cc536fe2b1", "ClientRectangle": "167,12,30,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Balance" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text29", "ClientRectangle": "117,12,25,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Debit" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "6": { "Ident": "StiText", "Name": "Text14", "ClientRectangle": "20,0,122,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataTable1.PARTYNAME} ({DataTable1.GROUPNAME})" }, "Font": ";9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression", "ExcelValue": { "Value": "{DataTable1.PARTYNAME}" } }, "7": { "Ident": "StiText", "Name": "Text15", "ClientRectangle": "0,0,20,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Acc Name :" }, "Font": ";9;Bold;", "Border": ";255,242,0;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text19", "Guid": "d0e97cf1c5154d17b703dd491a022c6f", "CanGrow": true, "ClientRectangle": "20,4,122,8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataTable1.Address}" }, "Font": ";9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "9": { "Ident": "StiText", "Name": "Text10", "Guid": "08ae543fd15c42c78ac2fbabbc246dd9", "ClientRectangle": "0,4,20,8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Address :" }, "Font": ";9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "10": { "Ident": "StiText", "Name": "Text36", "Guid": "ed8f1d83ff8d4f2fa45af008ff6d4b9b", "ClientRectangle": "142,0,25,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "GSTIN NO :" }, "HorAlignment": "Right", "Font": ";9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "11": { "Ident": "StiText", "Name": "Text37", "Guid": "9013ba615e9b4519ae5290ab0b7bb6f0", "ClientRectangle": "142,4,25,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "PAN NO :" }, "HorAlignment": "Right", "Font": ";9;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "12": { "Ident": "StiText", "Name": "Text38", "Guid": "e1fc1ecea7da4e49a02aa7d1eec64510", "ClientRectangle": "167,0,30,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataTable1.GSTINNO}" }, "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "13": { "Ident": "StiText", "Name": "Text39", "Guid": "524219b0e1934b2c8ada9b83b35e5023", "ClientRectangle": "167,4,30,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataTable1.PANNO}" }, "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "14": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive2", "Guid": "08fdd4e1e549436ebdbbace2028f1dee", "ClientRectangle": "0,16,197.2,0.254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "15": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive1", "ClientRectangle": "0,12,197.2,0.254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" } }, "SortDirection": "None", "Condition": { "Value": "{DataTable1.ACCOUNTID}" } }, "4": { "Ident": "StiDataBand", "Name": "DataBand1", "CanGrow": true, "ClientRectangle": "0,70,197.3,4", "BeforePrintEvent": { "Script": "RunningBalance = RunningBalance + DataTable1.DEBIT-DataTable1.CREDIT" }, "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text31", "Guid": "9eca5cb2c38540bbbd455478f29584da", "CanGrow": true, "ClientRectangle": "20,0,25,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataTable1.CHEQUEBILLNO}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "TextFormat": { "Ident": "StiDateFormatService", "StringFormat": "dd/MM/yyyy" }, "Type": "Expression", "ExcelValue": { "Value": "{DataTable1.CHEQUEBILLNO}" } }, "1": { "Ident": "StiText", "Name": "Text32", "Guid": "e7b9787ab09f4d79afed5c83076342e2", "CanGrow": true, "ClientRectangle": "45,0,72,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataTable1.ACCOUNTNAME}\n{DataTable1.REMARKS}" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "TextFormat": { "Ident": "StiDateFormatService", "StringFormat": "dd/MM/yyyy" }, "Type": "Expression", "ExcelValue": { "Value": "{Switch(DataTable1.REMARKS== \"\",DataTable1.ACCOUNTNAME,\nDataTable1.REMARKS!= \"\", DataTable1.ACCOUNTNAME +\"-\"+ DataTable1.REMARKS\n)}\n" } }, "2": { "Ident": "StiText", "Name": "Text34", "Guid": "ea541a1a5c544e5faca1d3b80bf5b17b", "ClientRectangle": "117,0,25,4", "Interaction": { "Ident": "StiInteraction" }, "HideZeros": true, "Text": { "Value": "{Switch(DataTable1.ACCOUNTNAME== \"OPENING\",0,\n DataTable1.ACCOUNTNAME!= \"OPENING\",DataTable1.DEBIT\n)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCustomFormatService", "StringFormat": "#,##,##,##,##,###.00" }, "Type": "Expression", "ExcelValue": { "Value": "{Switch(DataTable1.ACCOUNTNAME== \"OPENING\",0,\n DataTable1.ACCOUNTNAME!= \"OPENING\",DataTable1.DEBIT\n)}" } }, "3": { "Ident": "StiText", "Name": "Text11", "Guid": "91130769bbbc49e78001225e6c69a391", "ClientRectangle": "142,0,25,4", "Interaction": { "Ident": "StiInteraction" }, "HideZeros": true, "Text": { "Value": "{Switch(DataTable1.ACCOUNTNAME== \"OPENING\",0,\n DataTable1.ACCOUNTNAME!= \"OPENING\",DataTable1.CREDIT\n)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCustomFormatService", "StringFormat": "#,##,##,##,##,###.00" }, "Type": "Expression", "ExcelValue": { "Value": "{Switch(DataTable1.ACCOUNTNAME== \"OPENING\",0,\n DataTable1.ACCOUNTNAME!= \"OPENING\",DataTable1.CREDIT\n)}" } }, "4": { "Ident": "StiText", "Name": "Text12", "Guid": "e06e54b0728d4a1d96f552af22c288a6", "ClientRectangle": "167,0,30,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataTable1.RunningBalance} {DataTable1.CRDR}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "AllowHtmlTags": true, "TextFormat": { "Ident": "StiCustomFormatService", "StringFormat": "#,##,##,##,##,###.00" }, "Type": "Expression", "ExcelValue": { "Value": "{Switch(RunningBalance> 0,RunningBalance.ToString(\"#,##,##,##,##,###.00\") +\" Dr\",\n RunningBalance< 0, (RunningBalance*-1).ToString(\"#,##,##,##,##,###.00\") +\" Cr\"\n)}" } }, "5": { "Ident": "StiText", "Name": "Text23", "Guid": "c8b1452c53e343e29b223fbdb151f9c9", "ClientRectangle": "0,0,20,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataTable1.MDate}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiDateFormatService", "StringFormat": "dd/MM/yyyy" }, "Type": "Expression", "ExcelValue": { "Value": "{DataTable1.MDate}" } }, "6": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive9", "Guid": "41c5618a372e4fa593354d644f106806", "ClientRectangle": "0,4,197.2,0.254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" } }, "DataSourceName": "DataTable1", "Sort": { "0": "ASC", "1": "MAINGROUPNAME", "2": "ASC", "3": "GROUPNAME", "4": "ASC", "5": "PARTYNAME", "6": "ASC", "7": "ACCOUNTID", "8": "ASC", "9": "MDate", "10": "ASC", "11": "VNO" } }, "5": { "Ident": "StiGroupFooterBand", "Name": "GroupFooterBand2", "CanGrow": true, "ClientRectangle": "0,82,197.3,13", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text16", "Guid": "164f55bbe1474c6e9ec642eecf5fa006", "ClientRectangle": "117,0,25,4", "Interaction": { "Ident": "StiInteraction" }, "HideZeros": true, "Text": { "Value": "{Sum(GroupHeaderBand2,Switch(DataTable1.ACCOUNTNAME== \"OPENING\",0,\n\t\tDataTable1.ACCOUNTNAME!= \"OPENING\",DataTable1.DEBIT\n\t\t))}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCustomFormatService", "StringFormat": "#,##,##,##,##,###.00" }, "Type": "Expression", "ExcelValue": { "Value": "{Sum(GroupHeaderBand2,Switch(DataTable1.ACCOUNTNAME== \"OPENING\",0,\n\t\tDataTable1.ACCOUNTNAME!= \"OPENING\",DataTable1.DEBIT\n\t\t))}" } }, "1": { "Ident": "StiText", "Name": "Text17", "Guid": "616360674ed04e209a75048dda2b6fd7", "ClientRectangle": "142,0,25,4", "Interaction": { "Ident": "StiInteraction" }, "HideZeros": true, "Text": { "Value": "{Sum(GroupHeaderBand2,Switch(DataTable1.ACCOUNTNAME== \"OPENING\",0,\n\t\tDataTable1.ACCOUNTNAME!= \"OPENING\",DataTable1.CREDIT\n\t\t))}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCustomFormatService", "StringFormat": "#,##,##,##,##,###.00" }, "Type": "Expression", "ExcelValue": { "Value": "{Sum(GroupHeaderBand2,Switch(DataTable1.ACCOUNTNAME== \"OPENING\",0,\n\t\tDataTable1.ACCOUNTNAME!= \"OPENING\",DataTable1.CREDIT\n\t\t))}" } }, "2": { "Ident": "StiText", "Name": "Text18", "Guid": "ffbf2dc122bd4411a453e6bd9ad4d23a", "ClientRectangle": "167,4,30,4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Switch(RunningBalance> 0,RunningBalance.ToString(\"#,##,##,##,##,###.00\") +\" Dr\",\n RunningBalance< 0, (RunningBalance*-1).ToString(\"#,##,##,##,##,###.00\") +\" Cr\",\n RunningBalance== 0, \"0.00\"\n)}" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCustomFormatService", "StringFormat": "#,##,##,##,##,###.00" }, "Type": "Expression", "ExcelValue": { "Value": "{Switch(RunningBalance> 0,RunningBalance.ToString(\"#,##,##,##,##,###.00\") +\" Dr\",\n RunningBalance< 0, (RunningBalance*-1).ToString(\"#,##,##,##,##,###.00\") +\" Cr\",\n RunningBalance== 0, \"0.00\"\n)}" } }, "3": { "Ident": "StiText", "Name": "Text20", "Guid": "3cf850cb31294c6999a093b248c65165", "ClientRectangle": "117,4,50,4", "Interaction": { "Ident": "StiInteraction" }, "HideZeros": true, "Text": { "Value": "Closing Balance :" }, "HorAlignment": "Right", "VertAlignment": "Center", "Font": ";;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCustomFormatService", "StringFormat": "#,##,##,##,##,###.00" }, "Type": "Expression" }, "4": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive4", "Guid": "f18ef3040d764ebaadffd8188443d700", "ClientRectangle": "0,8,197.2,0.254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" } } }, "6": { "Ident": "StiGroupFooterBand", "Name": "GroupFooterBand1", "CanGrow": true, "ClientRectangle": "0,103,197.3,1", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:" } }, "PaperSize": "A4", "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 6.35, "Right": 6.35, "Top": 6.35, "Bottom": 6.35 } } } }