0 SQL ="data source=" & Parameters!ReportSvr.Value & "; Initial Catalog=" & Parameters!ReportDB.Value true Integrated cfdeac3a-833c-419d-b4b8-08971a950d67 GatcsDB =Parameters!START_DATE.Value =Parameters!END_DATE.Value SELECT * FROM vPAYMENT WHERE CONVERT(DATE,PAYMENTDATE) BETWEEN @START_DATE AND @END_DATE AND PAYMENT_TYPE NOT IN ('REFUND','WRITE-OFF') ORDER BY RECID true RECID System.Int32 PAYMENTKEY System.Int32 BILLKEY System.Int32 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 PAYMENT_TYPE System.String PAID_BY System.String BALANCE_DUE System.Decimal CARD_TYPE System.String AUTH_CODE System.String PAYMENTDATE System.DateTime CNUM System.Decimal COMPNAME System.String LOGINID System.String REGISTER System.Int32 EXCESS_FUNDS System.Decimal OVERAGES System.Decimal FEES System.Decimal FEES_OTHER System.Decimal COMMENTS System.String COLLECT_FEES System.Decimal BILL_YEAR System.Int16 BILL_NO System.Int32 REVERSAL System.Boolean CHANGE System.Decimal PAID_AMT System.Decimal BILL_TYPE System.String DBNAME System.Boolean GatcsDB =Parameters!START_DATE.Value =Parameters!END_DATE.Value SELECT * FROM vPAYMENT WHERE CONVERT(DATE,PAYMENTDATE) BETWEEN @START_DATE AND @END_DATE AND PAYMENT_TYPE NOT IN ('REFUND','WRITE-OFF') AND BILL_TYPE IN ('R','P') ORDER BY RECID RECID System.Int32 PAYMENTKEY System.Int32 BILLKEY System.Int32 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 PAYMENT_TYPE System.String PAID_BY System.String BALANCE_DUE System.Decimal CARD_TYPE System.String AUTH_CODE System.String PAYMENTDATE System.DateTime CNUM System.Int64 COMPNAME System.String LOGINID System.String REGISTER System.Int32 EXCESS_FUNDS System.Decimal OVERAGES System.Decimal FEES System.Decimal FEES_OTHER System.Decimal COMMENTS System.String COLLECT_FEES System.Decimal BILL_YEAR System.Int16 BILL_NO System.Int32 REVERSAL System.Boolean CHANGE System.Decimal PAID_AMT System.Decimal BILL_TYPE System.String REFUND System.Boolean UNPAID System.Boolean ACCTING System.Boolean ACCTING_DATE System.DateTime ACTUAL_DATE System.DateTime ABATEMENT System.Decimal CHECK_TOTAL System.Decimal DBNAME System.String GatcsDB =Parameters!START_DATE.Value =Parameters!END_DATE.Value SELECT * FROM vPAYMENT WHERE CONVERT(DATE,PAYMENTDATE) BETWEEN @START_DATE AND @END_DATE AND PAYMENT_TYPE NOT IN ('REFUND','WRITE-OFF') AND BILL_TYPE IN ('M') ORDER BY RECID RECID System.Int32 PAYMENTKEY System.Int32 BILLKEY System.Int32 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 PAYMENT_TYPE System.String PAID_BY System.String BALANCE_DUE System.Decimal CARD_TYPE System.String AUTH_CODE System.String PAYMENTDATE System.DateTime CNUM System.Int64 COMPNAME System.String LOGINID System.String REGISTER System.Int32 EXCESS_FUNDS System.Decimal OVERAGES System.Decimal FEES System.Decimal FEES_OTHER System.Decimal COMMENTS System.String COLLECT_FEES System.Decimal BILL_YEAR System.Int16 BILL_NO System.Int32 REVERSAL System.Boolean CHANGE System.Decimal PAID_AMT System.Decimal BILL_TYPE System.String REFUND System.Boolean UNPAID System.Boolean ACCTING System.Boolean ACCTING_DATE System.DateTime ACTUAL_DATE System.DateTime ABATEMENT System.Decimal CHECK_TOTAL System.Decimal DBNAME System.String GatcsDB =Parameters!START_DATE.Value =Parameters!END_DATE.Value SELECT * FROM vPAYMENT WHERE CONVERT(DATE,PAYMENTDATE) BETWEEN @START_DATE AND @END_DATE AND PAYMENT_TYPE NOT IN ('REFUND','WRITE-OFF') AND BILL_TYPE IN ('H') ORDER BY RECID RECID System.Int32 PAYMENTKEY System.Int32 BILLKEY System.Int32 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 PAYMENT_TYPE System.String PAID_BY System.String BALANCE_DUE System.Decimal CARD_TYPE System.String AUTH_CODE System.String PAYMENTDATE System.DateTime CNUM System.Int64 COMPNAME System.String LOGINID System.String REGISTER System.Int32 EXCESS_FUNDS System.Decimal OVERAGES System.Decimal FEES System.Decimal FEES_OTHER System.Decimal COMMENTS System.String COLLECT_FEES System.Decimal BILL_YEAR System.Int16 BILL_NO System.Int32 REVERSAL System.Boolean CHANGE System.Decimal PAID_AMT System.Decimal BILL_TYPE System.String REFUND System.Boolean UNPAID System.Boolean ACCTING System.Boolean ACCTING_DATE System.DateTime ACTUAL_DATE System.DateTime ABATEMENT System.Decimal CHECK_TOTAL System.Decimal DBNAME System.String GatcsDB =Parameters!START_DATE.Value =Parameters!END_DATE.Value SELECT * FROM vPAYMENT WHERE CONVERT(DATE,PAYMENTDATE) BETWEEN @START_DATE AND @END_DATE AND PAYMENT_TYPE NOT IN ('REFUND','WRITE-OFF') AND BILL_TYPE IN ('T') ORDER BY RECID RECID System.Int32 PAYMENTKEY System.Int32 BILLKEY System.Int32 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 PAYMENT_TYPE System.String PAID_BY System.String BALANCE_DUE System.Decimal CARD_TYPE System.String AUTH_CODE System.String PAYMENTDATE System.DateTime CNUM System.Int64 COMPNAME System.String LOGINID System.String REGISTER System.Int32 EXCESS_FUNDS System.Decimal OVERAGES System.Decimal FEES System.Decimal FEES_OTHER System.Decimal COMMENTS System.String COLLECT_FEES System.Decimal BILL_YEAR System.Int16 BILL_NO System.Int32 REVERSAL System.Boolean CHANGE System.Decimal PAID_AMT System.Decimal BILL_TYPE System.String REFUND System.Boolean UNPAID System.Boolean ACCTING System.Boolean ACCTING_DATE System.DateTime ACTUAL_DATE System.DateTime ABATEMENT System.Decimal CHECK_TOTAL System.Decimal DBNAME System.String 0.66458in 0.5in 0.90416in 0.5in 0.5in 0.5in 0.5in 0.66458in 0.5in 0.5in 0.5in 0.66458in 0.5in 0.5in 0.79167in 0.79167in 1.07083in 0.25in true true ALL PROPERTY TYPES Textbox296 SteelBlue 2pt 2pt 2pt 2pt 17 0.22in true true REGISTER textbox2 SteelBlue 2pt 2pt 2pt 2pt true true BILL NO textbox5 SteelBlue 2pt 2pt 2pt 2pt true true ADV TAX textbox6 SteelBlue 2pt 2pt 2pt 2pt true true INTEREST textbox7 SteelBlue 2pt 2pt 2pt 2pt true true PENALTY textbox8 SteelBlue 2pt 2pt 2pt 2pt true true FIFA textbox9 SteelBlue 2pt 2pt 2pt 2pt true true GED textbox10 SteelBlue 2pt 2pt 2pt 2pt true true BREACH textbox11 SteelBlue 2pt 2pt 2pt 2pt true true TITLE SEARCH textbox12 SteelBlue 2pt 2pt 2pt 2pt true true MAIL FEES textbox13 SteelBlue 2pt 2pt 2pt 2pt true true ADMIN textbox14 SteelBlue 2pt 2pt 2pt 2pt true true PRIOR YEARS textbox15 SteelBlue 2pt 2pt 2pt 2pt true true ADVERT textbox16 SteelBlue 2pt 2pt 2pt 2pt true true FEES Textbox19 SteelBlue 2pt 2pt 2pt 2pt true true COLLECT FEES Textbox17 SteelBlue 2pt 2pt 2pt 2pt true true OVERAGES Textbox137 SteelBlue 2pt 2pt 2pt 2pt true true TOTAL textbox18 SteelBlue 2pt 2pt 2pt 2pt 0.2in true true =Fields!REGISTER.Value 2pt 2pt 2pt 2pt true true =COUNT(Fields!BILL_NO.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!ADV_TAX.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!INTEREST.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!PENALTY.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!FIFA.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!GED.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!BREACH.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!TITLE_SEARCH.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!MAIL_FEES.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!ADMINISTRATION.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!PRIOR_YEARS.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!ADVERTISING.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!FEES.Value+Fields!FEES_OTHER.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!COLLECT_FEES.Value) 2pt 2pt 2pt 2pt true true =SUM(Fields!OVERAGES.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!TOTAL.Value+Fields!OVERAGES.Value) 2pt 2pt 2pt 2pt 0.2in true true 2pt 2pt 2pt 2pt true true =Fields!BILL_NO.Value 2pt 2pt 2pt 2pt true true =Fields!ADV_TAX.Value 2pt 2pt 2pt 2pt true true =Fields!INTEREST.Value 2pt 2pt 2pt 2pt true true =Fields!PENALTY.Value 2pt 2pt 2pt 2pt true true =Fields!FIFA.Value 2pt 2pt 2pt 2pt true true =Fields!GED.Value 2pt 2pt 2pt 2pt true true =Fields!BREACH.Value 2pt 2pt 2pt 2pt true true =Fields!TITLE_SEARCH.Value 2pt 2pt 2pt 2pt true true =Fields!MAIL_FEES.Value 2pt 2pt 2pt 2pt true true =Fields!ADMINISTRATION.Value 2pt 2pt 2pt 2pt true true =Fields!PRIOR_YEARS.Value 2pt 2pt 2pt 2pt true true =Fields!ADVERTISING.Value 2pt 2pt 2pt 2pt true true =Fields!FEES.Value+Fields!FEES_OTHER.Value 2pt 2pt 2pt 2pt true true =Fields!COLLECT_FEES.Value 2pt 2pt 2pt 2pt true true =Fields!OVERAGES.Value 2pt 2pt 2pt 2pt true true =Fields!TOTAL.Value+Fields!OVERAGES.Value 2pt 2pt 2pt 2pt 0.2in true true Khaki 2pt 2pt 2pt 2pt true true =COUNT(Fields!BILL_NO.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!ADV_TAX.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!INTEREST.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!PENALTY.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!FIFA.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!GED.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!BREACH.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!TITLE_SEARCH.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!MAIL_FEES.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!ADMINISTRATION.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!PRIOR_YEARS.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!ADVERTISING.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!FEES.Value+Fields!FEES_OTHER.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!COLLECT_FEES.Value) Khaki 2pt 2pt 2pt 2pt true true =SUM(Fields!OVERAGES.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!TOTAL.Value+Fields!OVERAGES.Value) Khaki 2pt 2pt 2pt 2pt After true After true true =Fields!REGISTER.Value =Fields!REGISTER.Value After true Detail true REGISTER Detail_Collection Output true Before DataSet1 0.36in 1.07in 10.55207in 0.66458in 0.5in 0.90416in 0.5in 0.5in 0.5in 0.5in 0.66458in 0.5in 0.5in 0.5in 0.66458in 0.5in 0.5in 0.79167in 0.79167in 1.07083in 0.25in true true REAL AND PERSONAL PROPERTY Textbox312 SeaGreen 2pt 2pt 2pt 2pt 17 0.22in true true REGISTER textbox2 SeaGreen 2pt 2pt 2pt 2pt true true BILL NO textbox5 SeaGreen 2pt 2pt 2pt 2pt true true ADV TAX textbox6 SeaGreen 2pt 2pt 2pt 2pt true true INTEREST textbox7 SeaGreen 2pt 2pt 2pt 2pt true true PENALTY textbox8 SeaGreen 2pt 2pt 2pt 2pt true true FIFA textbox9 SeaGreen 2pt 2pt 2pt 2pt true true GED textbox10 SeaGreen 2pt 2pt 2pt 2pt true true BREACH textbox11 SeaGreen 2pt 2pt 2pt 2pt true true TITLE SEARCH textbox12 SeaGreen 2pt 2pt 2pt 2pt true true MAIL FEES textbox13 SeaGreen 2pt 2pt 2pt 2pt true true ADMIN textbox14 SeaGreen 2pt 2pt 2pt 2pt true true PRIOR YEARS textbox15 SeaGreen 2pt 2pt 2pt 2pt true true ADVERT textbox16 SeaGreen 2pt 2pt 2pt 2pt true true FEES Textbox19 SeaGreen 2pt 2pt 2pt 2pt true true COLLECT FEES Textbox17 SeaGreen 2pt 2pt 2pt 2pt true true OVERAGES Textbox141 SeaGreen 2pt 2pt 2pt 2pt true true TOTAL textbox18 SeaGreen 2pt 2pt 2pt 2pt 0.2in true true =Fields!REGISTER.Value 2pt 2pt 2pt 2pt true true =Count(Fields!BILL_NO.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!ADV_TAX.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!INTEREST.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!PENALTY.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!FIFA.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!GED.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!BREACH.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!TITLE_SEARCH.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!MAIL_FEES.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!ADMINISTRATION.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!PRIOR_YEARS.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!ADVERTISING.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!FEES.Value + Fields!FEES_OTHER.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!COLLECT_FEES.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!OVERAGES.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!TOTAL.Value + Fields!OVERAGES.Value) 2pt 2pt 2pt 2pt 0.2in true true =Fields!BILL_TYPE.Value 2pt 2pt 2pt 2pt true true =Fields!BILL_NO.Value 2pt 2pt 2pt 2pt true true =Fields!ADV_TAX.Value 2pt 2pt 2pt 2pt true true =Fields!INTEREST.Value 2pt 2pt 2pt 2pt true true =Fields!PENALTY.Value 2pt 2pt 2pt 2pt true true =Fields!FIFA.Value 2pt 2pt 2pt 2pt true true =Fields!GED.Value 2pt 2pt 2pt 2pt true true =Fields!BREACH.Value 2pt 2pt 2pt 2pt true true =Fields!TITLE_SEARCH.Value 2pt 2pt 2pt 2pt true true =Fields!MAIL_FEES.Value 2pt 2pt 2pt 2pt true true =Fields!ADMINISTRATION.Value 2pt 2pt 2pt 2pt true true =Fields!PRIOR_YEARS.Value 2pt 2pt 2pt 2pt true true =Fields!ADVERTISING.Value 2pt 2pt 2pt 2pt true true =Fields!FEES.Value + Fields!FEES_OTHER.Value 2pt 2pt 2pt 2pt true true =Fields!COLLECT_FEES.Value 2pt 2pt 2pt 2pt true true =Fields!OVERAGES.Value 2pt 2pt 2pt 2pt true true =Fields!TOTAL.Value + Fields!OVERAGES.Value 2pt 2pt 2pt 2pt 0.2in true true Khaki 2pt 2pt 2pt 2pt true true =Count(Fields!BILL_NO.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!ADV_TAX.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!INTEREST.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!PENALTY.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!FIFA.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!GED.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!BREACH.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!TITLE_SEARCH.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!MAIL_FEES.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!ADMINISTRATION.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!PRIOR_YEARS.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!ADVERTISING.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!FEES.Value + Fields!FEES_OTHER.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!COLLECT_FEES.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!OVERAGES.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!TOTAL.Value + Fields!OVERAGES.Value) Khaki 2pt 2pt 2pt 2pt After true After true true =Fields!REGISTER.Value =Fields!REGISTER.Value After true Detail true REGISTER2 Detail_Collection Output true Before DataSet_RP 1.58104in 1.07in 10.55207in 2 Textbox328 SlateBlue 2pt 2pt 2pt 2pt 17 0.22in true true REGISTER textbox2 SlateBlue 2pt 2pt 2pt 2pt true true BILL NO textbox5 SlateBlue 2pt 2pt 2pt 2pt true true ADV TAX textbox6 SlateBlue 2pt 2pt 2pt 2pt true true INTEREST textbox7 SlateBlue 2pt 2pt 2pt 2pt true true PENALTY textbox8 SlateBlue 2pt 2pt 2pt 2pt true true FIFA textbox9 SlateBlue 2pt 2pt 2pt 2pt true true GED textbox10 SlateBlue 2pt 2pt 2pt 2pt true true BREACH textbox11 SlateBlue 2pt 2pt 2pt 2pt true true TITLE SEARCH textbox12 SlateBlue 2pt 2pt 2pt 2pt true true MAIL FEES textbox13 SlateBlue 2pt 2pt 2pt 2pt true true ADMIN textbox14 SlateBlue 2pt 2pt 2pt 2pt true true PRIOR YEARS textbox15 SlateBlue 2pt 2pt 2pt 2pt true true ADVERT textbox16 SlateBlue 2pt 2pt 2pt 2pt true true FEES Textbox19 SlateBlue 2pt 2pt 2pt 2pt true true COLLECT FEES Textbox17 SlateBlue 2pt 2pt 2pt 2pt true true OVERAGES Textbox145 SlateBlue 2pt 2pt 2pt 2pt true true TOTAL textbox18 SlateBlue 2pt 2pt 2pt 2pt 0.2in true true =Fields!REGISTER.Value 2pt 2pt 2pt 2pt true true =Count(Fields!BILL_NO.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!ADV_TAX.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!INTEREST.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!PENALTY.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!FIFA.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!GED.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!BREACH.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!TITLE_SEARCH.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!MAIL_FEES.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!ADMINISTRATION.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!PRIOR_YEARS.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!ADVERTISING.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!FEES.Value + Fields!FEES_OTHER.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!COLLECT_FEES.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!OVERAGES.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!TOTAL.Value + Fields!OVERAGES.Value) 2pt 2pt 2pt 2pt 0.2in true true =Fields!BILL_TYPE.Value 2pt 2pt 2pt 2pt true true =Fields!BILL_NO.Value 2pt 2pt 2pt 2pt true true =Fields!ADV_TAX.Value 2pt 2pt 2pt 2pt true true =Fields!INTEREST.Value 2pt 2pt 2pt 2pt true true =Fields!PENALTY.Value 2pt 2pt 2pt 2pt true true =Fields!FIFA.Value 2pt 2pt 2pt 2pt true true =Fields!GED.Value 2pt 2pt 2pt 2pt true true =Fields!BREACH.Value 2pt 2pt 2pt 2pt true true =Fields!TITLE_SEARCH.Value 2pt 2pt 2pt 2pt true true =Fields!MAIL_FEES.Value 2pt 2pt 2pt 2pt true true =Fields!ADMINISTRATION.Value 2pt 2pt 2pt 2pt true true =Fields!PRIOR_YEARS.Value 2pt 2pt 2pt 2pt true true =Fields!ADVERTISING.Value 2pt 2pt 2pt 2pt true true =Fields!FEES.Value + Fields!FEES_OTHER.Value 2pt 2pt 2pt 2pt true true =Fields!COLLECT_FEES.Value 2pt 2pt 2pt 2pt true true =Fields!OVERAGES.Value 2pt 2pt 2pt 2pt true true =Fields!TOTAL.Value + Fields!OVERAGES.Value 2pt 2pt 2pt 2pt 0.2in true true Khaki 2pt 2pt 2pt 2pt true true =Count(Fields!BILL_NO.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!ADV_TAX.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!INTEREST.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!PENALTY.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!FIFA.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!GED.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!BREACH.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!TITLE_SEARCH.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!MAIL_FEES.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!ADMINISTRATION.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!PRIOR_YEARS.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!ADVERTISING.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!FEES.Value + Fields!FEES_OTHER.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!COLLECT_FEES.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!OVERAGES.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!TOTAL.Value + Fields!OVERAGES.Value) Khaki 2pt 2pt 2pt 2pt After true After true true =Fields!REGISTER.Value =Fields!REGISTER.Value After true Detail true REGISTER3 Detail_Collection Output true Before DataSet_M 2.83104in 1.07in 10.55207in 3 Textbox344 DarkSalmon 2pt 2pt 2pt 2pt 17 0.22in true true REGISTER textbox2 DarkSalmon 2pt 2pt 2pt 2pt true true BILL NO textbox5 DarkSalmon 2pt 2pt 2pt 2pt true true ADV TAX textbox6 DarkSalmon 2pt 2pt 2pt 2pt true true INTEREST textbox7 DarkSalmon 2pt 2pt 2pt 2pt true true PENALTY textbox8 DarkSalmon 2pt 2pt 2pt 2pt true true FIFA textbox9 DarkSalmon 2pt 2pt 2pt 2pt true true GED textbox10 DarkSalmon 2pt 2pt 2pt 2pt true true BREACH textbox11 DarkSalmon 2pt 2pt 2pt 2pt true true TITLE SEARCH textbox12 DarkSalmon 2pt 2pt 2pt 2pt true true MAIL FEES textbox13 DarkSalmon 2pt 2pt 2pt 2pt true true ADMIN textbox14 DarkSalmon 2pt 2pt 2pt 2pt true true PRIOR YEARS textbox15 DarkSalmon 2pt 2pt 2pt 2pt true true ADVERT textbox16 DarkSalmon 2pt 2pt 2pt 2pt true true FEES Textbox19 DarkSalmon 2pt 2pt 2pt 2pt true true COLLECT FEES Textbox17 DarkSalmon 2pt 2pt 2pt 2pt true true OVERAGES Textbox149 DarkSalmon 2pt 2pt 2pt 2pt true true TOTAL textbox18 DarkSalmon 2pt 2pt 2pt 2pt 0.2in true true =Fields!REGISTER.Value 2pt 2pt 2pt 2pt true true =Count(Fields!BILL_NO.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!ADV_TAX.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!INTEREST.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!PENALTY.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!FIFA.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!GED.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!BREACH.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!TITLE_SEARCH.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!MAIL_FEES.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!ADMINISTRATION.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!PRIOR_YEARS.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!ADVERTISING.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!FEES.Value + Fields!FEES_OTHER.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!COLLECT_FEES.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!OVERAGES.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!TOTAL.Value + Fields!OVERAGES.Value) 2pt 2pt 2pt 2pt 0.2in true true =Fields!BILL_TYPE.Value 2pt 2pt 2pt 2pt true true =Fields!BILL_NO.Value 2pt 2pt 2pt 2pt true true =Fields!ADV_TAX.Value 2pt 2pt 2pt 2pt true true =Fields!INTEREST.Value 2pt 2pt 2pt 2pt true true =Fields!PENALTY.Value 2pt 2pt 2pt 2pt true true =Fields!FIFA.Value 2pt 2pt 2pt 2pt true true =Fields!GED.Value 2pt 2pt 2pt 2pt true true =Fields!BREACH.Value 2pt 2pt 2pt 2pt true true =Fields!TITLE_SEARCH.Value 2pt 2pt 2pt 2pt true true =Fields!MAIL_FEES.Value 2pt 2pt 2pt 2pt true true =Fields!ADMINISTRATION.Value 2pt 2pt 2pt 2pt true true =Fields!PRIOR_YEARS.Value 2pt 2pt 2pt 2pt true true =Fields!ADVERTISING.Value 2pt 2pt 2pt 2pt true true =Fields!FEES.Value + Fields!FEES_OTHER.Value 2pt 2pt 2pt 2pt true true =Fields!COLLECT_FEES.Value 2pt 2pt 2pt 2pt true true =Fields!OVERAGES.Value 2pt 2pt 2pt 2pt true true =Fields!TOTAL.Value + Fields!OVERAGES.Value 2pt 2pt 2pt 2pt 0.2in true true Khaki 2pt 2pt 2pt 2pt true true =Count(Fields!BILL_NO.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!ADV_TAX.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!INTEREST.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!PENALTY.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!FIFA.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!GED.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!BREACH.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!TITLE_SEARCH.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!MAIL_FEES.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!ADMINISTRATION.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!PRIOR_YEARS.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!ADVERTISING.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!FEES.Value + Fields!FEES_OTHER.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!COLLECT_FEES.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!OVERAGES.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!TOTAL.Value + Fields!OVERAGES.Value) Khaki 2pt 2pt 2pt 2pt After true After true true =Fields!REGISTER.Value =Fields!REGISTER.Value After true Detail true REGISTER4 Detail_Collection Output true Before DataSet_H 3.97802in 1.07in 10.55207in 4 Textbox360 Blue 2pt 2pt 2pt 2pt 17 0.22in true true REGISTER textbox2 Blue 2pt 2pt 2pt 2pt true true BILL NO textbox5 Blue 2pt 2pt 2pt 2pt true true ADV TAX textbox6 Blue 2pt 2pt 2pt 2pt true true INTEREST textbox7 Blue 2pt 2pt 2pt 2pt true true PENALTY textbox8 Blue 2pt 2pt 2pt 2pt true true FIFA textbox9 Blue 2pt 2pt 2pt 2pt true true GED textbox10 Blue 2pt 2pt 2pt 2pt true true BREACH textbox11 Blue 2pt 2pt 2pt 2pt true true TITLE SEARCH textbox12 Blue 2pt 2pt 2pt 2pt true true MAIL FEES textbox13 Blue 2pt 2pt 2pt 2pt true true ADMIN textbox14 Blue 2pt 2pt 2pt 2pt true true PRIOR YEARS textbox15 Blue 2pt 2pt 2pt 2pt true true ADVERT textbox16 Blue 2pt 2pt 2pt 2pt true true FEES Textbox19 Blue 2pt 2pt 2pt 2pt true true COLLECT FEES Textbox17 Blue 2pt 2pt 2pt 2pt true true OVERAGES Textbox153 Blue 2pt 2pt 2pt 2pt true true TOTAL textbox18 Blue 2pt 2pt 2pt 2pt 0.2in true true =Fields!REGISTER.Value 2pt 2pt 2pt 2pt true true =Count(Fields!BILL_NO.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!ADV_TAX.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!INTEREST.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!PENALTY.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!FIFA.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!GED.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!BREACH.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!TITLE_SEARCH.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!MAIL_FEES.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!ADMINISTRATION.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!PRIOR_YEARS.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!ADVERTISING.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!FEES.Value + Fields!FEES_OTHER.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!COLLECT_FEES.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!OVERAGES.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!TOTAL.Value + Fields!OVERAGES.Value) 2pt 2pt 2pt 2pt 0.2in true true =Fields!BILL_TYPE.Value 2pt 2pt 2pt 2pt true true =Fields!BILL_NO.Value 2pt 2pt 2pt 2pt true true =Fields!ADV_TAX.Value 2pt 2pt 2pt 2pt true true =Fields!INTEREST.Value 2pt 2pt 2pt 2pt true true =Fields!PENALTY.Value 2pt 2pt 2pt 2pt true true =Fields!FIFA.Value 2pt 2pt 2pt 2pt true true =Fields!GED.Value 2pt 2pt 2pt 2pt true true =Fields!BREACH.Value 2pt 2pt 2pt 2pt true true =Fields!TITLE_SEARCH.Value 2pt 2pt 2pt 2pt true true =Fields!MAIL_FEES.Value 2pt 2pt 2pt 2pt true true =Fields!ADMINISTRATION.Value 2pt 2pt 2pt 2pt true true =Fields!PRIOR_YEARS.Value 2pt 2pt 2pt 2pt true true =Fields!ADVERTISING.Value 2pt 2pt 2pt 2pt true true =Fields!FEES.Value + Fields!FEES_OTHER.Value 2pt 2pt 2pt 2pt true true =Fields!COLLECT_FEES.Value 2pt 2pt 2pt 2pt true true =Fields!OVERAGES.Value 2pt 2pt 2pt 2pt true true =Fields!TOTAL.Value + Fields!OVERAGES.Value 2pt 2pt 2pt 2pt 0.2in true true Khaki 2pt 2pt 2pt 2pt true true =Count(Fields!BILL_NO.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!ADV_TAX.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!INTEREST.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!PENALTY.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!FIFA.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!GED.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!BREACH.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!TITLE_SEARCH.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!MAIL_FEES.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!ADMINISTRATION.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!PRIOR_YEARS.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!ADVERTISING.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!FEES.Value + Fields!FEES_OTHER.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!COLLECT_FEES.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!OVERAGES.Value) Khaki 2pt 2pt 2pt 2pt true true =Sum(Fields!TOTAL.Value + Fields!OVERAGES.Value) Khaki 2pt 2pt 2pt 2pt After true After true true =Fields!REGISTER.Value =Fields!REGISTER.Value After true Detail true REGISTER5 Detail_Collection Output true Before DataSet_T 5.17651in 1.07in 10.55207in 5 ExecutionTime 0.15292in 0.25in 3.32292in 2pt 2pt 2pt 2pt true true Katie and Mady picked these colors 2pt 2pt 2pt 2pt 8.5in 11in 0.5in 0.5in 0.5in 0.5in