0 SQL ="data source=" & Parameters!ReportSvr.Value & "; Initial Catalog=" & Parameters!ReportDB.Value true Integrated e5ef2057-6b40-4ff6-9f65-3fd4039cb873 GatcsDB SELECT B.*, Q.NAME , Q.PARCEL_NO FROM VBILL B INNER JOIN VQP_SEARCH Q ON Q.BILL_NO=B.BILL_NO AND Q.BILL_YEAR = B.BILL_YEAR WHERE B.BALANCE_DUE>0 AND B.BILL_NO NOT IN (SELECT BILL_NO FROM BILL_TRANSACTIONS WHERE T_TYPE='WRITEOFF') ORDER BY B.BILL_NO true RECID System.Int32 BILLKEY System.Int32 PROPERTYKEY System.Int32 BILL_NO System.Int32 BILL_YEAR System.Int16 BILL_TYPE System.String TIMBER_VALUE System.Int64 TIMBER_ACRES System.Decimal PROPERTY_ACRES System.Decimal ADV_TAX System.Decimal INTEREST System.Decimal PENALTY System.Decimal FIFA System.Decimal GED System.Decimal BREACH System.Decimal TITLE_SEARCH System.Decimal MAIL_FEES System.Decimal ADMINISTRATION System.Decimal PRIOR_YEARS System.Decimal ADVERTISING System.Decimal CREDIT_CARD_FEES System.Decimal TOTAL System.Decimal BALANCE_DUE System.Decimal DUE_DATE System.DateTime EXCESS_FUNDS System.Decimal OVERAGES System.Decimal FEES System.Decimal FEES_OTHER System.Decimal COMMENTS System.String COLLECT_FEES System.Decimal DBNAME System.String CHANGE System.Decimal INSTALL_1 System.Decimal INSTALL_2 System.Decimal FIFA_DATE System.DateTime UTILITY System.Boolean ORG_ADVTAX System.Decimal ORG_TOTAL System.Decimal ORG_FEES System.Decimal ORG_FEES_OTHER System.Decimal NAME System.String ABATEMENT System.Decimal BILL_DATE System.DateTime PARCEL_NO System.String 1in 1in 1in 1in 1in 1in 0.22in true true BILL YEAR textbox2 SteelBlue 2pt 2pt 2pt 2pt true true BILL TYPE SteelBlue 2pt 2pt 2pt 2pt true true BILL NUMBER textbox6 SteelBlue 2pt 2pt 2pt 2pt true true ADV TAX textbox7 SteelBlue 2pt 2pt 2pt 2pt true true BALANCE DUE Textbox17 SteelBlue 2pt 2pt 2pt 2pt true true PARCEL NO Textbox3 SteelBlue 2pt 2pt 2pt 2pt 0.21in true true =Fields!BILL_YEAR.Value #6e9eca 2pt 2pt 2pt 2pt true true #6e9eca 2pt 2pt 2pt 2pt true true =count(Fields!BILL_NO.Value) #6e9eca 2pt 2pt 2pt 2pt true true =Sum(Fields!ADV_TAX.Value) #6e9eca 2pt 2pt 2pt 2pt true true =Sum(Fields!BALANCE_DUE.Value) #6e9eca 2pt 2pt 2pt 2pt true true #6e9eca 2pt 2pt 2pt 2pt 0.21in true true SlateGray 2pt 2pt 2pt 2pt true true =Fields!BILL_TYPE.Value SlateGray 2pt 2pt 2pt 2pt true true =count(Fields!BILL_NO.Value) SlateGray 2pt 2pt 2pt 2pt true true =Sum(Fields!ADV_TAX.Value) SlateGray 2pt 2pt 2pt 2pt true true =Sum(Fields!BALANCE_DUE.Value) SlateGray 2pt 2pt 2pt 2pt true true SlateGray 2pt 2pt 2pt 2pt 0.21in true true =Fields!NAME.Value 2pt 2pt 2pt 2pt 2 true true =Fields!BILL_NO.Value 2pt 2pt 2pt 2pt true true =Fields!ADV_TAX.Value 2pt 2pt 2pt 2pt true true =Fields!BALANCE_DUE.Value 2pt 2pt 2pt 2pt true true =Fields!PARCEL_NO.Value 2pt 2pt 2pt 2pt After true true =Fields!BILL_YEAR.Value =Fields!BILL_YEAR.Value After true =Fields!BILL_TYPE.Value =Fields!BILL_TYPE.Value After true Detail true BILL_TYPE Detail_Collection Output true true BILL_YEAR DataSet1 0.36in 0.85in 6in 1.21in ExecutionTime 0.15125in 0.25in 3in 2pt 2pt 2pt 2pt true true =User!UserID 2pt 2pt 2pt 2pt 1in 1in 1in 1in