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 SELECT CONVERT(DATE,P.PAYMENTDATE) AS PAYMENTDATE , SUM( CASE WHEN P.PAYMENT_TYPE='CASH' THEN P.TOTAL ELSE 0.00 END ) AS CASH_AMT , SUM( CASE WHEN P.PAYMENT_TYPE IN ('CHECK','MONEY ORDER') THEN P.PAID_AMT ELSE 0.00 END ) AS CHECK_AMT , SUM( CASE WHEN P.PAYMENT_TYPE IN ('CREDIT_CARD') THEN P.PAID_AMT ELSE 0.00 END ) AS CREDITCARD_AMT , SUM( CASE WHEN P.PAYMENT_TYPE LIKE 'WEB%' THEN P.PAID_AMT ELSE 0.00 END ) AS WEB_AMT , SUM( CASE WHEN P.PAYMENT_TYPE LIKE 'CHECK' THEN P.CHANGE ELSE 0.00 END ) AS CK_CHG , SUM( 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 DEPOSIT_AMT , D.CONAME 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 DEFAULTS D ON 1=1 WHERE CONVERT(DATE,P.PAYMENTDATE) BETWEEN @dFROM AND @dTO AND P.PAYMENT_TYPE NOT IN ('REFUND','WRITE-OFF') GROUP BY D.CONAME, CONVERT(DATE,P.PAYMENTDATE) ORDER BY PAYMENTDATE true PAYMENTDATE System.DateTime CASH_AMT System.Decimal CHECK_AMT System.Decimal CREDITCARD_AMT System.Decimal WEB_AMT System.Decimal CK_CHG System.Decimal DEPOSIT_AMT System.Decimal CONAME System.String GatcsDB SELECT CONVERT(DATE,GETDATE()) AS TODAY true TODAY System.DateTime 1.64063in 1.06771in 1.06771in 0.48624in 1.06771in 1.06771in 1.06771in 0.25in true true PAYMENTDATE LightBlue 2pt 2pt 2pt 2pt true true CASH AMT LightBlue 2pt 2pt 2pt 2pt true true CHECK AMT LightBlue 2pt 2pt 2pt 2pt true true CK CHG LightBlue 2pt 2pt 2pt 2pt true true CREDIT CARD POS AMT LightBlue 2pt 2pt 2pt 2pt true true WEB AMT LightBlue 2pt 2pt 2pt 2pt true true DEPOSIT AMT LightBlue 2pt 2pt 2pt 2pt 0.25in true true =Fields!PAYMENTDATE.Value 2pt 2pt 2pt 2pt true true =Fields!CASH_AMT.Value-Fields!CK_CHG.Value 2pt 2pt 2pt 2pt true true =Fields!CHECK_AMT.Value 2pt 2pt 2pt 2pt true true =Fields!CK_CHG.Value 2pt 2pt 2pt 2pt true true =Fields!CREDITCARD_AMT.Value 2pt 2pt 2pt 2pt true true =Fields!WEB_AMT.Value 2pt 2pt 2pt 2pt true true =Fields!DEPOSIT_AMT.Value-Fields!CK_CHG.Value 2pt 2pt 2pt 2pt 0.25in true true LightGreen 2pt 2pt 2pt 2pt true true =Sum(Fields!CASH_AMT.Value)-sum(Fields!CK_CHG.Value) LightGreen 2pt 2pt 2pt 2pt true true true =Sum(Fields!CHECK_AMT.Value) LightGreen 2pt 2pt 2pt 2pt true true =Sum(Fields!CK_CHG.Value) LightGreen 2pt 2pt 2pt 2pt true true =Sum(Fields!CREDITCARD_AMT.Value) LightGreen 2pt 2pt 2pt 2pt true true =Sum(Fields!WEB_AMT.Value) LightGreen 2pt 2pt 2pt 2pt true true =Sum(Fields!DEPOSIT_AMT.Value)-sum(Fields!CK_CHG.Value) LightGreen 2pt 2pt 2pt 2pt After Before DataSet1 0.75in 7.46542in 0.75in textbox1 0.04167in 1.81944in 0.36in 3.51056in true true =Globals!ExecutionTime ExecutionTime 0.04167in 0.20833in 1.79167in 1 2pt 2pt 2pt 2pt true true ="Page " & Globals!PageNumber & " of " & Globals!TotalPages PageNumber 5.54956in 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.0154in 0.25in 2.86458in 3 2pt 2pt 2pt 2pt 0.5in 0.5in 0.5in 0.5in