0 SQL ="data source=" & Parameters!ReportSvr.Value & "; Initial Catalog=" & Parameters!ReportDB.Value true Integrated f3dbe301-20b9-4312-9bc1-2bdc095f5814 GatcsDB =Parameters!PAYEE.Value =Parameters!STARTDATE.Value =Parameters!ENDDATE.Value =Parameters!CURR_YEAR.Value SELECT (SELECT SUM(CREDIT-DEBIT)--, COUNT(*) AS CY_PROPERTY FROM GENERAL_LEDGER G INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND G.PAYMENTKEY=P.PAYMENTKEY WHERE ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE REPLACE(CHECK_PAYEE,CHAR(13)+CHAR(10),'') = @PAYEE) AND CONVERT(DATE,TRANS_DATE) BETWEEN @STARTDATE AND @ENDDATE AND G.BILL_YEAR >= @CURR_YEAR AND (ISNULL(G.INTEREST,0)=0 or (ISNULL(G.INTEREST,0)=1 and ISNULL(G.COMMISSION,0)=1)) AND P.BILL_TYPE IN ('R','P') AND ACCT_CODE NOT IN (8001) AND G.COMMISSION=0 AND ISNULL(G.PENALTY,0)=0 ) PROPERTY_CURRENT , (SELECT SUM(CREDIT-DEBIT) AS PY_PROPERTY FROM GENERAL_LEDGER G INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND G.PAYMENTKEY=P.PAYMENTKEY WHERE ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE REPLACE(CHECK_PAYEE,CHAR(13)+CHAR(10),'') = @PAYEE) AND CONVERT(DATE,TRANS_DATE) BETWEEN @STARTDATE AND @ENDDATE AND G.BILL_YEAR < @CURR_YEAR AND (ISNULL(G.INTEREST,0)=0 or (ISNULL(G.INTEREST,0)=1 and ISNULL(G.COMMISSION,0)=1)) AND P.BILL_TYPE IN ('R','P') AND ACCT_CODE NOT IN (8001) AND G.COMMISSION=0 AND ISNULL(G.PENALTY,0)=0 ) PROPERTY_PRIOR , (SELECT SUM(CREDIT-DEBIT) AS PEN_INT FROM GENERAL_LEDGER G INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND G.PAYMENTKEY=P.PAYMENTKEY WHERE (((SELECT PENALTY2CITIES FROM DEFAULTS2)=1 AND G.PENALTY=1 OR G.ACCT_CODE=8001) OR ISNULL(G.INTEREST,0)=1) AND ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE REPLACE(CHECK_PAYEE,CHAR(13)+CHAR(10),'') = @PAYEE) AND CONVERT(DATE,TRANS_DATE) BETWEEN @STARTDATE AND @ENDDATE AND P.BILL_TYPE IN ('R','P') AND G.COMMISSION=0 ) PROPERTY_PEN_INT , (SELECT SUM(CREDIT-DEBIT) AS TIMB FROM GENERAL_LEDGER G INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND G.PAYMENTKEY=P.PAYMENTKEY WHERE ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE REPLACE(CHECK_PAYEE,CHAR(13)+CHAR(10),'') = @PAYEE) AND CONVERT(DATE,TRANS_DATE) BETWEEN @STARTDATE AND @ENDDATE AND ISNULL(G.PENALTY,0)=0 AND ISNULL(G.INTEREST,0)=0 AND P.BILL_TYPE IN ('T') AND ACCT_CODE NOT IN (8001) AND G.COMMISSION=0 ) TIMBER , (SELECT SUM(CREDIT-DEBIT) AS PEN_INT FROM GENERAL_LEDGER G INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND G.PAYMENTKEY=P.PAYMENTKEY WHERE (((SELECT PENALTY2CITIES FROM DEFAULTS2)=1 AND G.PENALTY=1 OR G.ACCT_CODE=8001) OR ISNULL(G.INTEREST,0)=1) AND ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE REPLACE(CHECK_PAYEE,CHAR(13)+CHAR(10),'') = @PAYEE) AND CONVERT(DATE,TRANS_DATE) BETWEEN @STARTDATE AND @ENDDATE AND P.BILL_TYPE IN ('T') AND G.COMMISSION=0 ) TIMBER_PEN_INT , (SELECT SUM(CREDIT-DEBIT) AS MH FROM GENERAL_LEDGER G INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND G.PAYMENTKEY=P.PAYMENTKEY WHERE ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE REPLACE(CHECK_PAYEE,CHAR(13)+CHAR(10),'') = @PAYEE) AND CONVERT(DATE,TRANS_DATE) BETWEEN @STARTDATE AND @ENDDATE AND ISNULL(G.PENALTY,0)=0 AND ISNULL(G.INTEREST,0)=0 AND P.BILL_TYPE IN ('M') AND ACCT_CODE NOT IN (8001) AND G.COMMISSION=0 ) MH , (SELECT SUM(CREDIT-DEBIT) AS PEN_INT FROM GENERAL_LEDGER G INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND G.PAYMENTKEY=P.PAYMENTKEY WHERE (((SELECT PENALTY2CITIES FROM DEFAULTS2)=1 AND G.PENALTY=1 OR G.ACCT_CODE=8001) OR ISNULL(G.INTEREST,0)=1) AND ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE REPLACE(CHECK_PAYEE,CHAR(13)+CHAR(10),'') = @PAYEE) AND CONVERT(DATE,TRANS_DATE) BETWEEN @STARTDATE AND @ENDDATE AND P.BILL_TYPE IN ('M') AND G.COMMISSION=0 ) MH_PEN_INT , (SELECT SUM(CREDIT-DEBIT) AS HDE FROM GENERAL_LEDGER G INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND G.PAYMENTKEY=P.PAYMENTKEY WHERE ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE REPLACE(CHECK_PAYEE,CHAR(13)+CHAR(10),'') = @PAYEE) AND CONVERT(DATE,TRANS_DATE) BETWEEN @STARTDATE AND @ENDDATE AND ISNULL(G.PENALTY,0)=0 AND ISNULL(G.INTEREST,0)=0 AND P.BILL_TYPE IN ('H') AND ACCT_CODE NOT IN (8001) AND G.COMMISSION=0 ) HDE , (SELECT SUM(CREDIT-DEBIT) AS HDE_PEN_INT FROM GENERAL_LEDGER G INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND G.PAYMENTKEY=P.PAYMENTKEY WHERE (ACCT_CODE IN (8001) OR (ACCT_CODE=(SELECT COUNTY_MO_ACCT FROM DEFAULTS2) AND ISNULL(G.INTEREST,0)=1)) AND CONVERT(DATE,TRANS_DATE) BETWEEN @STARTDATE AND @ENDDATE AND (ISNULL(G.PENALTY,0)=1 OR ISNULL(G.INTEREST,0)=1) AND P.BILL_TYPE IN ('H') AND G.COMMISSION=0 ) HDE_PEN_INT , (SELECT SUM(CREDIT-DEBIT) FROM GENERAL_LEDGER G INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND G.PAYMENTKEY=P.PAYMENTKEY INNER JOIN CHART_ACCOUNTS C ON C.ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE REPLACE(CHECK_PAYEE,CHAR(13)+CHAR(10),'') = @PAYEE) WHERE G.ACCT_CODE=C.BREACH_ACCT AND CONVERT(DATE,TRANS_DATE) BETWEEN @STARTDATE AND @ENDDATE AND G.COMMISSION=0 ) BREACH , ISNULL((SELECT SUM(CREDIT-DEBIT) FROM GENERAL_LEDGER G INNER JOIN CHART_ACCOUNTS C ON C.ACCT_CODE=G.ACCT_CODE AND C.ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE ACCT_TYPE='L' AND DESCRIP LIKE '%DRIVES%' AND REPLACE(CHECK_PAYEE,CHAR(13)+CHAR(10),'') = @PAYEE) WHERE CONVERT(DATE,TRANS_DATE) BETWEEN @STARTDATE AND @ENDDATE AND JOURNAL_REF NOT IN ('Disbursement to Taxing Authority') ),0) MV_DRIVES , ISNULL((SELECT SUM(CREDIT-DEBIT) FROM GENERAL_LEDGER G INNER JOIN CHART_ACCOUNTS C ON C.ACCT_CODE=G.ACCT_CODE AND C.ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE REPLACE(CHECK_PAYEE,CHAR(13)+CHAR(10),'') = @PAYEE) WHERE CONVERT(DATE,TRANS_DATE) BETWEEN @STARTDATE AND @ENDDATE AND JOURNAL_REF NOT IN ('Disbursement to Taxing Authority') AND G.COMMISSION=1 ),0) COMMISSIONS true PROPERTY_CURRENT System.Decimal PROPERTY_PRIOR System.Decimal PROPERTY_PEN_INT System.Decimal TIMBER System.Decimal TIMBER_PEN_INT System.Decimal MH System.Decimal MH_PEN_INT System.Decimal HDE System.Decimal HDE_PEN_INT System.Decimal BREACH System.Decimal MV_DRIVES System.Decimal COMMISSIONS System.Decimal GatcsDB SELECT DISTINCT CHECK_PAYEE , REPLACE(CHECK_PAYEE,CHAR(13)+CHAR(10),'') AS CHECK_PAYEE2 FROM CHART_ACCOUNTS WHERE ACCT_TYPE='L' AND DISBURSEMENT=1 ORDER BY CHECK_PAYEE true CHECK_PAYEE System.String CHECK_PAYEE2 System.String GatcsDB SELECT DIGYR FROM DEFAULTS DIGYR System.Int16 0.625in 4.83in 1in 0.22in true true For: Textbox4 2pt 2pt 2pt 2pt true true =Parameters!PAYEE.Label Textbox44 2pt 2pt 2pt 2pt true true COMMISSIONS Textbox57 2pt 2pt 2pt 2pt 0.21in true true 2pt 2pt 2pt 2pt true true CURRENT YEAR REAL PROPERTY TAX 2pt 2pt 2pt 2pt true true =Fields!PROPERTY_CURRENT.Value 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true PRIOR YEAR REAL PROPERTY TAX 2pt 2pt 2pt 2pt true true =Fields!PROPERTY_PRIOR.Value 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true REAL PROPERTY PENALTY AND INTEREST 2pt 2pt 2pt 2pt true true =Fields!PROPERTY_PEN_INT.Value 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true TIMBER TAX 2pt 2pt 2pt 2pt true true =Fields!TIMBER.Value 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true TIMBER PENALTY AND INTEREST 2pt 2pt 2pt 2pt true true =Fields!TIMBER_PEN_INT.Value 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true MOBILE HOME TAX 2pt 2pt 2pt 2pt true true =Fields!MH.Value 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true MOBILE HOME PENALTY AND INTEREST 2pt 2pt 2pt 2pt true true =Fields!MH_PEN_INT.Value 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true HEAVY DUTY EQUIPMENT TAX 2pt 2pt 2pt 2pt true true =Fields!HDE.Value 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true HEAVY DUTY EQUIPMENT PENALTY AND INTEREST 2pt 2pt 2pt 2pt true true =Fields!HDE_PEN_INT.Value 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true PROPERTY TAX BREACH 2pt 2pt 2pt 2pt true true =Fields!BREACH.Value 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true COMMISSIONS 2pt 2pt 2pt 2pt true true =Fields!COMMISSIONS.Value 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true TOTAL 2pt 2pt 2pt 2pt true true =Fields!PROPERTY_CURRENT.Value + Fields!PROPERTY_PRIOR.Value + Fields!PROPERTY_PEN_INT.Value + Fields!TIMBER.Value + Fields!TIMBER_PEN_INT.Value + Fields!MH.Value + Fields!MH_PEN_INT.Value + Fields!HDE.Value + Fields!HDE_PEN_INT.Value + Fields!BREACH.Value + Fields!COMMISSIONS.Value 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true MOTOR VEHICLE TAX PAYOUT 2pt 2pt 2pt 2pt true true =Fields!MV_DRIVES.Value 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true MISCELLANEOUS LightGrey 1pt LightGrey 1pt LightGrey 1pt LightGrey 1pt 2pt 2pt 2pt 2pt true true =Parameters!MV_REFUND.Value Textbox49 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true OVER/(SHORT) LightGrey 1pt LightGrey 1pt LightGrey 1pt LightGrey 1pt 2pt 2pt 2pt 2pt true true =Parameters!OVER_SHORT.Value Textbox43 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true CLERK OF SUPERIOR COURT LightGrey 1pt LightGrey 1pt LightGrey 1pt LightGrey 1pt 2pt 2pt 2pt 2pt true true =Parameters!SUP_CT_CLK.Value Textbox34 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true TOTAL PAYMENT RECEIVED FROM TAX COMMISSIONER 2pt 2pt 2pt 2pt true true =Fields!PROPERTY_CURRENT.Value + Fields!PROPERTY_PRIOR.Value + Fields!PROPERTY_PEN_INT.Value + Fields!TIMBER.Value + Fields!TIMBER_PEN_INT.Value + Fields!MH.Value + Fields!MH_PEN_INT.Value + Fields!HDE.Value + Fields!HDE_PEN_INT.Value + Fields!COMMISSIONS.Value+ Fields!MV_DRIVES.Value + Parameters!MV_REFUND.Value + Parameters!OVER_SHORT.Value + Parameters!SUP_CT_CLK.Value 2pt 2pt 2pt 2pt After true true Detail Detail_Collection Output true DataSet1 5.18in 6.455in true true =Parameters!STARTDATE.Value & " TO " & Parameters!ENDDATE.Value 2pt 2pt 2pt 2pt 0.43792in true true true true =Globals!ExecutionTime 2pt 2pt 2pt 2pt 0.5in 0.5in 0.5in 0.5in