5in
0.22in
true
true
=Fields!DIGYR.Value & " DIGEST " & IIF(Parameters!cTDList.Value<>"all", " (" & Parameters!cNamesList.Value & ")","COUNTY WIDE")
Textbox4
SteelBlue
2pt
2pt
2pt
2pt
true
0.21in
Consolidation Values
=Parameters!ReportSvr.Value
=Parameters!ReportDB.Value
=Parameters!cTDList.Value
0.25in
Consolidation Exemptions
=Parameters!ReportSvr.Value
=Parameters!ReportDB.Value
=Parameters!cTDList.Value
After
true
true
Detail
Detail_Collection
Output
true
DataSet1
0.36in
0.68in
5in
true
true
="Consolidation : " + Parameters!cTaxTypeName.Value + " : " + trim(Parameters!cTDList.Value)
textbox1
0.36in
7.01042in
1
1.54875in
1in
1in
1.45125in
0.25in
true
true
DESCRIP
Textbox6
Khaki
2pt
2pt
2pt
2pt
true
true
COUNT
Textbox8
Khaki
2pt
2pt
2pt
2pt
true
true
ACRES
Textbox10
Khaki
2pt
2pt
2pt
2pt
true
true
VALUE40
Textbox13
Khaki
2pt
2pt
2pt
2pt
0.25in
true
true
=Fields!DESCRIP.Value
DESCRIP
2pt
2pt
2pt
2pt
true
true
=Fields!COUNT.Value
COUNT
2pt
2pt
2pt
2pt
true
true
=Fields!ACRES.Value
ACRES
2pt
2pt
2pt
2pt
true
true
=Fields!VALUE40.Value
VALUE40
2pt
2pt
2pt
2pt
0.25in
true
true
Textbox15
LightGreen
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!COUNT.Value)
Textbox16
LightGreen
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!ACRES.Value)
Textbox17
LightGreen
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!VALUE40.Value)
Textbox18
LightGreen
2pt
2pt
2pt
2pt
After
Before
DataSet2
1.19458in
0.75in
5in
2
1.54875in
1in
1in
1.45125in
0.25in
true
true
DESCRIP
Textbox19
Khaki
2pt
2pt
2pt
2pt
true
true
COUNT
Textbox21
Khaki
2pt
2pt
2pt
2pt
true
true
ACRES
Textbox23
Khaki
2pt
2pt
2pt
2pt
true
true
VALUE40
Textbox25
Khaki
2pt
2pt
2pt
2pt
0.25in
true
true
=Fields!DESCRIP.Value
DESCRIP1
2pt
2pt
2pt
2pt
true
true
=Fields!COUNT.Value
COUNT1
2pt
2pt
2pt
2pt
true
true
=Fields!ACRES.Value
ACRES1
2pt
2pt
2pt
2pt
true
true
=Fields!VALUE40.Value
VALUE401
2pt
2pt
2pt
2pt
0.25in
true
true
Textbox27
LightGreen
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!COUNT.Value)
Textbox28
LightGreen
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!ACRES.Value)
Textbox29
LightGreen
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!VALUE40.Value)
Textbox30
LightGreen
2pt
2pt
2pt
2pt
After
Before
DataSet3
2.09042in
0.75in
5in
3
true
true
Code
Textbox46
Khaki
2pt
2pt
2pt
2pt
true
true
Count
Textbox42
Khaki
2pt
2pt
2pt
2pt
0.8in
0.25in
true
true
=Sum(Fields!ID.Value)
ID
2pt
2pt
2pt
2pt
0.25in
true
true
=Sum(Fields!ID.Value)
Textbox58
LightGreen
2pt
2pt
2pt
2pt
=Fields!DESCRIP.Value
0.25in
true
true
=StrConv(Fields!DESCRIP.Value, vbProperCase)
DESCRIP3
Khaki
2pt
2pt
2pt
2pt
=iif(Val(Parameters!nTaxtype.Value)=0,1=0,Val(Fields!taxtype.Value) <> Val(Parameters!nTaxtype.Value))
=Fields!excode.Value
0.35in
true
true
=Fields!excode.Value
excode
2pt
2pt
2pt
2pt
0.4in
true
true
=Max(Fields!Count.Value)
Count1
2pt
2pt
2pt
2pt
0.35in
true
true
Total
Textbox56
LightGreen
2pt
2pt
2pt
2pt
0.4in
true
true
Textbox57
LightGreen
2pt
2pt
2pt
2pt
Before
ExGrid
2.97583in
0.75in
1.55in
4
1in
0.8in
0.25in
true
true
Gross Taxable
Textbox75
2pt
2pt
2pt
2pt
true
true
=Avg(Fields!GROSSDIGEST.Value)
GROSSDIGEST
2pt
2pt
2pt
2pt
0.25in
true
true
Less Exemptions
Textbox76
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!ID.Value)
ID1
2pt
2pt
2pt
2pt
0.25in
true
true
Net Taxable
Textbox77
Black
1.5pt
2pt
2pt
2pt
2pt
true
true
=Fields!GROSSDIGEST.Value- Sum(Fields!ID.Value)
Textbox69
Black
1.5pt
2pt
2pt
2pt
2pt
0.25in
true
true
MILLS
Textbox5
Black
1.5pt
2pt
2pt
2pt
2pt
true
true
=AVG(Fields!MILLS.Value)
MILLS
Black
1.5pt
2pt
2pt
2pt
2pt
0.25in
true
true
TAXES
Textbox9
Black
1.5pt
LightGreen
2pt
2pt
2pt
2pt
true
true
=ROUND((Fields!GROSSDIGEST.Value - Sum(Fields!ID.Value)) * Fields!MILLS.Value,2)
Textbox69
Black
1.5pt
LightGreen
2pt
2pt
2pt
2pt
0.25in
true
true
Textbox74
Khaki
2pt
2pt
2pt
2pt
=Fields!taxtype.Value
0.25in
true
true
=StrConv(Fields!DESCRIP.Value, vbProperCase)
DESCRIP4
Khaki
2pt
2pt
2pt
2pt
=iif(Val(Parameters!nTaxtype.Value)=0,1=0,Val(Fields!taxtype.Value) <> Val(Parameters!nTaxtype.Value))
ExGrid
3.89597in
1.5in
1.8in
5
true
true
="I, <b>"+trim(First(Fields!TC_NAME.Value, "DataSet1")) + "</b>, receiver of tax returns in and for said county, do hereby certify that the above and foregoing is a true and correct "+
"consolidation of all the tax returns from the taxpayer (or assessed against defaulters) in said county of "+
"<b>"+trim(First(Fields!CONAME.Value, "DataSet1"))+" County</b> for the year " + cstr(Sum(Fields!DIGYR.Value, "DataSet1")) + ", and duplicate digests have been made and delivered to the "+
"county governing authority and tax collector of said county as required by law <br><br>." +
"Witness my hand and official signature, this _________ day of __________, 20______ R.T.R. "
HTML
Textbox2
5.57167in
0.25in
7in
6
2pt
2pt
2pt
2pt
5.82167in
7.01045in
0.46875in
true
true
true
true
=Globals!ExecutionTime
ExecutionTime
0.17542in
0.25in
1.54875in
2pt
2pt
2pt
2pt
true
true
=TRIM(Globals!PageNumber) & " OF " & TRIM(Globals!TotalPages)
PageNumber
0.22542in
5.04867in
0.2in
1.95133in
1
2pt
2pt
2pt
2pt
true
true
=Parameters!cNamesList.Value
PageNumber
1.61819in
0.2in
5.38181in
2
2pt
2pt
2pt
2pt
0.5in
0.5in
0.5in
0.5in
0
SQL
="data source=" & Parameters!ReportSvr.Value & "; Initial Catalog=" & Parameters!ReportDB.Value
true
Integrated
18ea9cec-aff1-4754-9be1-ac92a4240424
wingapDB
SELECT DEFAULTS.CONAME, DEFAULTS.DIGYR, D2.TC_NAME
FROM DEFAULTS LEFT OUTER JOIN
DEFAULTS2 AS D2 ON 1 = 1
CONAME
System.String
DIGYR
System.Int16
TC_NAME
System.String
wingapDB
SELECT D.DESCRIP, COUNT(*) AS [COUNT], SUM(ACRES) AS ACRES, SUM(VALUE40) AS VALUE40
FROM CONS_VALUE C
LEFT JOIN
(
SELECT 'A' DIGCLASS, 'AGRICULTURAL' DESCRIP
UNION
SELECT 'C' DIGCLASS, 'COMMERCIAL' DESCRIP
UNION
SELECT 'E' DIGCLASS, 'EXEMPT' DESCRIP
UNION
SELECT 'F' DIGCLASS, 'FLPA FMV (F)' DESCRIP
UNION
SELECT 'H' DIGCLASS, 'HISTORIC' DESCRIP
UNION
SELECT 'I' DIGCLASS, 'INDUSTRIAL' DESCRIP
UNION
SELECT 'J' DIGCLASS, 'FLPA' DESCRIP
UNION
SELECT 'P' DIGCLASS, 'PREFERENTIAL' DESCRIP
UNION
SELECT 'R' DIGCLASS, 'RESIDENTIAL' DESCRIP
UNION
SELECT 'U' DIGCLASS, 'UTILITY' DESCRIP
UNION
SELECT 'V' DIGCLASS, 'CONSERVATION' DESCRIP
) D ON D.DIGCLASS=C.DIGCLASS
WHERE C.DIGCLASS NOT IN ('E','F')
GROUP BY D.DESCRIP ORDER BY D.DESCRIP
true
DESCRIP
System.String
COUNT
System.Int32
ACRES
System.Decimal
VALUE40
System.Int64
wingapDB
=Parameters!cTDList.Value
SELECT 'MOTOR VEHICLE' DESCRIP
, SUM(MVCOUNT) AS COUNT
, 0 as ACRES
, SUM(MOTORVEH) as VALUE40
from TAXDIST
where @cTDList LIKE '%'+TAXDISTRIC+'%' or @cTDList='all'
UNION
SELECT 'MOBILE HOME' DESCRIP
, SUM(MHCOUNT) AS COUNT
, 0 as ACRES
, SUM(MOBILEHOME) as VALUE40
from TAXDIST
where @cTDList LIKE '%'+TAXDISTRIC+'%' or @cTDList='all'
UNION
SELECT 'TIMBER' DESCRIP
, SUM(TICOUNT) AS COUNT
, 0 as ACRES
, SUM(TIMBER100) as VALUE40
from TAXDIST
where @cTDList LIKE '%'+TAXDISTRIC+'%' or @cTDList='all'
UNION
SELECT 'HDE' DESCRIP
, SUM(HECOUNT) AS COUNT
, 0 as ACRES
, SUM(HEAVYEQUIP) as VALUE40
from TAXDIST
where @cTDList LIKE '%'+TAXDISTRIC+'%' or @cTDList='all'
true
DESCRIP
System.String
COUNT
System.Int32
ACRES
System.Int32
VALUE40
System.Int32
wingapDB
=Parameters!cTDList.Value
select c.excode
, c.taxtype
, t.DESCRIP
, count(*) as [Count]
, SUM(c.act_exempt) as ID
, (
(SELECT SUM(VALUE40) FROM CONS_VALUE CC WHERE CC.DIGCLASS NOT IN ('E','F'))
+
(SELECT SUM(HEAVYEQUIP) FROM TAXDIST WHERE @cTDList LIKE '%'+TAXDISTRIC+'%' or @cTDList='all')
+
(SELECT SUM(MOTORVEH) FROM TAXDIST WHERE @cTDList LIKE '%'+TAXDISTRIC+'%' or @cTDList='all')
+
(SELECT SUM(MOBILEHOME) FROM TAXDIST WHERE @cTDList LIKE '%'+TAXDISTRIC+'%' or @cTDList='all')
+
(SELECT SUM(TIMBER100) FROM TAXDIST WHERE @cTDList LIKE '%'+TAXDISTRIC+'%' or @cTDList='all')
) AS GROSSDIGEST
, MIN(TT.MILLS) AS MILLS
from calcexemptions c
LEFT JOIN (SELECT TAXTYPE, MIN(MILLS) AS MILLS, MIN(GROSS_MILLS) AS GROSS_MILLS FROM MILLRATE GROUP BY TAXTYPE) TT ON TT.TAXTYPE=C.TAXTYPE
left join TAXTYPE t on t.TAXTYPE = c.TAXTYPE
left join
(
select SUM(case when digclass not in ('E','F') then value40 else 0 end) as GROSSDIGEST
from
(
select
DIGCLASS
,digstrat
,COUNT(*) as [Count]
,SUM(value40) as Value40
,SUM(ACRES) as Acres
, 1 as Sort
from cons_value
where
digclass is not null and
DIGSTRAT is not null and
DIGCLASS = 'R'
group by DIGCLASS,digstrat
--order by DIGCLASS,digstrat
UNION -- ****
select
DIGCLASS
,digstrat
,COUNT(*) as [Count]
,SUM(value40) as Value40
,SUM(ACRES) as Acres
, 2 as Sort
from cons_value
where
digclass is not null and
DIGSTRAT is not null and
DIGCLASS = 'H'
group by DIGCLASS,digstrat
--order by DIGCLASS,digstrat
UNION -- ****
select
DIGCLASS
,digstrat
,COUNT(*) as [Count]
,SUM(value40) as Value40
,SUM(ACRES) as Acres
, 3 as Sort
from cons_value
where
digclass is not null and
DIGSTRAT is not null and
DIGCLASS = 'A'
group by DIGCLASS,digstrat
--order by DIGCLASS,digstrat
UNION -- ****
select
DIGCLASS
,digstrat
,COUNT(*) as [Count]
,SUM(value40) as Value40
,SUM(ACRES) as Acres
, 4 as Sort
from cons_value
where
digclass is not null and
DIGSTRAT is not null and
DIGCLASS = 'P'
group by DIGCLASS,digstrat
--order by DIGCLASS,digstrat
UNION -- ****
select
DIGCLASS
,digstrat
,COUNT(*) as [Count]
,SUM(value40) as Value40
,SUM(ACRES) as Acres
, 5 as Sort
from cons_value
where
digclass is not null and
DIGSTRAT is not null and
DIGCLASS = 'V'
group by DIGCLASS,digstrat
--order by DIGCLASS,digstrat
UNION -- ****
select
DIGCLASS
,digstrat
,COUNT(*) as [Count]
,SUM(value40) as Value40
,SUM(ACRES) as Acres
, 6 as Sort
from cons_value
where
digclass is not null and
DIGSTRAT is not null and
DIGCLASS = 'J'
group by DIGCLASS,digstrat
--order by DIGCLASS,digstrat
UNION -- ****
select
DIGCLASS
,digstrat
,COUNT(*) as [Count]
,SUM(value40) as Value40
,SUM(ACRES) as Acres
, 7 as Sort
from cons_value
where
digclass is not null and
DIGSTRAT is not null and
DIGCLASS = 'F'
group by DIGCLASS,digstrat
--order by DIGCLASS,digstrat
UNION -- ****
select
DIGCLASS
,digstrat
,COUNT(*) as [Count]
,SUM(value40) as Value40
,SUM(ACRES) as Acres
, 7 as Sort
from cons_value
where
digclass is not null and
DIGSTRAT is not null and
DIGCLASS = 'Q'
group by DIGCLASS,digstrat
--order by DIGCLASS,digstrat
UNION -- ****
select
DIGCLASS
,digstrat
,COUNT(*) as [Count]
,SUM(value40) as Value40
,SUM(ACRES) as Acres
, 8 as Sort
from cons_value
where
digclass is not null and
DIGSTRAT is not null and
DIGCLASS = 'C'
group by DIGCLASS,digstrat
--order by DIGCLASS,digstrat
UNION -- ****
select
DIGCLASS
,digstrat
,COUNT(*) as [Count]
,SUM(value40) as Value40
,SUM(ACRES) as Acres
, 9 as Sort
from cons_value
where
digclass is not null and
DIGSTRAT is not null and
DIGCLASS = 'I'
group by DIGCLASS,digstrat
--order by DIGCLASS,digstrat
UNION -- ****
select
DIGCLASS
,digstrat
,COUNT(*) as [Count]
,SUM(value40) as Value40
,SUM(ACRES) as Acres
, 9 as Sort
from cons_value
where
digclass is not null and
DIGSTRAT is not null and
DIGCLASS = 'B'
group by DIGCLASS,digstrat
--order by DIGCLASS,digstrat
UNION -- ****
select
DIGCLASS
,digstrat
,COUNT(*) as [Count]
,SUM(value40) as Value40
,SUM(ACRES) as Acres
, 9 as Sort
from cons_value
where
digclass is not null and
DIGSTRAT is not null and
DIGCLASS = 'T'
group by DIGCLASS,digstrat
--order by DIGCLASS,digstrat
UNION -- ****
select
DIGCLASS
,digstrat
,COUNT(*) as [Count]
,SUM(value40) as Value40
,SUM(ACRES) as Acres
, 10 as Sort
from cons_value
where
digclass is not null and
DIGSTRAT is not null and
DIGCLASS = 'U'
group by DIGCLASS,digstrat
--order by DIGCLASS,digstrat
UNION -- ****
select
DIGCLASS
,digstrat
,COUNT(*) as [Count]
,SUM(value40) as Value40
,SUM(ACRES) as Acres
, 11 as Sort
from cons_value
where
digclass is not null and
DIGSTRAT is not null and
DIGCLASS = 'E'
group by DIGCLASS,digstrat
--order by DIGCLASS,digstrat
union
select
'1' as DIGCLASS
, SPACE(2) as DIGSTRAT
, SUM(MVCOUNT) AS COUNT
, SUM(MOTORVEH) as VALUE40
, 0 as ACRES
, 12 as Sort
from TAXDIST
where @cTDList LIKE '%'+TAXDISTRIC+'%' or @cTDList='all'
union
select
'2' as DIGCLASS
, SPACE(2) as DIGSTRAT
, SUM(MHCOUNT) AS COUNT
, SUM(MOBILEHOME) as VALUE40
, 0 as ACRES
, 13 as Sort
from TAXDIST
where @cTDList LIKE '%'+TAXDISTRIC+'%' or @cTDList='all'
union
select
'3' as DIGCLASS
, SPACE(2) as DIGSTRAT
, SUM(TICOUNT) AS COUNT
, SUM(TIMBER100) as VALUE40
, 0 as ACRES
, 14 as Sort
from TAXDIST
where @cTDList LIKE '%'+TAXDISTRIC+'%' or @cTDList='all'
union
select
'4' as DIGCLASS
, SPACE(2) as DIGSTRAT
, SUM(HECOUNT) AS COUNT
, SUM(HEAVYEQUIP) as VALUE40
, 0 as ACRES
, 15 as Sort
from TAXDIST
where @cTDList LIKE '%'+TAXDISTRIC+'%' or @cTDList='all'
) a
) d on 1=1
where
(c.excode <> 'SH' and c.ACT_EXEMPT>0
or
c.EXCODE = 'SH')
and
(
c.perskey in (select PERSKEY from D_PERS where (@cTDList like '%'+TAXDISTRIC+'%' or @cTDList='all') and PROPCLASS <> 'E' and perskey>0 and PERSKEY in (select perskey from cons_value) )
or
c.realkey in (select realkey from D_REAL where (@cTDList like '%'+TAXDISTRIC+'%' or @cTDList='all') and digclass <> 'E' and realkey>0 and REALKEY in (select realkey from cons_value) )
)
group by c.excode, c.taxtype, t.DESCRIP
order by c.taxtype, c.EXCODE
true
excode
System.String
taxtype
System.Int16
DESCRIP
System.String
Count
System.Int32
ID
System.Int64
GROSSDIGEST
System.Int64
MILLS
System.Decimal
String
matrix-pc
ReportSvr
String
ay2009
ReportDB
String
TD list passed from Wingap
cTDList
true
String
true
TD Names List
Integer
nTaxtype
String
true
cTaxTypeName
en-US
true
Inch
27d42830-b54d-4333-a887-59026520d6af