SQL ="data source=" & Parameters!ReportSvr.Value & "; Initial Catalog=" & Parameters!ReportDB.Value true 831f310c-4fd8-4d14-afad-485fcf437d8b REALKEY System.Int32 PERSKEY System.Int32 TAXTYPE System.Int16 EXCODE System.String COV_HS System.String ACT_EXEMPT System.Int64 DESCRIP System.String PARCEL_NO System.String WingapDB SELECT C.REALKEY , C.PERSKEY , C.TAXTYPE , C.EXCODE , C.COV_HS , C.ACT_EXEMPT , T.DESCRIP , CASE WHEN C.REALKEY > 0 THEN R.PARCEL_NO ELSE P.PARCEL_NO END AS PARCEL_NO FROM dbo.calcexemptions C INNER JOIN dbo.taxtype T ON C.TAXTYPE = T.TAXTYPE LEFT JOIN DBO.D_REAL R ON R.REALKEY = C.REALKEY LEFT JOIN DBO.D_PERS P ON P.PERSKEY = C.PERSKEY true true true ExemptionCodes 0.85417in 2.67708in 0.71875in 0.75in 1in 1in 0.22in true true TAXTYPE textbox2 SteelBlue 2pt 2pt 2pt 2pt true true EXCODE SteelBlue 2pt 2pt 2pt 2pt true true REALKEY textbox6 SteelBlue 2pt 2pt 2pt 2pt true true PERSKEY textbox7 SteelBlue 2pt 2pt 2pt 2pt true true COV HS SteelBlue 2pt 2pt 2pt 2pt true true ACT EXEMPT textbox9 SteelBlue 2pt 2pt 2pt 2pt 0.21in true true =Fields!TAXTYPE.Value #6e9eca 2pt 2pt 2pt 2pt true true =Fields!DESCRIP.Value #6e9eca 2pt 2pt 2pt 2pt true true =Count(Fields!REALKEY.Value) #6e9eca 2pt 2pt 2pt 2pt true true #6e9eca 2pt 2pt 2pt 2pt true true #6e9eca 2pt 2pt 2pt 2pt true true =Sum(Fields!ACT_EXEMPT.Value) #6e9eca 2pt 2pt 2pt 2pt 0.21in true true SlateGray 2pt 2pt 2pt 2pt true true =Fields!EXCODE.Value SlateGray 2pt 2pt 2pt 2pt true true =Count(Fields!REALKEY.Value) SlateGray 2pt 2pt 2pt 2pt true true SlateGray 2pt 2pt 2pt 2pt true true SlateGray 2pt 2pt 2pt 2pt true true =Sum(Fields!ACT_EXEMPT.Value) SlateGray 2pt 2pt 2pt 2pt 0.21in true true 2pt 2pt 2pt 2pt true true =Fields!PARCEL_NO.Value 2pt 2pt 2pt 2pt true true true =Fields!REALKEY.Value 2pt 2pt 2pt 2pt true true =Fields!PERSKEY.Value 2pt 2pt 2pt 2pt true true =Fields!COV_HS.Value 2pt 2pt 2pt 2pt true true =Fields!ACT_EXEMPT.Value 2pt 2pt 2pt 2pt After true true =Fields!TAXTYPE.Value =Fields!TAXTYPE.Value After true =Fields!EXCODE.Value =Fields!EXCODE.Value After true Detail true EXCODE Detail_Collection Output true true TAXTYPE DataSet1 0.36in 0.85in 7in 1