Segoe UI 0 SQL ="data source=" & Parameters!ReportSvr.Value & "; Initial Catalog=" & Parameters!ReportDB.Value true Integrated 1f5002f8-d4d4-42d2-9f94-41f2339832c7 GatcsDB =Parameters!ASMT.Value select p.PARCEL_NO , p.REALKEY , p.PERSKEY , o.LASTNAME , o.ADDRESS1 , o.ADDRESS2 , o.ADDRESS3 , o.CITY , o.STATE , o.ZIP , p.TAXDISTRIC , t.DESCRIP , b.BILL_NO , b.BILL_TYPE , p.CURR_VAL , p.PREV_VAL , p.CURR_VAL*@ASMT as ASMT from BILL b inner join PROPERTY p on b.PROPERTYKEY = p.PROPERTYKEY inner join VOWNER o on b.BILL_NO = o.BILL_NO and b.BILL_YEAR = o.BILL_YEAR inner join TAXDIST t on p.TAXDISTRIC = t.TAXDISTRIC where b.UTILITY = 1 true PARCEL_NO System.String REALKEY System.Int32 PERSKEY System.Int32 LASTNAME System.String ADDRESS1 System.String ADDRESS2 System.String ADDRESS3 System.String CITY System.String STATE System.String ZIP System.String TAXDISTRIC System.String DESCRIP System.String BILL_NO System.Int32 BILL_TYPE System.String CURR_VAL System.Int64 PREV_VAL System.Int64 ASMT System.Int64 true true Public_Utilities 2.84375in 0.92709in 1.35417in 1in 1in 1in 1in 1in 1in 0.22in true true LASTNAME LightBlue 2pt 2pt 2pt 2pt true true BILL-TYPE LightBlue 2pt 2pt 2pt 2pt true true PARCEL NO LightBlue 2pt 2pt 2pt 2pt true true REAL ACT textbox3 LightBlue 2pt 2pt 2pt 2pt true true PERS ACT textbox4 LightBlue 2pt 2pt 2pt 2pt true true TAXDIST textbox12 LightBlue 2pt 2pt 2pt 2pt true true CURRENT Textbox49 LightBlue 2pt 2pt 2pt 2pt true true PREVIOUS Textbox55 LightBlue 2pt 2pt 2pt 2pt true true ASMT Textbox18 LightBlue 2pt 2pt 2pt 2pt 0.2in true true =trim(Fields!LASTNAME.Value) 2pt 2pt 2pt 2pt true true =Fields!BILL_NO.Value & "-" & Fields!BILL_TYPE.Value 2pt 2pt 2pt 2pt true true =trim(Fields!PARCEL_NO.Value) 2pt 2pt 2pt 2pt true true =Fields!REALKEY.Value REALKEY 2pt 2pt 2pt 2pt true true =Fields!PERSKEY.Value PERSKEY 2pt 2pt 2pt 2pt true true =Fields!TAXDISTRIC.Value & "-" & trim(Fields!DESCRIP.Value) TAXDISTRIC 2pt 2pt 2pt 2pt true true =Fields!CURR_VAL.Value CURR_VAL 2pt 2pt 2pt 2pt true true =Fields!PREV_VAL.Value PREV_VAL 2pt 2pt 2pt 2pt true true =Fields!ASMT.Value ASMT 2pt 2pt 2pt 2pt 0.2in true true =Fields!ADDRESS1.Value 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true Textbox9 2pt 2pt 2pt 2pt true true Textbox10 2pt 2pt 2pt 2pt true true Textbox11 2pt 2pt 2pt 2pt true true Textbox51 2pt 2pt 2pt 2pt true true Textbox57 2pt 2pt 2pt 2pt true true Textbox24 2pt 2pt 2pt 2pt 0.2in true true =Fields!ADDRESS2.Value 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true Textbox21 2pt 2pt 2pt 2pt true true Textbox22 2pt 2pt 2pt 2pt true true Textbox23 2pt 2pt 2pt 2pt true true Textbox52 2pt 2pt 2pt 2pt true true Textbox58 2pt 2pt 2pt 2pt true true Textbox25 2pt 2pt 2pt 2pt 0.2in true true =Fields!ADDRESS3.Value 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true Textbox29 2pt 2pt 2pt 2pt true true Textbox30 2pt 2pt 2pt 2pt true true Textbox31 2pt 2pt 2pt 2pt true true Textbox53 2pt 2pt 2pt 2pt true true Textbox59 2pt 2pt 2pt 2pt true true Textbox26 2pt 2pt 2pt 2pt 0.2in true true =trim(Fields!CITY.Value) & ", " & Fields!STATE.Value & " " & Fields!ZIP.Value Black 3pt 2pt 2pt 2pt 2pt true true Black 3pt 2pt 2pt 2pt 2pt true true Black 3pt 2pt 2pt 2pt 2pt true true Textbox37 Black 3pt 2pt 2pt 2pt 2pt true true Textbox38 Black 3pt 2pt 2pt 2pt 2pt true true Textbox39 Black 3pt 2pt 2pt 2pt 2pt true true Textbox54 Black 3pt 2pt 2pt 2pt 2pt true true Textbox60 Black 3pt 2pt 2pt 2pt 2pt true true Textbox27 Black 3pt 2pt 2pt 2pt 2pt 0.2in true true 2pt 2pt 2pt 2pt true true =count(Fields!CURR_VAL.Value) Textbox83 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true Textbox80 2pt 2pt 2pt 2pt true true Textbox81 2pt 2pt 2pt 2pt true true Textbox82 2pt 2pt 2pt 2pt true true =Sum(Fields!CURR_VAL.Value) Textbox83 2pt 2pt 2pt 2pt true true =Sum(Fields!PREV_VAL.Value) Textbox84 2pt 2pt 2pt 2pt true true =Sum(Fields!ASMT.Value) Textbox32 2pt 2pt 2pt 2pt After true true Detail =Len(Trim(Fields!ADDRESS1.Value))=0 =Len(Trim(Fields!ADDRESS2.Value))=0 =Len(Trim(Fields!ADDRESS3.Value))=0 Detail_Collection Output true Before DataSet1 0.43in 1.42in 11.125in 1