0 SQL ="data source=" & Parameters!ReportSvr.Value & "; Initial Catalog=" & Parameters!ReportDB.Value true Integrated 2256f018-13a1-49f4-9a77-5bb0a6aead6e wingapDB SELECT TAXDIST , ADDONVAL , EXEMPT , CASE WHEN OVRVALUE > 0 THEN OVRVALUE WHEN GUIDE=1 THEN GUIDEVALUE ELSE VALUE END AS VALUE , CASE WHEN ISNULL(OVRVALUE,0) > 0 THEN OVRVALUE WHEN GUIDE=1 THEN ISNULL(GUIDEVALUE,0) ELSE ISNULL(VALUE,0) END + ISNULL(ADDONVAL,0) AS FMV , CASE WHEN EXEMPT=1 THEN 0 ELSE CASE WHEN ISNULL(OVRVALUE,0) > 0 THEN OVRVALUE WHEN GUIDE=1 THEN ISNULL(GUIDEVALUE,0) ELSE ISNULL(VALUE,0) END + ISNULL(ADDONVAL,0) END AS TAXABLE_FMV FROM M_MOBILE WHERE MOBTYPE=3 true TAXDIST System.String ADDONVAL System.Int32 EXEMPT System.Boolean VALUE System.Int32 FMV System.Int32 TAXABLE_FMV System.Int32 0.60417in 0.71875in 0.67708in 1in 1in 1in 1in 0.22in true true TAXDIST PaleTurquoise 2pt 2pt 2pt 2pt true true EXEMPT PaleTurquoise 2pt 2pt 2pt 2pt true true COUNT Textbox22 PaleTurquoise 2pt 2pt 2pt 2pt true true ADDONVAL textbox6 PaleTurquoise 2pt 2pt 2pt 2pt true true VALUE textbox7 PaleTurquoise 2pt 2pt 2pt 2pt true true FMV textbox8 PaleTurquoise 2pt 2pt 2pt 2pt true true ASMT VALUE Textbox29 PaleTurquoise 2pt 2pt 2pt 2pt 0.21in true true =Fields!TAXDIST.Value Khaki 2pt 2pt 2pt 2pt true true Khaki 2pt 2pt 2pt 2pt true true =Count(Fields!FMV.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!ADDONVAL.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!VALUE.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!FMV.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(round(Fields!FMV.Value*.4,0)) Khaki 2pt 2pt 2pt 2pt true 0.21in true true White 2pt 2pt 2pt 2pt true true =iif(Fields!EXEMPT.Value=TRUE,"Exempt","Taxable") White 2pt 2pt 2pt 2pt true true =Count(Fields!FMV.Value) White 2pt 2pt 2pt 2pt true true =Sum(Fields!ADDONVAL.Value) White 2pt 2pt 2pt 2pt true true =Sum(Fields!VALUE.Value) White 2pt 2pt 2pt 2pt true true =Sum(Fields!FMV.Value) White 2pt 2pt 2pt 2pt true true =Sum(Round(Fields!FMV.Value*.4,0)) White 2pt 2pt 2pt 2pt true 0.21in true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true =Fields!ADDONVAL.Value 2pt 2pt 2pt 2pt true true =Fields!VALUE.Value 2pt 2pt 2pt 2pt true true =Fields!FMV.Value 2pt 2pt 2pt 2pt true true =Round(Fields!FMV.Value*.4,0) 2pt 2pt 2pt 2pt true 0.25in true true PaleTurquoise 2pt 2pt 2pt 2pt true true PaleTurquoise 2pt 2pt 2pt 2pt true true =Count(Fields!FMV.Value) PaleTurquoise 2pt 2pt 2pt 2pt true true << GRAND TOTALS >> Textbox19 PaleTurquoise 2pt 2pt 2pt 2pt 2 true true =Sum(Fields!FMV.Value) PaleTurquoise 2pt 2pt 2pt 2pt true true =Sum(Round(Fields!FMV.Value*.4,0)) PaleTurquoise 2pt 2pt 2pt 2pt true 0.25in true true Lime 2pt 2pt 2pt 2pt true true Lime 2pt 2pt 2pt 2pt true true Lime 2pt 2pt 2pt 2pt true true Total Assessed Value >>>>>> Textbox28 Lime 2pt 2pt 2pt 2pt 2 true true =Sum(round(Fields!FMV.Value*.4,0)) Lime 2pt 2pt 2pt 2pt true true Lime 2pt 2pt 2pt 2pt 0.25in true true Lime 2pt 2pt 2pt 2pt true true Lime 2pt 2pt 2pt 2pt true true Total TAXABLE Assessed Value >>>>>> Textbox28 Lime 2pt 2pt 2pt 2pt 3 true true =Sum(System.Math.round(Fields!TAXABLE_FMV.Value * 0.4, 0)) Lime 2pt 2pt 2pt 2pt true true Lime 2pt 2pt 2pt 2pt After true true =Fields!TAXDIST.Value =Fields!TAXDIST.Value After true =Fields!EXEMPT.Value =Fields!EXEMPT.Value After true Detail true EXEMPT Detail_Collection Output true Before Before Before DataSet1 0.36in 1.6in 6in 1.96in ExecutionTime 0.17208in 0.25in 3in Black 1pt Black 1pt Black 1pt Black 1pt 2pt 2pt 2pt 2pt true true =User!UserID UserID 0.17208in 4.25in 0.25in 2.5in 1 Black 1pt Black 1pt Black 1pt Black 1pt 2pt 2pt 2pt 2pt 8.5in 11in 1in 1in 1in 1in