0 SQL ="data source=" & Parameters!ReportSvr.Value & "; Initial Catalog=" & Parameters!ReportDB.Value true Integrated 7714b739-c185-4b74-9633-8858a731f2a9 GatcsDB =Parameters!bill_no.Value =Parameters!bill_year.Value =Parameters!bill_type.Value SELECT B.BILL_YEAR , B.BILL_NO , VB.TOTAL_BALANCE - VB.INTEREST_BALANCE - VB.PENALTY_BALANCE - VB.FIFA_BALANCE AS BASE_AMT , VB.INTEREST_BALANCE AS INTEREST , VB.PENALTY_BALANCE AS PENALTY , VB.FIFA_BALANCE AS FIFA , VB.TOTAL_BALANCE AS TOTAL , D.CONAME , D2.TC_NAME , O.LASTNAME , O.ADDRESS1 , O.ADDRESS2 , O.ADDRESS3 , O.CITY , O.STATE , O.ZIP , CONCAT(LTRIM(RTRIM(O.LASTNAME)) ,CHAR(13)+CHAR(10) ,LTRIM(RTRIM(O.ADDRESS1)),CASE WHEN LEN(RTRIM(LTRIM(O.ADDRESS1)))>0 THEN CHAR(13)+CHAR(10) ELSE '' END ,LTRIM(RTRIM(O.ADDRESS2)),CASE WHEN LEN(RTRIM(LTRIM(O.ADDRESS2)))>0 THEN CHAR(13)+CHAR(10) ELSE '' END ,LTRIM(RTRIM(O.ADDRESS3)),CASE WHEN LEN(RTRIM(LTRIM(O.ADDRESS3)))>0 THEN CHAR(13)+CHAR(10) ELSE '' END , LTRIM(RTRIM(O.CITY)) ,' ' , LTRIM(RTRIM(O.STATE)) , ' ' , LTRIM(RTRIM(O.ZIP)) ) AS ADDRESSBLOCK , P.PARCEL_NO , P.PERSKEY , P.REALKEY , P.MOBILEKEY , P.MHMFG , P.MHMODEL , P.MHSIZE , P.LEGAL_DESC , P.PROPTYPE FROM VBILL B INNER JOIN vBILL_BALANCE_7 VB ON VB.BILL_NO=B.BILL_NO AND VB.BILL_TYPE=B.BILL_TYPE AND VB.BILL_YEAR=B.BILL_YEAR LEFT JOIN VPROPERTY P ON P.PROPERTYKEY=B.PROPERTYKEY AND P.DIGYR=B.BILL_YEAR AND P.PROPTYPE=B.BILL_TYPE LEFT JOIN DEFAULTS D ON 1=1 LEFT JOIN DEFAULTS2 D2 on 1=1 LEFT JOIN VOWNER O ON O.BILL_NO=B.BILL_NO AND B.BILL_YEAR=O.BILL_YEAR AND B.BILL_TYPE=O.BILL_TYPE WHERE B.BILL_NO=@bill_no AND B.BILL_YEAR=@bill_year AND B.BILL_TYPE=@bill_type true BILL_NO System.Int32 BILL_YEAR System.Int16 CONAME System.String BASE_AMT System.Decimal INTEREST System.Decimal PENALTY System.Decimal FIFA System.Decimal TOTAL System.Decimal TC_NAME System.String LASTNAME System.String ADDRESS1 System.String ADDRESS2 System.String ADDRESS3 System.String CITY System.String STATE System.String ZIP System.String ADDRESSBLOCK System.String PARCEL_NO System.String PERSKEY System.Int32 REALKEY System.Int32 MOBILEKEY System.Int32 MHMFG System.String MHMODEL System.String MHSIZE System.String LEGAL_DESC System.String PROPTYPE System.String 1.24479in 0.75in 0.75in 0.75in 0.75in 0.75in 0.75in 0.75in 1in 0.6875in true true =TRIM(UCASE(Fields!CONAME.Value)) + " COUNTY TAX FI. FA." + vbCRLF + "STATE OF GEORGIA" Property Description: =IIF( TRIM(Fields!PROPTYPE.Value) = "R", TRIM(Fields!PARCEL_NO.Value) & vbCRLF & TRIM(Fields!LEGAL_DESC.Value), IIF( TRIM(Fields!PROPTYPE.Value) = "P", TRIM(Fields!PERSKEY.Value) & VBCRLF & TRIM(Fields!LEGAL_DESC.Value), IIF( TRIM(Fields!PROPTYPE.Value) = "M", TRIM(Fields!MHMFG.Value)&"/"&TRIM(Fields!MHMODEL.Value)&" "&TRIM(Fields!MHSIZE.Value), "UNKNOWN"))) Textbox22 2pt 2pt 2pt 2pt 9 0.86458in true true = "STATE OF GEORGIA" + vbCRLF + "COUNTY OF JEFF DAVIS " VERSUS =Fields!ADDRESSBLOCK.Value Textbox1 Top 2pt 2pt 2pt 2pt 9 0.22in true true Textbox33 2pt 2pt 2pt 2pt true true YEAR textbox2 Black 1pt Black 1pt Black 1pt Black 1pt 2pt 2pt 2pt 2pt true true BILL textbox3 Black 1pt Black 1pt Black 1pt Black 1pt 2pt 2pt 2pt 2pt true true BASE AMT Textbox10 Black 1pt Black 1pt Black 1pt Black 1pt 2pt 2pt 2pt 2pt true true INTEREST textbox5 Black 1pt Black 1pt Black 1pt Black 1pt 2pt 2pt 2pt 2pt true true PENALTY textbox6 Black 1pt Black 1pt Black 1pt Black 1pt 2pt 2pt 2pt 2pt true true FIFA textbox7 Black 1pt Black 1pt Black 1pt Black 1pt 2pt 2pt 2pt 2pt true true TOTAL textbox8 Black 1pt Black 1pt Black 1pt Black 1pt 2pt 2pt 2pt 2pt true true Textbox90 2pt 2pt 2pt 2pt 0.21in true true Textbox34 2pt 2pt 2pt 2pt true true =Fields!BILL_YEAR.Value BILL_YEAR Black 1pt Black 1pt Black 1pt Black 1pt 2pt 2pt 2pt 2pt true true =Fields!BILL_NO.Value BILL_NO Black 1pt Black 1pt Black 1pt Black 1pt 2pt 2pt 2pt 2pt true true =Fields!BASE_AMT.Value BASE_AMT 2pt 2pt 2pt 2pt en-US true true =Fields!INTEREST.Value INTEREST Black 1pt Black 1pt Black 1pt Black 1pt 2pt 2pt 2pt 2pt true true =Fields!PENALTY.Value PENALTY Black 1pt Black 1pt Black 1pt Black 1pt 2pt 2pt 2pt 2pt true true =Fields!FIFA.Value FIFA Black 1pt Black 1pt Black 1pt Black 1pt 2pt 2pt 2pt 2pt true true =Fields!TOTAL.Value TOTAL Black 1pt Black 1pt Black 1pt Black 1pt 2pt 2pt 2pt 2pt true true Textbox91 2pt 2pt 2pt 2pt 0.25in true true Textbox39 2pt 2pt 2pt 2pt true true Textbox40 2pt 2pt 2pt 2pt true true Textbox41 2pt 2pt 2pt 2pt true true Textbox42 2pt 2pt 2pt 2pt true true Textbox43 2pt 2pt 2pt 2pt true true Textbox44 2pt 2pt 2pt 2pt true true Textbox45 2pt 2pt 2pt 2pt true true Textbox46 2pt 2pt 2pt 2pt true true Textbox92 2pt 2pt 2pt 2pt 0.25in true true TO ALL AND SINGULAR THE SHERIFFS AND CONSTABLES OF THIS STATE, GREETINGS: Textbox47 2pt 2pt 2pt 2pt 9 0.15in true true Textbox55 2pt 2pt 2pt 2pt true true Textbox56 2pt 2pt 2pt 2pt true true Textbox57 2pt 2pt 2pt 2pt true true Textbox58 2pt 2pt 2pt 2pt true true Textbox59 2pt 2pt 2pt 2pt true true Textbox60 2pt 2pt 2pt 2pt true true Textbox61 2pt 2pt 2pt 2pt true true Textbox62 2pt 2pt 2pt 2pt true true Textbox94 2pt 2pt 2pt 2pt 0.94792in true true YOU ARE HEREBY COMMANDED, that of the goods, chattels, lands and tenements of the stated taxpayer, you cause to be made by levy and sale sufficient thereof to make the sum of the dollars and cents within shown, the amount of school, state, and county taxes for the stated year(s), the further FI. FA. sum as stated for the FI. FA. and a sufficient amount to cover interest on said principal taxes at the rate specified by law, beginning from that certain due date until settled, together with all cost that may hereinafter accrue; and have you the said sum of money to be paid to me upon collection thereof, to be rendered to the state, county, the principal, penalties, interest, and cost aforesaid; and have you then and there this writ. Textbox63 2pt 2pt 2pt 2pt 9 0.22917in true true ="Given under my hand this " & Parameters!THIS_DAY.Value Textbox79 2pt 2pt 2pt 2pt 8 true true Textbox97 2pt 2pt 2pt 2pt 0.03125in true true Textbox98 2pt 2pt 2pt 2pt true true Textbox99 2pt 2pt 2pt 2pt true true Textbox100 2pt 2pt 2pt 2pt true true Textbox101 2pt 2pt 2pt 2pt true true Textbox102 2pt 2pt 2pt 2pt true true Textbox103 2pt 2pt 2pt 2pt true true Textbox104 2pt 2pt 2pt 2pt true true Textbox105 2pt 2pt 2pt 2pt true true Textbox106 2pt 2pt 2pt 2pt 0.875in true true Textbox107 2pt 2pt 2pt 2pt true true Textbox108 2pt 2pt 2pt 2pt true true Textbox109 2pt 2pt 2pt 2pt true true Textbox110 2pt 2pt 2pt 2pt true true Textbox111 2pt 2pt 2pt 2pt Embedded Signature FitProportional 4 0.25in true true Textbox116 2pt 2pt 2pt 2pt true true Textbox117 2pt 2pt 2pt 2pt true true Textbox118 2pt 2pt 2pt 2pt true true Textbox119 2pt 2pt 2pt 2pt true true Textbox120 2pt 2pt 2pt 2pt true true =trim(Fields!TC_NAME.Value)+ vbCRLF + "Tax Commissioner, " + trim(Fields!CONAME.Value)+ " County " + vbCRLF + "Ex-Officio Sheriff " + trim(Fields!CONAME.Value)+ " County " + vbCRLF + "State of Georgia" TC_NAME Black 1pt 2pt 2pt 2pt 2pt 3 true true Textbox124 Black 1pt 2pt 2pt 2pt 2pt 0.51458in true true ENTRY OF LEVY: I have levied the within Fieri Facias upon property of named Defendant so described and identified above by tax map parcel number. This _______________________________ day of ____________________________________, ________. Textbox134 2pt 2pt 2pt 2pt 9 0.35417in true true Textbox143 2pt 2pt 2pt 2pt true true Textbox144 Black 1pt 2pt 2pt 2pt 2pt true true Textbox145 Black 1pt 2pt 2pt 2pt 2pt true true Textbox146 Black 1pt 2pt 2pt 2pt 2pt true true Textbox147 Black 1pt 2pt 2pt 2pt 2pt true true Textbox148 Black 1pt 2pt 2pt 2pt 2pt true true ="Ex-Officio Sheriff" + trim(Fields!CONAME.Value) + " County " TC_NAME Bottom 2pt 2pt 2pt 2pt 3 0.25in true true Textbox200 2pt 2pt 2pt 2pt true true Textbox201 2pt 2pt 2pt 2pt true true Textbox202 2pt 2pt 2pt 2pt true true Textbox203 2pt 2pt 2pt 2pt true true Textbox204 2pt 2pt 2pt 2pt true true Textbox205 2pt 2pt 2pt 2pt true true Textbox206 Bottom 2pt 2pt 2pt 2pt true true Textbox207 Bottom 2pt 2pt 2pt 2pt true true Textbox208 Bottom 2pt 2pt 2pt 2pt After true After true After true true Detail Detail_Collection Output true DataSet1 6.08416in 7.49479in 0.5in 0.5in 0.5in