DB_Conn w1pl62JLQ81ieO3cSwCiTtVw9athBdLZYUmxiWFxpBfVfpuDYgVR7WJf/YRNXCRe0SibyclxafDh TT2Yag2iKvVW+yvoS0OZ4mr9AHUcbUaCdssJ3QPzdW9M7ak= DB_Conn aInit cc,System.String 30 aInit DB_Conn declare @iversion varchar(20) set @iversion = {iVersion} select stuff((SELECT cc_list FROM [Accounting].[Version] WHERE version_id=@iversion), patindex((SELECT cc_list FROM [Accounting].[Version] WHERE version_id=@iversion), 'cc_id') + 1, 5, 'b.cc_id') as cc; DataSource1 acc_no,System.String acc_name,System.String beginning,System.Decimal debit,System.Decimal credit,System.Decimal ending,System.Decimal type,System.String col1,System.String col2,System.String col3,System.String 30 DataSource1 DB_Conn declare @Year int,@Month int,@AccNo varchar(20) set @Year={iYear} set @Month={iMonth}; set @AccNo=ltrim(rtrim('{iAccNo}')) ------------------------------------------------------- declare @Period int select @Period = @Year*12+@Month, @AccNo=@AccNo+'%' select q2.acc_name as col1, q3.acc_name as col2, q4.acc_name as col3, q1.* from ( select ltrim(rtrim(a.acc_no)) as acc_no,a.acc_name,sum(beginning) as beginning,sum(debit) as debit,sum(credit) as credit, sum(beginning)+sum(debit)-sum(credit) as [ending], CASE WHEN a.acc_journal=1 THEN 'D' ELSE 'T' END as type from Accounting.COA a inner join ( select isnull(a.acc_no,b.acc_no) as acc_no,isnull(beginning,0) as beginning,isnull(debit,0) as debit,isnull(credit,0) as credit from ( select acc_no,isnull(sum(gl_Debit),0) as debit,isnull(SUM(gl_credit),0) as credit from Accounting.[Journal.Detail] a inner join Accounting.[Journal.Header] b on a.hdr_id = b.hdr_id where b.gl_period = @Period and acc_no like @AccNo and {aInit.cc} group by acc_no ) a full join ( select acc_no,isnull(sum(gl_value),0) as beginning from Accounting.[Journal.Detail] a inner join Accounting.[Journal.Header] b on a.hdr_id = b.hdr_id where b.gl_period < @Period and acc_no like @AccNo and {aInit.cc} group by acc_no ) b on a.acc_no=b.acc_no ) b on b.acc_no like rtrim(a.acc_no)+'%' where a.acc_no like @AccNo group by a.acc_no,a.acc_name,a.acc_journal ) q1 inner join Accounting.COA q2 on left(q1.acc_no,1) = q2.acc_no inner join Accounting.COA q3 on left(q1.acc_no,2) = q3.acc_no inner join Accounting.COA q4 on left(q1.acc_no,3) = q4.acc_no where len(q1.acc_no) > 3 order by q1.acc_no ,iYear,iYear,System.String,_x0032_013,False,False ,iMonth,iMonth,System.String,_x0031_1,False,False ,iAccNo,iAccNo,System.String,,False,False ,iVersion,iVersion,System.String,_x0031_,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,0.8 Transparent 0.2,0,7.2,0.6 Arial,10 d80a0734a0fede453cde98a326d4dd3a 0,0,0,0 Text31 PT. Sumber Multiplast Utama Black Expression Transparent 16.4,0,2.6,0.6 Arial,8 f3c0b729beaa6a03611498a326d4bbd1 Right 0,0,0,0 Text28 {PageNofM} Black SystemVariables PageHeaderBand1 Transparent 0,2,19,1.2 Transparent 6.6,0,6,0.6 Arial,14,Underline c13a3117b17ee66aa35798a326d41eb0 Center 0,0,0,0 Text30 Ledger Mutation Black Expression Transparent 6.6,0.6,6,0.4 Arial,10 9db5a382985d97aa610898a326d4aa86 Center 0,0,0,0 Text12 {Switch(iMonth=="01", "January",iMonth=="02", "February",iMonth=="03", "March",iMonth=="04", "April",iMonth=="05", "May",iMonth=="06", "June",iMonth=="07", "July",iMonth=="08", "August",iMonth=="09", "September",iMonth=="10", "October",iMonth=="11", "November",iMonth=="12", "December")} {iYear} Black Expression ReportTitleBand1 Transparent 0,4,19,0.4 Transparent True 0,0,4.8,0.4 Arial,8,Bold 7cba5099574dc813f0f698a326d4bc03 0,0,0,0 Text32 {DataSource1.col1} Black DataColumn Transparent True 7,0,3,0.4 Arial,8 adccefd385d2f640f1e598a326d4a5fa Right 0,0,0,0 Text15 {Sum(DataBand1,DataSource1.beginning)} Black , 0 False Expression Transparent True 10,0,3,0.4 Arial,8 6d7a5a82358efe0e76a398a326d4adf1 Right 0,0,0,0 Text21 {Sum(DataBand1,DataSource1.debit)} Black , 0 False Expression Transparent True 13,0,3,0.4 Arial,8 ba2c5fc77dabbf3ca93598a326d419d4 Right 0,0,0,0 Text14 {Sum(DataBand1,DataSource1.credit)} Black , 0 False Expression Transparent True 16,0,3,0.4 Arial,8 8dec8fe55a6b947627ea98a326d42be2 Right 0,0,0,0 Text18 {Sum(DataBand1,DataSource1.ending)} Black , 0 False Totals {DataSource1.col1} GroupHeaderBand1 None Transparent 0,5.2,19,0.4 Transparent True 0.2,0,4.8,0.4 Arial,8,Bold cf58c63d48bc9c281edb98a326d446b7 0,0,0,0 Text19 {DataSource1.col2} Black DataColumn Transparent True 7,0,3,0.4 Arial,8 5cc30fb661ed8bd35d8198a326d406d3 Right 0,0,0,0 Text16 {Sum(DataBand1,DataSource1.beginning)} Black , 0 False Expression Transparent True 10,0,3,0.4 Arial,8 35cf2f1ef3414533b17198a326d46bf7 Right 0,0,0,0 Text25 {Sum(DataBand1,DataSource1.debit)} Black , 0 False Expression Transparent True 13,0,3,0.4 Arial,8 f049bc30b008965db27598a326d4ecd0 Right 0,0,0,0 Text20 {Sum(DataBand1,DataSource1.credit)} Black , 0 False Expression Transparent True 16,0,3,0.4 Arial,8 848cc736e0f7f12849d998a326d430f0 Right 0,0,0,0 Text22 {Sum(DataBand1,DataSource1.ending)} Black , 0 False Totals {DataSource1.col2} GroupHeaderBand2 Transparent 0,6.4,19,0.4 Transparent True 0.4,0,4.8,0.4 Arial,8,Bold aa4332cfb728bd0d8e0598a326d40801 0,0,0,0 Text23 {DataSource1.col3} Black DataColumn Transparent True 7,0,3,0.4 Arial,8 833dfab23a2f645a646b98a326d5ad85 Right 0,0,0,0 Text17 {Sum(DataBand1,DataSource1.beginning)} Black , 0 False Expression Transparent True 10,0,3,0.4 Arial,8 6355e8cf31e6c49f388e98a326d5ca8a Right 0,0,0,0 Text29 {Sum(DataBand1,DataSource1.debit)} Black , 0 False Expression Transparent True 13,0,3,0.4 Arial,8 eeb8cee197be4092fb3898a326d59303 Right 0,0,0,0 Text24 {Sum(DataBand1,DataSource1.credit)} Black , 0 False Expression Transparent True 16,0,3,0.4 Arial,8 c338aa23ddc0348cce6298a326d52a05 Right 0,0,0,0 Text26 {Sum(DataBand1,DataSource1.ending)} Black , 0 False Totals {DataSource1.col3} GroupHeaderBand3 Transparent 0,7.6,19,0.6 Transparent 0.6,0,1.6,0.6 Arial,10 b1acf1974338439e174398a326d5ba44 0,0,0,0 Text27 Account Black Expression Center Transparent 2.2,0,4.8,0.6 Arial,10 0c455036a54c5369cda898a326d53611 0,0,0,0 Text3 Name Black Expression Center Transparent 7,0,3,0.6 Arial,10 75b26997978541bbc6cd98a326d547fd Right 0,0,0,0 Text5 Beg. Balance Black Expression Center Transparent 10,0,3,0.6 Arial,10 e57031d4c25100da4e8998a326d5394b Right 0,0,0,0 Text7 Debit Black Expression Center Transparent 13,0,3,0.6 Arial,10 f85f934564e9cade9cec98a326d5c16a Right 0,0,0,0 Text9 Credit Black Expression Center Transparent 16,0,3,0.6 Arial,10 3d232e96a4c73acc751c98a326d58b87 Right 0,0,0,0 Text11 End. Balance Black Expression Center 0,0,19,0.0254 Black Black 5af70dc039a45782ca1498a326d57358 HorizontalLinePrimitive3 Black 0,0.6,19,0.0254 Black Black bdd1e6facded4d4d936498a326d53f99 HorizontalLinePrimitive1 Black HeaderBand1 Transparent 0,9,19,0.4 Transparent True 0.6,0,1.6,0.4 Arial,8 4218f2f26b987115490798a326d5c9b6 0,0,0,0 Text13 {DataSource1.acc_no} Black Transparent True 2.2,0,4.8,0.4 Arial,8 284234eac47b9be62ece98a326d5b36f 0,0,0,0 Text1 {DataSource1.acc_name} Black Transparent True 7,0,3,0.4 Arial,8 72c76f38ee9d3d54885a98a326d55ff8 Right 0,0,0,0 Text2 {DataSource1.beginning} Black , 0 False Transparent True 10,0,3,0.4 Arial,8 7b90e839b4cadf79ea7f98a326d5d12b Right 0,0,0,0 Text4 {DataSource1.debit} Black , 0 False DataColumn Transparent True 13,0,3,0.4 Arial,8 9b42e9ab85191025d9ef98a326d51cc1 Right 0,0,0,0 Text6 {DataSource1.credit} Black , 0 False DataColumn Transparent True 16,0,3,0.4 Arial,8 bf25182fd388187976a798a326d59b83 Right 0,0,0,0 Text8 {DataSource1.ending} Black , 0 False DataColumn DataSource1 DataBand1 35e98a18701cb1167a7e989e966b2796 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] Report 01/16/2014 08:17:07 AM 01/16/2014 08:16:06 AM f0a460db69d38df11688989f854212b4 Report Centimeters 2013.1.1600 CSharp