0
SQL
="data source=" & Parameters!ReportSvr.Value & "; Initial Catalog=" & Parameters!ReportDB.Value
true
Integrated
9e7792fd-0d6a-44b6-90b4-46b23e51b7fd
GatcsDB
=Parameters!dFROM.Value
=Parameters!dTO.Value
=Parameters!DESCRIP.Value
=Parameters!PROPTYPE.Value
SELECT X1.*, TT.COMMISSION_PERC, c.ACCT_TYPE
, CX.AMT AS CO_MO_COMM, D2.COUNTY_MO_ACCT
FROM (
SELECT TAXTYPE
, DESCRIP
, BILL_YEAR
, PROPTYPE
, SUM(COLLECTION_AMT) AS COLLECTION_AMT
, SUM(COLLECTION_COUNT) AS COLLECTION_COUNT
, SUM(COLLECTION_INTEREST) AS COLLECTION_INTEREST
, SUM(COLLECTION_TOTAL) AS COLLECTION_TOTAL
, SUM(REFUND_COUNT) AS REFUND_COUNT
, SUM(REFUND_AMOUNT) AS REFUND_AMOUNT
, SUM(REFUND_INTEREST) AS REFUND_INTEREST
, SUM(REFUND_TOTAL) AS REFUND_TOTAL
, SUM(NET_COLLECTION_COUNT) AS NET_COLLECTION_COUNT
, SUM(COMMISSION) AS COMMISSION
, SUM(COMM_INT) AS COMM_INT
FROM (
SELECT A.ACCT_CODE AS TAXTYPE
, X.DESCRIP
, A.BILL_YEAR
--, CASE WHEN ISNULL(A.UTILITY,0)=1 THEN 'U' ELSE A.BILL_TYPE END AS PROPTYPE
, A.BILL_TYPE AS PROPTYPE
, ISNULL(A1.AMT,0) AS COLLECTION_AMT
, A.[COUNT] AS COLLECTION_COUNT
, ISNULL(B.AMT,0) AS COLLECTION_INTEREST
, ISNULL(A1.AMT,0) + ISNULL(B.AMT,0) AS COLLECTION_TOTAL
, 0 AS REFUND_COUNT
, 0 AS REFUND_AMOUNT
, 0 AS REFUND_INTEREST
, 0 AS REFUND_TOTAL
, 0 AS NET_COLLECTION_AMT
, A.[COUNT] AS NET_COLLECTION_COUNT
, 0 AS NET_COLLECTION_INTEREST
, 0 AS NET_COLLECTION_TOTAL
, ISNULL(D.AMT,0) AS COMMISSION
, ISNULL(C.AMT,0) AS COMM_INT
, 0 AS DISBURSE_TOTAL
FROM (
SELECT G.ACCT_CODE, G.BILL_YEAR, B.BILL_TYPE--, B.UTILITY
, SUM(CREDIT-DEBIT) AMT, COUNT(*) AS [COUNT]
FROM GENERAL_LEDGER G
INNER JOIN CHART_ACCOUNTS C ON C.ACCT_CODE=G.ACCT_CODE AND C.DISBURSEMENT=1
INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND P.PAYMENTKEY=G.PAYMENTKEY
INNER JOIN VBILL B ON B.BILL_NO=G.BILL_NO AND B.BILL_YEAR=G.BILL_YEAR AND B.BILL_TYPE=P.BILL_TYPE
WHERE C.ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE DISBURSEMENT=1) AND
ISNULL(COMMISSION,0)=0 AND CONVERT(DATE,G.TRANS_DATE) BETWEEN @dFROM AND @dTO AND ISNULL(G.REFUND,0)=0
GROUP BY G.ACCT_CODE, G.BILL_YEAR, B.BILL_TYPE--, B.UTILITY
) A
LEFT JOIN (
SELECT G.ACCT_CODE, G.BILL_YEAR, B.BILL_TYPE
, SUM(CREDIT-DEBIT) AMT, COUNT(*) AS [COUNT]
FROM GENERAL_LEDGER G
INNER JOIN CHART_ACCOUNTS C ON C.ACCT_CODE=G.ACCT_CODE AND C.DISBURSEMENT=1
INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND P.PAYMENTKEY=G.PAYMENTKEY
INNER JOIN VBILL B ON B.BILL_NO=G.BILL_NO AND B.BILL_YEAR=G.BILL_YEAR AND B.BILL_TYPE=P.BILL_TYPE
WHERE C.ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE DISBURSEMENT=1) AND
ISNULL(G.INTEREST,0)=0 AND ISNULL(COMMISSION,0)=0 AND CONVERT(DATE,G.TRANS_DATE) BETWEEN @dFROM AND @dTO AND ISNULL(G.REFUND,0)=0
GROUP BY G.ACCT_CODE, G.BILL_YEAR, B.BILL_TYPE
) A1 ON A1.ACCT_CODE=A.ACCT_CODE AND A1.BILL_TYPE=A.BILL_TYPE AND A1.BILL_YEAR=A.BILL_YEAR
LEFT JOIN (
SELECT G.ACCT_CODE, G.BILL_YEAR, B.BILL_TYPE
, SUM(CREDIT-DEBIT) AMT, COUNT(*) AS [COUNT]
FROM GENERAL_LEDGER G
INNER JOIN CHART_ACCOUNTS C ON C.ACCT_CODE=G.ACCT_CODE AND C.DISBURSEMENT=1
INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND P.PAYMENTKEY=G.PAYMENTKEY
INNER JOIN VBILL B ON B.BILL_NO=G.BILL_NO AND B.BILL_YEAR=G.BILL_YEAR AND B.BILL_TYPE=P.BILL_TYPE
WHERE C.ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE DISBURSEMENT=1) AND
ISNULL(G.INTEREST,0)=1 AND ISNULL(COMMISSION,0)=0 AND CONVERT(DATE,G.TRANS_DATE) BETWEEN @dFROM AND @dTO AND ISNULL(G.REFUND,0)=0
GROUP BY G.ACCT_CODE, G.BILL_YEAR, B.BILL_TYPE
) B ON B.ACCT_CODE=A.ACCT_CODE AND B.BILL_TYPE=A.BILL_TYPE AND B.BILL_YEAR=A.BILL_YEAR
LEFT JOIN (
SELECT G.ACCT_CODE, G.BILL_YEAR, B.BILL_TYPE
, SUM(CREDIT-DEBIT) AMT, COUNT(*) AS [COUNT]
FROM GENERAL_LEDGER G
INNER JOIN CHART_ACCOUNTS C ON C.ACCT_CODE=G.ACCT_CODE AND C.DISBURSEMENT=1
INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND P.PAYMENTKEY=G.PAYMENTKEY
INNER JOIN VBILL B ON B.BILL_NO=G.BILL_NO AND B.BILL_YEAR=G.BILL_YEAR AND B.BILL_TYPE=P.BILL_TYPE
WHERE C.ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE DISBURSEMENT=1) AND
ISNULL(G.INTEREST,0)=1 AND ISNULL(COMMISSION,0)=1 AND CONVERT(DATE,G.TRANS_DATE) BETWEEN @dFROM AND @dTO AND ISNULL(G.REFUND,0)=0
GROUP BY G.ACCT_CODE, G.BILL_YEAR, B.BILL_TYPE
) C ON C.ACCT_CODE=A.ACCT_CODE AND C.BILL_TYPE=A.BILL_TYPE AND C.BILL_YEAR=A.BILL_YEAR
LEFT JOIN (
SELECT G.ACCT_CODE, G.BILL_YEAR, B.BILL_TYPE
, SUM(CREDIT-DEBIT) AMT, COUNT(*) AS [COUNT]
FROM GENERAL_LEDGER G
INNER JOIN CHART_ACCOUNTS C ON C.ACCT_CODE=G.ACCT_CODE AND C.DISBURSEMENT=1
INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND P.PAYMENTKEY=G.PAYMENTKEY
INNER JOIN VBILL B ON B.BILL_NO=G.BILL_NO AND B.BILL_YEAR=G.BILL_YEAR AND B.BILL_TYPE=P.BILL_TYPE
WHERE C.ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE DISBURSEMENT=1) AND
ISNULL(G.INTEREST,0)=0 AND ISNULL(COMMISSION,0)=1 AND CONVERT(DATE,G.TRANS_DATE) BETWEEN @dFROM AND @dTO AND ISNULL(G.REFUND,0)=0
GROUP BY G.ACCT_CODE, G.BILL_YEAR, B.BILL_TYPE
) D ON D.ACCT_CODE=A.ACCT_CODE AND D.BILL_TYPE=A.BILL_TYPE AND D.BILL_YEAR=A.BILL_YEAR
INNER JOIN CHART_ACCOUNTS X ON X.ACCT_CODE=A.ACCT_CODE
WHERE X.DESCRIP IN (@DESCRIP)
--ORDER BY A.ACCT_CODE, A.BILL_YEAR, A.BILL_TYPE
UNION
SELECT R.ACCT_CODE AS TAXTYPE
, X.DESCRIP
, R.BILL_YEAR
, R.BILL_TYPE AS PROPTYPE
, 0 AS COLLECTION_AMT
, 0 AS COLLECTION_COUNT
, 0 AS COLLECTION_INTEREST
, 0 AS COLLECTION_TOTAL
, R.[COUNT] AS REFUND_COUNT
, R.AMT AS REFUND_AMOUNT
, ISNULL(RI.AMT,0) AS REFUND_INTEREST
, ISNULL(R.AMT,0) + ISNULL(RI.AMT,0) AS REFUND_TOTAL
, 0 AS NET_COLLECTION_AMT
, 0 AS NET_COLLECTION_COUNT
, 0 AS NET_COLLECTION_INTEREST
, 0 AS NET_COLLECTION_TOTAL
, ISNULL(RC.AMT,0) AS COMMISSION
, ISNULL(RCI.AMT,0) AS COMM_INT
, 0 AS DISBURSE_TOTAL
FROM (
SELECT G.ACCT_CODE, G.BILL_YEAR, B.BILL_TYPE
, SUM(CREDIT-DEBIT) AMT, 1 AS [COUNT]
FROM GENERAL_LEDGER G
INNER JOIN CHART_ACCOUNTS C ON C.ACCT_CODE=G.ACCT_CODE AND C.DISBURSEMENT=1
INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND P.PAYMENTKEY=G.PAYMENTKEY
INNER JOIN VBILL B ON B.BILL_NO=G.BILL_NO AND B.BILL_YEAR=G.BILL_YEAR AND B.BILL_TYPE=P.BILL_TYPE
WHERE C.ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE DISBURSEMENT=1 AND ACCT_TYPE='L') AND
ISNULL(G.INTEREST,0)=0 AND ISNULL(G.REFUND,0)=1 AND CONVERT(DATE,G.TRANS_DATE) BETWEEN @dFROM AND @dTO AND ISNULL(G.REVERSAL,0)=1 AND ISNULL(COMMISSION,0)=0
GROUP BY G.ACCT_CODE, G.BILL_YEAR, B.BILL_TYPE
) R
LEFT JOIN (
SELECT G.ACCT_CODE, G.BILL_YEAR, B.BILL_TYPE
, SUM(CREDIT-DEBIT) AMT, 1 AS [COUNT]
FROM GENERAL_LEDGER G
INNER JOIN CHART_ACCOUNTS C ON C.ACCT_CODE=G.ACCT_CODE AND C.DISBURSEMENT=1
INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND P.PAYMENTKEY=G.PAYMENTKEY
INNER JOIN VBILL B ON B.BILL_NO=G.BILL_NO AND B.BILL_YEAR=G.BILL_YEAR AND B.BILL_TYPE=P.BILL_TYPE
WHERE C.ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE DISBURSEMENT=1 AND ACCT_TYPE='L') AND
ISNULL(G.INTEREST,0)=1 AND ISNULL(G.REFUND,0)=1 AND CONVERT(DATE,G.TRANS_DATE) BETWEEN @dFROM AND @dTO AND ISNULL(G.REVERSAL,0)=1 AND ISNULL(COMMISSION,0)=0
GROUP BY G.ACCT_CODE, G.BILL_YEAR, B.BILL_TYPE
) RI ON RI.BILL_TYPE=R.BILL_TYPE AND RI.BILL_YEAR=R.BILL_YEAR AND RI.ACCT_CODE=R.ACCT_CODE
LEFT JOIN (
SELECT G.ACCT_CODE, G.BILL_YEAR, B.BILL_TYPE
, SUM(CREDIT-DEBIT) AMT, 1 AS [COUNT]
FROM GENERAL_LEDGER G
INNER JOIN CHART_ACCOUNTS C ON C.ACCT_CODE=G.ACCT_CODE AND C.DISBURSEMENT=1
INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND P.PAYMENTKEY=G.PAYMENTKEY
INNER JOIN VBILL B ON B.BILL_NO=G.BILL_NO AND B.BILL_YEAR=G.BILL_YEAR AND B.BILL_TYPE=P.BILL_TYPE
WHERE C.ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE DISBURSEMENT=1 AND ACCT_TYPE='L') AND
ISNULL(G.INTEREST,0)=0 AND ISNULL(G.REFUND,0)=1 AND CONVERT(DATE,G.TRANS_DATE) BETWEEN @dFROM AND @dTO AND ISNULL(G.REVERSAL,0)=1 AND ISNULL(COMMISSION,0)=1
GROUP BY G.ACCT_CODE, G.BILL_YEAR, B.BILL_TYPE
) RC ON RC.BILL_TYPE=R.BILL_TYPE AND RC.BILL_YEAR=R.BILL_YEAR AND RC.ACCT_CODE=R.ACCT_CODE
LEFT JOIN (
SELECT G.ACCT_CODE, G.BILL_YEAR, B.BILL_TYPE
, SUM(CREDIT-DEBIT) AMT, 1 AS [COUNT]
FROM GENERAL_LEDGER G
INNER JOIN CHART_ACCOUNTS C ON C.ACCT_CODE=G.ACCT_CODE AND C.DISBURSEMENT=1
INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND P.PAYMENTKEY=G.PAYMENTKEY
INNER JOIN VBILL B ON B.BILL_NO=G.BILL_NO AND B.BILL_YEAR=G.BILL_YEAR AND B.BILL_TYPE=P.BILL_TYPE
WHERE C.ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE DISBURSEMENT=1 AND ACCT_TYPE='L') AND
ISNULL(G.INTEREST,0)=1 AND ISNULL(G.REFUND,0)=1 AND CONVERT(DATE,G.TRANS_DATE) BETWEEN @dFROM AND @dTO AND ISNULL(G.REVERSAL,0)=1 AND ISNULL(COMMISSION,0)=1
GROUP BY G.ACCT_CODE, G.BILL_YEAR, B.BILL_TYPE
) RCI ON RCI.BILL_TYPE=R.BILL_TYPE AND RCI.BILL_YEAR=R.BILL_YEAR AND RCI.ACCT_CODE=R.ACCT_CODE
INNER JOIN CHART_ACCOUNTS X ON X.ACCT_CODE=R.ACCT_CODE
WHERE X.DESCRIP IN (@DESCRIP)
) Z
GROUP BY Z.TAXTYPE, Z.DESCRIP, Z.BILL_YEAR, Z.PROPTYPE
) X1
LEFT JOIN TAXTYPE TT ON TT.COMMISSION_DUETO_OUT=X1.TAXTYPE
LEFT JOIN CHART_ACCOUNTS C ON C.ACCT_CODE=X1.TAXTYPE
LEFT JOIN DEFAULTS2 D2 ON 1=1
LEFT JOIN (
SELECT BILL_YEAR, BILL_TYPE, SUM(AMT) AMT
FROM (
SELECT C.ACCT_CODE, TT.COMMISSION_PERC , G.BILL_YEAR, B.BILL_TYPE
, ROUND( TT.COMMISSION_PERC * SUM(CREDIT-DEBIT),2) AMT
FROM GENERAL_LEDGER G
INNER JOIN CHART_ACCOUNTS C ON C.ACCT_CODE=G.ACCT_CODE AND C.DISBURSEMENT=1
INNER JOIN VPAYMENT P ON P.BILL_NO=G.BILL_NO AND P.BILL_YEAR=G.BILL_YEAR AND P.PAYMENTKEY=G.PAYMENTKEY
INNER JOIN VBILL B ON B.BILL_NO=G.BILL_NO AND B.BILL_YEAR=G.BILL_YEAR AND B.BILL_TYPE=P.BILL_TYPE
INNER JOIN TAXTYPE TT ON TT.COMMISSION_DUETO_OUT=C.ACCT_CODE
WHERE C.ACCT_CODE IN (SELECT ACCT_CODE FROM CHART_ACCOUNTS WHERE DISBURSEMENT=1 AND ACCT_TYPE='L')
AND ISNULL(COMMISSION,0)=0
AND CONVERT(DATE,G.TRANS_DATE) BETWEEN @dFROM AND @dTO
AND C.ACCT_CODE <> (SELECT COUNTY_MO_ACCT FROM DEFAULTS2)
GROUP BY C.ACCT_CODE, TT.COMMISSION_PERC , G.BILL_YEAR, B.BILL_TYPE
) A
GROUP BY BILL_YEAR, BILL_TYPE
) CX ON CX.BILL_TYPE=X1.PROPTYPE AND CX.BILL_YEAR=X1.BILL_YEAR
WHERE X1.PROPTYPE IN (@PROPTYPE)
ORDER BY X1.TAXTYPE, X1.BILL_YEAR, X1.PROPTYPE
true
TAXTYPE
System.String
DESCRIP
System.String
PROPTYPE
System.String
BILL_YEAR
System.Int16
COLLECTION_COUNT
System.Int32
COLLECTION_AMT
System.Decimal
COLLECTION_INTEREST
System.Decimal
COLLECTION_TOTAL
System.Decimal
REFUND_COUNT
System.Int32
REFUND_AMOUNT
System.Decimal
REFUND_INTEREST
System.Decimal
REFUND_TOTAL
System.Decimal
NET_COLLECTION_COUNT
System.Int32
COMMISSION
System.Decimal
COMM_INT
System.Decimal
COMMISSION_PERC
System.Decimal
ACCT_TYPE
System.String
CO_MO_COMM
System.Decimal
COUNTY_MO_ACCT
System.String
GatcsDB
SELECT CONVERT(DATE,GETDATE()) AS TODAY
, DIGYR
, CONAME
FROM DEFAULTS
true
TODAY
System.DateTime
DIGYR
System.Int16
CONAME
System.String
GatcsDB
=Parameters!dFROM.Value
=Parameters!dTO.Value
SELECT DESCRIP
FROM CHART_ACCOUNTS
WHERE (DISBURSEMENT = 1) AND (ACCT_CODE IN
(SELECT DISTINCT ACCT_CODE
FROM GENERAL_LEDGER
WHERE (CONVERT(DATE, TRANS_DATE) BETWEEN @dFROM AND @dTO)))
ORDER BY DESCRIP
DESCRIP
System.String
GatcsDB
SELECT DISTINCT PROPTYPE FROM VPROPERTY ORDER BY PROPTYPE
PROPTYPE
System.String
0.35in
0.35in
0.35in
0.4in
0.72in
0.6in
0.72in
0.36in
0.7in
0.5in
0.72in
0.4in
0.72in
0.6in
0.8in
0.6725in
0.8in
0.25in
true
true
Textbox1
2pt
2pt
2pt
2pt
true
true
Textbox2
2pt
2pt
2pt
2pt
true
true
Textbox4
2pt
2pt
2pt
2pt
true
true
COLLECTION
Textbox5
2pt
2pt
2pt
2pt
4
true
true
REFUND
Textbox9
2pt
2pt
2pt
2pt
4
true
true
NET COLLECTION
Textbox13
2pt
2pt
2pt
2pt
4
true
true
Textbox17
2pt
2pt
2pt
2pt
true
true
Textbox18
2pt
2pt
2pt
2pt
0.22in
true
true
Bill Year
Textbox3
2pt
2pt
2pt
2pt
true
true
Tax Type
Textbox8
2pt
2pt
2pt
2pt
true
true
Prop Type
Textbox10
2pt
2pt
2pt
2pt
true
true
Count
Textbox27
2pt
2pt
2pt
2pt
true
true
Amount
Textbox28
2pt
2pt
2pt
2pt
true
true
Interest
Textbox29
2pt
2pt
2pt
2pt
true
true
Total
Textbox30
2pt
2pt
2pt
2pt
true
true
Count
Textbox27
2pt
2pt
2pt
2pt
true
true
Amount
Textbox28
2pt
2pt
2pt
2pt
true
true
Interest
Textbox29
2pt
2pt
2pt
2pt
true
true
Total
Textbox30
2pt
2pt
2pt
2pt
true
true
Count
Textbox27
2pt
2pt
2pt
2pt
true
true
Amount
Textbox28
2pt
2pt
2pt
2pt
true
true
Interest
Textbox29
2pt
2pt
2pt
2pt
true
true
Total
Textbox30
2pt
2pt
2pt
2pt
true
true
Commiss
Textbox671
2pt
2pt
2pt
2pt
true
true
Total
Textbox672
2pt
2pt
2pt
2pt
0.21in
true
true
=Fields!DESCRIP.Value
DESCRIP1
Khaki
2pt
2pt
2pt
2pt
3
true
true
=Sum(Fields!COLLECTION_COUNT.Value)
textbox24
Khaki
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!COLLECTION_AMT.Value)
textbox25
Khaki
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!COLLECTION_INTEREST.Value)
textbox26
Khaki
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!COLLECTION_TOTAL.Value)
textbox27
Khaki
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!REFUND_COUNT.Value)
textbox28
Khaki
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!REFUND_AMOUNT.Value)
textbox29
Khaki
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!REFUND_INTEREST.Value)
textbox30
Khaki
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!REFUND_TOTAL.Value)
textbox31
Khaki
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!NET_COLLECTION_COUNT.Value)
textbox32
Khaki
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!COLLECTION_AMT.Value+Fields!REFUND_AMOUNT.Value)
textbox33
Khaki
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!COLLECTION_INTEREST.Value+Fields!REFUND_INTEREST.Value)
textbox34
Khaki
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!COLLECTION_AMT.Value+Fields!COLLECTION_INTEREST.Value+Fields!REFUND_AMOUNT.Value+Fields!REFUND_INTEREST.Value)
textbox35
Khaki
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!COMMISSION.Value+Fields!COMM_INT.Value)
textbox35
Khaki
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!COLLECTION_AMT.Value+Fields!COLLECTION_INTEREST.Value+Fields!REFUND_AMOUNT.Value+Fields!REFUND_INTEREST.Value+Fields!COMMISSION.Value+Fields!COMM_INT.Value)
textbox37
Khaki
2pt
2pt
2pt
2pt
0.21in
true
true
=Fields!BILL_YEAR.Value
BILL_YEAR
2pt
2pt
2pt
2pt
true
true
=Fields!TAXTYPE.Value
TAXTYPE
2pt
2pt
2pt
2pt
true
true
=Fields!PROPTYPE.Value
PROPTYPE
2pt
2pt
2pt
2pt
true
true
=Fields!COLLECTION_COUNT.Value
COLLECTION_COUNT
2pt
2pt
2pt
2pt
true
true
=Fields!COLLECTION_AMT.Value
COLLECTION_AMT
2pt
2pt
2pt
2pt
true
true
=Fields!COLLECTION_INTEREST.Value
COLLECTION_INTEREST
2pt
2pt
2pt
2pt
true
true
=Fields!COLLECTION_TOTAL.Value
COLLECTION_TOTAL
2pt
2pt
2pt
2pt
true
true
=Fields!REFUND_COUNT.Value
REFUND_COUNT
2pt
2pt
2pt
2pt
true
true
=Fields!REFUND_AMOUNT.Value
REFUND_AMOUNT
2pt
2pt
2pt
2pt
true
true
=Fields!REFUND_INTEREST.Value
REFUND_INTEREST
2pt
2pt
2pt
2pt
true
true
=Fields!REFUND_TOTAL.Value
REFUND_TOTAL
2pt
2pt
2pt
2pt
true
true
=Fields!NET_COLLECTION_COUNT.Value
NET_COLLECTION_COUNT
2pt
2pt
2pt
2pt
true
true
=Fields!COLLECTION_AMT.Value+Fields!REFUND_AMOUNT.Value
NET_COLLECTION_AMT
2pt
2pt
2pt
2pt
true
true
=Fields!COLLECTION_INTEREST.Value+Fields!REFUND_INTEREST.Value
NET_COLLECTION_INTEREST
2pt
2pt
2pt
2pt
true
true
=Fields!COLLECTION_AMT.Value+Fields!COLLECTION_INTEREST.Value+Fields!REFUND_AMOUNT.Value+Fields!REFUND_INTEREST.Value
NET_COLLECTION_TOTAL
2pt
2pt
2pt
2pt
true
true
=Fields!COMMISSION.Value+Fields!COMM_INT.Value
NET_COLLECTION_TOTAL
2pt
2pt
2pt
2pt
true
true
=Fields!COLLECTION_AMT.Value+Fields!COLLECTION_INTEREST.Value+Fields!REFUND_AMOUNT.Value+Fields!REFUND_INTEREST.Value+Fields!COMMISSION.Value+Fields!COMM_INT.Value
DISBURSE_TOTAL
2pt
2pt
2pt
2pt
0.25in
true
true
Overage/Refunds
Textbox653
LightGreen
2pt
2pt
2pt
2pt
3
true
true
=Sum(Fields!COLLECTION_COUNT.Value)
Textbox657
LightGreen
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!COLLECTION_AMT.Value)
Textbox658
Overpay Details
=Parameters!ReportSvr.Value
=Parameters!ReportDB.Value
=Parameters!dFROM.Value
=Parameters!dTO.Value
Lime
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!COLLECTION_INTEREST.Value)
Textbox659
LightGreen
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!COLLECTION_TOTAL.Value)
Textbox660
LightGreen
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!REFUND_COUNT.Value)
Textbox661
LightGreen
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!REFUND_AMOUNT.Value)
Textbox662
LightGreen
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!REFUND_INTEREST.Value)
Textbox663
LightGreen
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!REFUND_TOTAL.Value)
Textbox664
LightGreen
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!NET_COLLECTION_COUNT.Value)
Textbox665
LightGreen
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!COLLECTION_AMT.Value+Fields!REFUND_AMOUNT.Value)
Textbox666
LightGreen
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!COLLECTION_INTEREST.Value+Fields!REFUND_INTEREST.Value)
Textbox667
LightGreen
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!COLLECTION_AMT.Value+Fields!COLLECTION_INTEREST.Value+Fields!REFUND_AMOUNT.Value+Fields!REFUND_INTEREST.Value)
Textbox668
LightGreen
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!COMMISSION.Value+Fields!COMM_INT.Value)
Textbox668
LightGreen
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!COLLECTION_AMT.Value+Fields!COLLECTION_INTEREST.Value+Fields!REFUND_AMOUNT.Value+Fields!REFUND_INTEREST.Value+Fields!COMMISSION.Value+Fields!COMM_INT.Value)
Textbox670
Revenue Disbursement by Authority_AUDIT
=Parameters!ReportSvr.Value
=Parameters!ReportDB.Value
Lime
2pt
2pt
2pt
2pt
After
true
After
true
true
=Fields!DESCRIP.Value
After
true
Detail
Detail_Collection
Output
true
Before
DataSet1
=Fields!TAXTYPE.Value
1.14in
9.7625in
1.14in
9.7625in
1in
true
true
true
true
=trim(First(Fields!CONAME.Value, "DataSet2")) + " County Revenue Disbursements by Authority"
textbox1
2.33195in
0.36in
5.63055in
true
true
=Globals!ExecutionTime
ExecutionTime
0.20833in
2.2625in
1
2pt
2pt
2pt
2pt
true
true
="Page " & Globals!PageNumber & " of " & Globals!TotalPages
PageNumber
8.31458in
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.40167in
3.6425in
0.25in
2.86458in
3
2pt
2pt
2pt
2pt
8.5in
11in
0.5in
0.5in
0.5in
0.5in
String
ReportSvr
String
ReportDB
DateTime
DataSet2
TODAY
d FROM
DateTime
DataSet2
TODAY
d TO
String
DataSet3
DESCRIP
true
DESCRIP
DataSet3
DESCRIP
DESCRIP
true
String
PropType
PROPTYPE
PROPTYPE
PropType
PROPTYPE
PROPTYPE
true
2
3
0
0
ReportSvr
1
0
ReportDB
0
1
dFROM
1
1
dTO
0
2
DESCRIP
1
2
PROPTYPE
en-US
true
Inch
f4574c14-8352-402d-b40b-07fb2363dd95