SQL ="data source=" & Parameters!ReportSvr.Value & "; Initial Catalog=" & Parameters!ReportDB.Value true 5bfe5b49-555b-45e4-a4b8-c825f23c847c RECID System.Int32 REALKEY System.Int32 PARCEL_NO System.String PERSKEY System.Int32 ACCKEY System.Int32 REPROPKEY System.Int32 COMMKEY System.Int32 DIGCLASS System.String DIGSTRAT System.String VALUE40 System.Int64 ACRES System.Decimal LASTNAME_R System.String FIRSTNAME_R System.String MIDDLE_R System.String LASTNAME_P System.String FIRSTNAME_P System.String MIDDLE_P System.String HOUSE_NO System.Int32 EXTENSION System.String STDIRECT System.String STREET_NAM System.String STTYPE System.String ST_NUM System.Int32 ST_EXT System.String ST_DIRECT System.String ST_NAME System.String ST_TYPE System.String WingapDB select c.* , O.lastname AS LASTNAME_R , O.firstname AS FIRSTNAME_R , O.middle AS MIDDLE_R , OP.lastname AS LASTNAME_P , OP.firstname AS FIRSTNAME_P , OP.middle AS MIDDLE_P , r.HOUSE_NO , r.EXTENSION , r.STDIRECT , r.STREET_NAM , r.STTYPE , p.ST_NUM , p.ST_EXT , p.ST_DIRECT , p.ST_NAME , p.ST_TYPE from cons_value c left join D_REAL r on r.realkey = c.realkey LEFT JOIN OWNER O ON O.OWNKEY = R.OWNKEY left join D_PERS p on p.perskey = c.perskey LEFT JOIN OWNER OP ON OP.OWNKEY = P.OWNKEY where C.digclass = @Class and C.digstrat=@Strat order by C.realkey, P.perskey =Parameters!Class.Value =Parameters!Strat.Value true 1in 1in 1in 0.36458in 0.8125in 1in 2.55208in 2.27083in 0.22in true true REALKEY textbox2 SteelBlue 2pt 2pt 2pt 2pt true true PARCEL NO Textbox1 SteelBlue 2pt 2pt 2pt 2pt true true PERSKEY textbox3 SteelBlue 2pt 2pt 2pt 2pt true true C/S SteelBlue 2pt 2pt 2pt 2pt true true ACRES textbox6 SteelBlue 2pt 2pt 2pt 2pt true true VALUE40 textbox7 SteelBlue 2pt 2pt 2pt 2pt true true NAME Textbox9 SteelBlue 2pt 2pt 2pt 2pt true true ADDRESS Textbox12 SteelBlue 2pt 2pt 2pt 2pt 0.21in true true =Fields!REALKEY.Value 2pt 2pt 2pt 2pt true true =Fields!PARCEL_NO.Value 2pt 2pt 2pt 2pt true true =Fields!PERSKEY.Value 2pt 2pt 2pt 2pt true true =Fields!DIGCLASS.Value+Fields!DIGSTRAT.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!REALKEY.Value>0, TRIM(TRIM(Fields!LASTNAME_R.Value)+" "+TRIM(Fields!FIRSTNAME_R.Value)+" "+TRIM(Fields!MIDDLE_R.Value)), TRIM(TRIM(Fields!LASTNAME_P.Value)+" "+TRIM(Fields!FIRSTNAME_P.Value)+" "+TRIM(Fields!MIDDLE_P.Value)) ) 2pt 2pt 2pt 2pt true true =IIF(Fields!REALKEY.Value>0, TRIM(TRIM(CSTR(Fields!HOUSE_NO.Value))+" "+TRIM(Fields!EXTENSION.Value)+" "+TRIM(Fields!STDIRECT.Value)+" "+TRIM(Fields!STREET_NAM.Value)+" "+TRIM(Fields!STTYPE.Value)), TRIM(TRIM(CSTR(Fields!ST_NUM.Value))+" "+TRIM(Fields!ST_EXT.Value)+" "+TRIM(Fields!ST_DIRECT.Value)+" "+TRIM(Fields!ST_NAME.Value)+" "+TRIM(Fields!ST_TYPE.Value)) ) 2pt 2pt 2pt 2pt 0.25in true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true =count(Fields!VALUE40.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!ACRES.Value) 2pt 2pt 2pt 2pt 2 true true =Sum(Fields!VALUE40.Value) 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt After true true Detail Detail_Collection Output true Before DataSet1 0.36in 0.68in 9.99999in 1.04in