SQL ="data source=" & Parameters!ReportSvr.Value & "; Initial Catalog=" & Parameters!ReportDB.Value true 94413088-cf03-43c5-8057-cb5a894c0ddc DIGCLASS System.String DIGSTRAT System.String COUNT System.Int32 Value40 System.Int64 Acres System.Decimal Sort System.Int32 TaxableValue System.Int64 TaxableAcres System.Decimal F_ACRES System.Decimal RP_VAL System.Int64 PP_VAL System.Int64 WingapDB select DIGCLASS , DIGSTRAT , [COUNT] , Acres , Value40 , Sort , case when digclass not in ('E','F') then value40 else 0 end as TaxableValue , case when digclass not in ('E','F') then Acres else 0 end as TaxableAcres , case when digclass not in ('E','F') and digstrat in ('1','2','3','4','5','6','9') then value40 else 0 end as RP_VAL , case when digclass not in ('E','F') and digstrat not in (' ','1','2','3','4','5','6','9') then value40 else 0 end as PP_VAL , case when digclass = 'F' then ACRES else 0 end as F_ACRES 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 order by Sort,DIGCLASS,DIGSTRAT =Parameters!cTDList.Value true 1in 1in 1in 1in 1.45833in 1in 0.2in true true SteelBlue 2pt 2pt 2pt 2pt true true Code SteelBlue 2pt 2pt 2pt 2pt true true Count textbox5 SteelBlue 2pt 2pt 2pt 2pt true true Acres textbox6 SteelBlue 2pt 2pt 2pt 2pt true true 40% Value textbox7 SteelBlue 2pt 2pt 2pt 2pt true true Textbox1 2pt 2pt 2pt 2pt 0.2in true true =IIF(Fields!DIGCLASS.Value="1","MV", iif(Fields!DIGCLASS.Value="2","MH", IIF(Fields!DIGCLASS.Value="3","TIMBER", IIF(Fields!DIGCLASS.Value="4","HDE",Fields!DIGCLASS.Value) ) ) ) #6e9eca 2pt 2pt 2pt 2pt true true #6e9eca 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value) #6e9eca 2pt 2pt 2pt 2pt true true =Sum(Fields!Acres.Value) #6e9eca 2pt 2pt 2pt 2pt true true =Sum(Fields!Value40.Value) #6e9eca 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt 0.2in true true 2pt 2pt 2pt 2pt true true =Fields!DIGCLASS.Value+Fields!digstrat.Value LightGreen 2pt 2pt 2pt 2pt true true =Fields!Count.Value 2pt 2pt 2pt 2pt true true =Fields!Acres.Value 2pt 2pt 2pt 2pt true true =Fields!Value40.Value 2pt 2pt 2pt 2pt true true =iif( Fields!DIGCLASS.Value+Fields!digstrat.Value = "C6" or Fields!DIGCLASS.Value+Fields!digstrat.Value = "I6" or Fields!DIGCLASS.Value+Fields!digstrat.Value = "T6" or Fields!DIGCLASS.Value+Fields!digstrat.Value = "P1" or Fields!DIGCLASS.Value+Fields!digstrat.Value = "V1" or Fields!DIGCLASS.Value+Fields!digstrat.Value = "J1" or Fields!DIGCLASS.Value+Fields!digstrat.Value = "J6" or Fields!DIGCLASS.Value+Fields!digstrat.Value = "H4" or Fields!DIGCLASS.Value+Fields!digstrat.Value = "PF" or Fields!DIGCLASS.Value+Fields!digstrat.Value = "PI" or Fields!DIGCLASS.Value+Fields!digstrat.Value = "V9" or Fields!DIGCLASS.Value+Fields!digstrat.Value = "J9" or Fields!DIGCLASS.Value+Fields!digstrat.Value = "A2" or Fields!DIGCLASS.Value+Fields!digstrat.Value = "H6" or Fields!DIGCLASS.Value+Fields!digstrat.Value = "HI" or Fields!DIGCLASS.Value+Fields!digstrat.Value = "R2" or Fields!DIGCLASS.Value+Fields!digstrat.Value = "S7" or Right(Fields!DIGCLASS.Value+Fields!digstrat.Value,1) = "?", "Invalid Digest Code","") 2pt 2pt 2pt 2pt 0.2in true true Khaki 2pt 2pt 2pt 2pt true true Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!Acres.Value)-sum(Fields!F_ACRES.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!Value40.Value) Khaki 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt 0.2in true true Gross Taxable: Acres / Value >> Textbox18 PaleTurquoise 2pt 2pt 2pt 2pt 3 true true =Sum(Fields!TaxableAcres.Value) PaleTurquoise 2pt 2pt 2pt 2pt true true =Sum(Fields!TaxableValue.Value) PaleTurquoise 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt 0.2in true true Textbox15 2pt 2pt 2pt 2pt true true Textbox16 2pt 2pt 2pt 2pt true true Total Real Property Textbox17 Khaki 2pt 2pt 2pt 2pt 2 true true =Sum(Fields!RP_VAL.Value) Khaki 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt 0.2in true true Textbox22 2pt 2pt 2pt 2pt true true Textbox23 2pt 2pt 2pt 2pt true true Total Personal Property Textbox24 Khaki 2pt 2pt 2pt 2pt 2 true true =Sum(Fields!PP_VAL.Value) Khaki 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true =Fields!Sort.Value =Fields!Sort.Value =Fields!DIGCLASS.Value =Fields!DIGCLASS.Value After true Detail DIGCLASS Detail_Collection Output true DataSet1 0.36in 1.4in 6.45833in 1.76in