0 SQL ="data source=" & Parameters!ReportSvr.Value & "; Initial Catalog=" & Parameters!ReportDB.Value true Integrated fc2a17c7-7a1b-4a2b-998f-10c3d1300893 GatcsDB =Parameters!dFROM.Value =Parameters!dTO.Value =Parameters!REGLIST.Value SELECT P.PAYMENTDATE , P.REGISTER , P.PAYMENTKEY , P.PAYMENT_TYPE , P.PAID_BY AS LASTNAME , LEFT(B.COMMENTS,40) AS COMMENTS , P.CNUM , CASE WHEN P.PAYMENT_TYPE='CASH' THEN P.TOTAL ELSE 0.00 END AS CASH_AMT , CASE WHEN P.PAYMENT_TYPE IN ('CHECK','MONEY ORDER') THEN P.PAID_AMT ELSE 0.00 END AS CHECK_AMT , CASE WHEN P.PAYMENT_TYPE NOT IN ('CASH','CHECK','MONEY ORDER') THEN P.PAID_AMT ELSE 0.00 END AS CHARGE_AMT , D.CONAME , ISNULL(P.CHANGE,0) AS CHANGE_AMT , ISNULL(P.OVERAGES,0) AS OVERAGES_AMT , B.BILL_NO , B.BILL_YEAR , CASE WHEN P.PAYMENT_TYPE='CHECK' THEN P.CHANGE ELSE 0 END AS CHECK_CHANGE , CASE WHEN P.PAYMENT_TYPE='CHECK' THEN P.OVERAGES ELSE 0 END AS CHECK_OVERAGE , U.APPRNAME FROM VPAYMENT P INNER JOIN VBILL B ON B.BILL_NO = P.BILL_NO AND B.BILL_YEAR=P.BILL_YEAR AND B.BILL_TYPE=P.BILL_TYPE LEFT JOIN USERS U ON U.REGISTER=P.REGISTER LEFT JOIN DEFAULTS D ON 1=1 WHERE CONVERT(DATE,P.PAYMENTDATE) BETWEEN @dFROM AND @dTO AND P.PAYMENT_TYPE NOT IN ('REFUND','WRITE-OFF') AND P.REGISTER IN (@REGLIST) ORDER BY P.PAYMENTDATE true PAYMENTKEY System.Int32 LASTNAME System.String COMMENTS System.String CNUM System.Decimal PAYMENT_TYPE System.String CASH_AMT System.Decimal CHECK_AMT System.Decimal PAYMENTDATE System.DateTime CHARGE_AMT System.Decimal REGISTER System.Int32 CONAME System.String CHANGE_AMT System.Decimal BILL_NO System.Int32 OVERAGES_AMT System.Decimal BILL_YEAR System.Int16 CHECK_CHANGE System.Decimal CHECK_OVERAGE System.Decimal APPRNAME System.String GatcsDB SELECT CONVERT(DATE,GETDATE()) AS TODAY true TODAY System.DateTime GatcsDB SELECT DISTINCT REGISTER FROM VPAYMENT ORDER BY REGISTER REGISTER System.Int32 0.51124in 0.51124in 0.5in 1.29166in 1.42292in 0.8in 0.8in 0.8in 0.8in 0.2in true =Fields!PAYMENTKEY.Value Black 1pt 2pt 2pt 2pt 2pt true true =Fields!BILL_NO.Value & vbCRLF & Fields!BILL_YEAR.Value 2pt 2pt 2pt 2pt true =Fields!PAYMENT_TYPE.Value & vbCRLF & Fields!CNUM.Value PAYMENT_TYPE 2pt 2pt 2pt 2pt true true =Fields!PAYMENTDATE.Value PAYMENTDATE Black 1pt 2pt 2pt 2pt 2pt true =Fields!LASTNAME.Value LASTNAME Black 1pt 2pt 2pt 2pt 2pt true =Fields!CASH_AMT.Value Black 1pt 2pt 2pt 2pt 2pt true true =Fields!CHANGE_AMT.Value+Fields!OVERAGES_AMT.Value Black 1pt 2pt 2pt 2pt 2pt true =Fields!CHECK_AMT.Value Black 1pt 2pt 2pt 2pt 2pt true =Fields!CHARGE_AMT.Value Black 1pt 2pt 2pt 2pt 2pt 0.2in true true Register Black 1pt 2pt 2pt 2pt 2pt 2 true true =Avg(Fields!REGISTER.Value) Textbox3367 Black 1pt 2pt 2pt 2pt 2pt true true =Fields!APPRNAME.Value APPRNAME Black 1pt 2pt 2pt 2pt 2pt true true Textbox159 Black 1pt 2pt 2pt 2pt 2pt true true =Sum(Fields!CASH_AMT.Value) Black 1pt 2pt 2pt 2pt 2pt true true =Sum(Fields!CHANGE_AMT.Value+Fields!OVERAGES_AMT.Value) Black 1pt 2pt 2pt 2pt 2pt true true =Sum(Fields!CHECK_AMT.Value) Black 1pt 2pt 2pt 2pt 2pt true true =Sum(Fields!CHARGE_AMT.Value) Black 1pt 2pt 2pt 2pt 2pt 0.2in true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true Textbox43 2pt 2pt 2pt 2pt true true Textbox44 2pt 2pt 2pt 2pt true true Textbox49 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true =Sum(Fields!CHANGE_AMT.Value) 2pt 2pt 2pt 2pt true true Change 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt 0.2in true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true Textbox57 2pt 2pt 2pt 2pt true true Textbox58 2pt 2pt 2pt 2pt true true Textbox59 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true =Sum(Fields!OVERAGES_AMT.Value) 2pt 2pt 2pt 2pt true true true Overpay 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt 0.2in true true Total Black 1pt 2pt 2pt 2pt 2pt true true Black 1pt 2pt 2pt 2pt 2pt true true =count(Fields!REGISTER.Value) Textbox3368 Black 1pt 2pt 2pt 2pt 2pt true true Textbox16 Black 1pt 2pt 2pt 2pt 2pt true true Textbox96 Black 1pt 2pt 2pt 2pt 2pt true true Black 1pt 2pt 2pt 2pt 2pt true true Black 1pt 2pt 2pt 2pt 2pt true true Black 1pt 2pt 2pt 2pt 2pt true true =sum(Fields!CASH_AMT.Value) + sum(Fields!CHECK_AMT.Value) + sum(Fields!CHARGE_AMT.Value) Black 1pt 2pt 2pt 2pt 2pt 0.2in true true Black 3pt PaleTurquoise 2pt 2pt 2pt 2pt true true Black 3pt PaleTurquoise 2pt 2pt 2pt 2pt true true Textbox42 Black 3pt PaleTurquoise 2pt 2pt 2pt 2pt true true Textbox18 Black 3pt PaleTurquoise 2pt 2pt 2pt 2pt true true Textbox159 Black 3pt PaleTurquoise 2pt 2pt 2pt 2pt true true =Sum(Fields!CASH_AMT.Value) Black 3pt PaleTurquoise 2pt 2pt 2pt 2pt true true =Sum(Fields!CHANGE_AMT.Value+Fields!OVERAGES_AMT.Value) Black 3pt PaleTurquoise 2pt 2pt 2pt 2pt true true =Sum(Fields!CHECK_AMT.Value) Black 3pt PaleTurquoise 2pt 2pt 2pt 2pt true true =Sum(Fields!CHARGE_AMT.Value) Black 3pt PaleTurquoise 2pt 2pt 2pt 2pt 0.25in true true PaleTurquoise 2pt 2pt 2pt 2pt true true PaleTurquoise 2pt 2pt 2pt 2pt true true Textbox6 true PaleTurquoise 2pt 2pt 2pt 2pt true true Textbox7 true PaleTurquoise 2pt 2pt 2pt 2pt true true Textbox8 true PaleTurquoise 2pt 2pt 2pt 2pt true true PaleTurquoise 2pt 2pt 2pt 2pt true true Check Chg PaleTurquoise 2pt 2pt 2pt 2pt true true =Sum(Fields!CHECK_CHANGE.Value) PaleTurquoise 2pt 2pt 2pt 2pt true true PaleTurquoise 2pt 2pt 2pt 2pt 0.2in true true PaleTurquoise 2pt 2pt 2pt 2pt true true PaleTurquoise 2pt 2pt 2pt 2pt true true Textbox35 true PaleTurquoise 2pt 2pt 2pt 2pt true true Textbox36 true PaleTurquoise 2pt 2pt 2pt 2pt true true Textbox37 true PaleTurquoise 2pt 2pt 2pt 2pt true true PaleTurquoise 2pt 2pt 2pt 2pt true true Check Over PaleTurquoise 2pt 2pt 2pt 2pt true true =Sum(Fields!CHECK_OVERAGE.Value) PaleTurquoise 2pt 2pt 2pt 2pt true true PaleTurquoise 2pt 2pt 2pt 2pt 0.25in true true PaleTurquoise 2pt 2pt 2pt 2pt true true PaleTurquoise 2pt 2pt 2pt 2pt true true Textbox22 true PaleTurquoise 2pt 2pt 2pt 2pt true true Textbox23 true PaleTurquoise 2pt 2pt 2pt 2pt true true Textbox24 true PaleTurquoise 2pt 2pt 2pt 2pt true true PaleTurquoise 2pt 2pt 2pt 2pt true true Net Checks PaleTurquoise 2pt 2pt 2pt 2pt true true =Sum(Fields!CHECK_AMT.Value-Fields!CHECK_CHANGE.Value*Fields!CHECK_OVERAGE.Value) PaleTurquoise 2pt 2pt 2pt 2pt true true PaleTurquoise 2pt 2pt 2pt 2pt 0.2in true true Final Total Black 3pt LightGreen 2pt 2pt 2pt 2pt 2 true true =count(Fields!REGISTER.Value) REGISTER Black 3pt LightGreen 2pt 2pt 2pt 2pt true true Textbox19 Black 3pt LightGreen 2pt 2pt 2pt 2pt true true Textbox96 Black 3pt LightGreen 2pt 2pt 2pt 2pt true true =Sum(Fields!OVERAGES_AMT.Value) Black 3pt LightGreen 2pt 2pt 2pt 2pt true true OVERPAY Black 3pt LightGreen 2pt 2pt 2pt 2pt true true Black 3pt LightGreen 2pt 2pt 2pt 2pt true true =sum(Fields!CASH_AMT.Value) + sum(Fields!CHECK_AMT.Value) + sum(Fields!CHARGE_AMT.Value) Black 3pt LightGreen 2pt 2pt 2pt 2pt =Fields!REGISTER.Value =Fields!REGISTER.Value Detail true Textbox94 Detail_Collection Output true Before Before Before Before true true DataSet1 2.1in 7.43706in textbox1 0.04167in 2.19444in 0.36in 3.51056in true true =Globals!ExecutionTime ExecutionTime 0.04167in 0.20833in 2.09375in 1 2pt 2pt 2pt 2pt true true ="Page " & Globals!PageNumber & " of " & Globals!TotalPages PageNumber 5.92456in 0.25in 1.44792in 2 2pt 2pt 2pt 2pt true true ="From :" & FormatDateTime(Parameters!dFROM.Value, DateFormat.ShortDate) & " To :" & FormatDateTime(Parameters!dTO.Value, DateFormat.ShortDate) FROM 0.42945in 2.3904in 0.25in 2.86458in 3 2pt 2pt 2pt 2pt true true Trans# Textbox3363 0.80729in 0.25in 0.51124in 4 SteelBlue 2pt 2pt 2pt 2pt true true P Type Textbox3364 0.80729in 1.02248in 0.25in 0.5in 5 SteelBlue 2pt 2pt 2pt 2pt true true Payment Date Textbox12 0.80729in 1.52248in 0.25in 1.29166in 6 SteelBlue 2pt 2pt 2pt 2pt true true Paid By Textbox9 0.80729in 2.81414in 0.25in 1.42292in 7 SteelBlue 2pt 2pt 2pt 2pt true true Cash Amt Textbox1 0.80729in 4.23706in 0.25in 0.8in 8 SteelBlue 2pt 2pt 2pt 2pt true true Over / Chg * Textbox44 0.80729in 5.03706in 0.25in 0.8in 9 SteelBlue 2pt 2pt 2pt 2pt true true Check Amt Textbox43 0.80729in 5.83706in 0.25in 0.8in 10 SteelBlue 2pt 2pt 2pt 2pt true true Charge Amt Textbox4 0.80729in 6.63706in 0.25in 0.8in 11 SteelBlue 2pt 2pt 2pt 2pt true true Bill # Textbox3363 0.80729in 0.51124in 0.25in 0.51124in 12 SteelBlue 2pt 2pt 2pt 2pt 0.5in 0.5in 0.5in 0.5in