0 SQL ="data source=" & Parameters!ReportSvr.Value & "; Initial Catalog=" & Parameters!ReportDB.Value true Integrated 49157853-902a-4140-909d-18c6f5c14103 GatcsDB =Parameters!DFROM.Value =Parameters!DTO.Value =Parameters!REGLIST.Value SELECT PAID_BY , PAYMENTDATE , CNUM , TOTAL , PAID_AMT , CHECK_TOTAL , BILL_TYPE , BILL_YEAR , BILL_NO , CONVERT(VARCHAR(10),CONVERT(DATE,PAYMENTDATE),21)+CONVERT(CHAR(20),CNUM)+LTRIM(RTRIM(PAID_BY)) AS XGROUP , REGISTER , ROW_NUMBER() OVER( PARTITION BY CONVERT(VARCHAR(10),CONVERT(DATE,PAYMENTDATE),21)+CONVERT(CHAR(20),CNUM)+LTRIM(RTRIM(PAID_BY)) ORDER BY BILL_NO) AS ROWID , IIF(ROW_NUMBER() OVER( PARTITION BY CONVERT(VARCHAR(10),CONVERT(DATE,PAYMENTDATE),21)+CONVERT(CHAR(20),CNUM)+LTRIM(RTRIM(PAID_BY)) ORDER BY BILL_NO)=1,CHECK_TOTAL,0) AS CK_TOTAL FROM VPAYMENT WHERE PAYMENT_TYPE='CHECK' AND CONVERT(DATE,PAYMENTDATE) BETWEEN @DFROM AND @DTO AND REGISTER IN (@REGLIST) ORDER BY PAYMENTDATE, CNUM true PAID_BY System.String PAYMENTDATE System.DateTime CNUM System.Decimal TOTAL System.Decimal PAID_AMT System.Decimal CHECK_TOTAL System.Decimal BILL_TYPE System.String BILL_YEAR System.Int16 XGROUP System.String BILL_NO System.Int32 REGISTER System.Int32 ROWID System.Int64 CK_TOTAL System.Decimal GatcsDB SELECT DISTINCT REGISTER FROM PAYMENT ORDER BY REGISTER REGISTER System.Int32 0.78125in 1in 1in 0.39583in 0.5in 0.76042in 1in 1in 1in 0.22917in 0.22in true true DATE SteelBlue 2pt 2pt 2pt 2pt true true CNUM textbox5 SteelBlue 2pt 2pt 2pt 2pt true true PAID BY SteelBlue 2pt 2pt 2pt 2pt true true BILL TYPE SteelBlue 2pt 2pt 2pt 2pt true true BILL YEAR textbox8 SteelBlue 2pt 2pt 2pt 2pt true true BILL NO Textbox25 SteelBlue 2pt 2pt 2pt 2pt true true TOTAL textbox9 SteelBlue 2pt 2pt 2pt 2pt true true PAID AMT textbox10 SteelBlue 2pt 2pt 2pt 2pt true true CHECK TOTAL textbox11 SteelBlue 2pt 2pt 2pt 2pt true true Textbox2 2pt 2pt 2pt 2pt 0.25in true true Black 1pt White 2pt 2pt 2pt 2pt true true Black 1pt White 2pt 2pt 2pt 2pt true true Black 1pt White 2pt 2pt 2pt 2pt true true Black 1pt White 2pt 2pt 2pt 2pt true true Black 1pt White 2pt 2pt 2pt 2pt true true Black 1pt White 2pt 2pt 2pt 2pt true true Black 1pt White 2pt 2pt 2pt 2pt true true Black 1pt White 2pt 2pt 2pt 2pt true true Black 1pt White 2pt 2pt 2pt 2pt true true White 2pt 2pt 2pt 2pt 0.21in true true =Fields!PAYMENTDATE.Value Black 1pt White 2pt 2pt 2pt 2pt true true =AVG(Fields!CNUM.Value) Black 1pt White 2pt 2pt 2pt 2pt true true =Fields!PAID_BY.Value Black 1pt White 2pt 2pt 2pt 2pt 2 true true =COUNT(Fields!BILL_YEAR.Value) Black 1pt White 2pt 2pt 2pt 2pt true true Items Black 1pt White 2pt 2pt 2pt 2pt true true Black 1pt White 2pt 2pt 2pt 2pt true true =Sum(Fields!PAID_AMT.Value) Black 1pt White 2pt 2pt 2pt 2pt true true =Sum(Fields!CK_TOTAL.Value) 2pt 2pt 2pt 2pt true true =IIF(REPORTITEMS!PAID_AMT1.Value<>REPORTITEMS!CK_TOTAL.VALUE,"**","") 2pt 2pt 2pt 2pt true 0.21in true 2pt 2pt 2pt 2pt true true ="Reg:" & Fields!REGISTER.Value 2pt 2pt 2pt 2pt true 2pt 2pt 2pt 2pt true =Fields!BILL_TYPE.Value 2pt 2pt 2pt 2pt true =Fields!BILL_YEAR.Value 2pt 2pt 2pt 2pt true =Fields!BILL_NO.Value 2pt 2pt 2pt 2pt true =Fields!TOTAL.Value 2pt 2pt 2pt 2pt true =Fields!PAID_AMT.Value 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt 0.25in true true Black 1pt LightGreen 2pt 2pt 2pt 2pt true true Black 1pt LightGreen 2pt 2pt 2pt 2pt true true Black 1pt LightGreen 2pt 2pt 2pt 2pt true true Black 1pt LightGreen 2pt 2pt 2pt 2pt true true Black 1pt LightGreen 2pt 2pt 2pt 2pt true true Black 1pt LightGreen 2pt 2pt 2pt 2pt true true Black 1pt LightGreen 2pt 2pt 2pt 2pt true true =Sum(Fields!PAID_AMT.Value) Black 1pt LightGreen 2pt 2pt 2pt 2pt true true =Sum(Fields!CK_TOTAL.Value) LightGreen 2pt 2pt 2pt 2pt true true LightGreen 2pt 2pt 2pt 2pt 1in true true REGISTER SteelBlue 2pt 2pt 2pt 2pt true After true =Fields!REGISTER.Value =Fields!REGISTER.Value 1in true true =Fields!REGISTER.Value Black 1pt White 2pt 2pt 2pt 2pt After =Fields!XGROUP.Value =Fields!XGROUP.Value After true Detail Detail_Collection Output true 1in true true Total Black 1pt LightGreen 2pt 2pt 2pt 2pt Before DataSet1 1.14in 8.66667in true true =Globals!ExecutionTime ExecutionTime 0.42944in 0.25in 3.17708in 1 2pt 2pt 2pt 2pt true true ="Page " & Globals!PageNumber PageNumber 0.42944in 7.30208in 0.25in 1in 2 2pt 2pt 2pt 2pt 8.5in 11in 0.5in 0.5in 0.5in 0.5in