0 SQL ="data source=" & Parameters!ReportSvr.Value & "; Initial Catalog=" & Parameters!ReportDB.Value true Integrated fe9c23f3-e1a2-44b0-aa25-537197463476 GatcsDB =Parameters!dFROM.Value =Parameters!dTO.Value =Parameters!TDLIST.Value =Parameters!BILLYR.Value =Parameters!BILLTYPE.Value SELECT P.PAYMENTDATE , P.REGISTER , P.PAYMENTKEY , P.PAYMENT_TYPE , P.PAID_BY AS PAID_BY , 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 , O.LASTNAME , O.ADDRESS1 , O.ADDRESS2 , O.ADDRESS3 , O.CITY , O.STATE , O.ZIP , A.TAXDISTRIC , P.TOTAL AS PAYMENT_AMT , B.BALANCE_DUE , A.PARCEL_NO 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 INNER JOIN vPROPERTY A ON A.PROPERTYKEY=B.PROPERTYKEY AND A.DIGYR=B.BILL_YEAR AND A.PROPTYPE=B.BILL_TYPE LEFT JOIN VOWNER O ON O.BILL_NO=B.BILL_NO AND O.BILL_YEAR=B.BILL_YEAR AND O.BILL_TYPE=B.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') AND A.TAXDISTRIC IN (@TDLIST) AND P.BILL_YEAR IN (@BILLYR) AND P.BILL_TYPE IN (@BILLTYPE) ORDER BY P.PAYMENTDATE true PAYMENTDATE System.DateTime REGISTER System.Int32 PAYMENTKEY System.Int32 PAYMENT_TYPE System.String PAID_BY System.String COMMENTS System.String CNUM System.Decimal CASH_AMT System.Decimal CHECK_AMT System.Decimal CHARGE_AMT System.Decimal CONAME System.String CHANGE_AMT System.Decimal OVERAGES_AMT System.Decimal BILL_NO System.Int32 BILL_YEAR System.Int16 CHECK_CHANGE System.Decimal CHECK_OVERAGE System.Decimal LASTNAME System.String ADDRESS1 System.String ADDRESS2 System.String ADDRESS3 System.String CITY System.String STATE System.String ZIP System.String TAXDISTRIC System.String PAYMENT_AMT System.Decimal BALANCE_DUE System.Decimal PARCEL_NO System.String GatcsDB SELECT * FROM TAXDIST RECID System.Int32 TAXDISTRIC System.String DESCRIP System.String HEAVYEQUIP System.Int32 MOTORVEH System.Int32 MOBILEHOME System.Int32 TIMBER100 System.Int32 INC_UNINC System.String CO_FP_RM System.Decimal CO_FP_FG System.Decimal CO_FP_OS System.Decimal CI_FP_RM System.Decimal CI_FP_FG System.Decimal CI_FP_OS System.Decimal HECOUNT System.Int32 MVCOUNT System.Int32 MHCOUNT System.Int32 TICOUNT System.Int32 CO_FP_FF System.Decimal CO_FP_R2 System.Decimal CI_FP_FF System.Decimal CI_FP_R2 System.Decimal FULFILL_PERC System.Decimal RETAIL2_PERC System.Decimal FULFILL_PERC_CITY System.Decimal RETAIL2_PERC_CITY System.Decimal TAD System.Boolean TAD_TAXTYPE System.Int32 GatcsDB SELECT DISTINCT BILL_YEAR FROM VBILL ORDER BY BILL_YEAR DESC true BILL_YEAR System.Int16 1in 0.67708in 0.71875in 3.10417in 1in 1in 0.22in true true PAYMENTDATE SteelBlue 2pt 2pt 2pt 2pt true true BILL NO textbox3 SteelBlue 2pt 2pt 2pt 2pt true true BILL YEAR textbox4 SteelBlue 2pt 2pt 2pt 2pt true true LASTNAME SteelBlue 2pt 2pt 2pt 2pt true true PAYMENT AMT textbox6 SteelBlue 2pt 2pt 2pt 2pt true true BALANCE DUE textbox7 SteelBlue 2pt 2pt 2pt 2pt 0.2in true true =Fields!PAYMENTDATE.Value Black 1pt 2pt 2pt 2pt 2pt true true =Fields!BILL_NO.Value Black 1pt 2pt 2pt 2pt 2pt true true =Fields!BILL_YEAR.Value Black 1pt 2pt 2pt 2pt 2pt true true =Fields!LASTNAME.Value Black 1pt 2pt 2pt 2pt 2pt true true =Fields!PAYMENT_AMT.Value Black 1pt 2pt 2pt 2pt 2pt true true =Fields!BALANCE_DUE.Value Black 1pt 2pt 2pt 2pt 2pt 0.2in true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true =Fields!ADDRESS1.Value 2pt 2pt 2pt 2pt true true 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 2pt 2pt 2pt 2pt true true =Fields!ADDRESS2.Value 2pt 2pt 2pt 2pt true true 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 2pt 2pt 2pt 2pt true true =Fields!ADDRESS3.Value 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt 0.2in true true ="PIN: " & trim(Fields!PARCEL_NO.Value) 2pt 2pt 2pt 2pt 3 true true =trim(Fields!CITY.Value) & " " & Fields!STATE.Value & " " & Fields!ZIP.Value 2pt 2pt 2pt 2pt true true ="TD: " & Fields!TAXDISTRIC.Value 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt 0.2in true true Count Textbox8 LightGreen 2pt 2pt 2pt 2pt true true =count(Fields!BILL_NO.Value) LightGreen 2pt 2pt 2pt 2pt true true LightGreen 2pt 2pt 2pt 2pt true true Totals Textbox11 LightGreen 2pt 2pt 2pt 2pt true true =Sum(Fields!PAYMENT_AMT.Value) LightGreen 2pt 2pt 2pt 2pt true true LightGreen 2pt 2pt 2pt 2pt After true true Detail =len(trim(Fields!ADDRESS1.Value))=0 =len(trim(Fields!ADDRESS2.Value))=0 =len(trim(Fields!ADDRESS3.Value))=0 Detail_Collection Output true Before DataSet1 1.42in 7.5in true true =Parameters!dFROM.Value & " to " & Parameters!dTO.Value Textbox40 0.36in 0.25in 7.5in 1 2pt 2pt 2pt 2pt 0.36458in true true true true =Globals!ExecutionTime 2pt 2pt 2pt 2pt 0.5in 0.5in 0.5in 0.5in