0 SQL ="data source=" & Parameters!ReportSvr.Value & "; Initial Catalog=" & Parameters!ReportDB.Value true Integrated 36c8aa63-580e-498f-972a-a8de8085a748 GatcsDB =Parameters!TOTALDUE.Value =Parameters!NUMPAYMENT.Value SELECT * --AMORT_AMT, BALANCE_REMAINING FROM ( SELECT TOP 300 ROUND(CONVERT(REAL,@TOTALDUE)/CONVERT(INT,@NUMPAYMENT),2) AS AMORT_AMT , @TOTALDUE - ROW_NUMBER() OVER( ORDER BY RECID) * (ROUND(CONVERT(REAL,@TOTALDUE)/CONVERT(INT,@NUMPAYMENT),2)) AS BALANCE_REMAINING , ROW_NUMBER() OVER( ORDER BY RECID) AS ROWID FROM TAXDETAIL ) X WHERE BALANCE_REMAINING > 0 true BALANCE_REMAINING System.Double AMORT_AMT System.Double ROWID System.Int64 1in 1.59375in 1.6875in 0.22in true true Payment # Textbox9 SteelBlue 2pt 2pt 2pt 2pt true true Monthly Payment Textbox18 SteelBlue 2pt 2pt 2pt 2pt true true BALANCE REMAINING Textbox7 SteelBlue 2pt 2pt 2pt 2pt 0.21in true true =Fields!ROWID.Value 2pt 2pt 2pt 2pt true true =Fields!AMORT_AMT.Value 2pt 2pt 2pt 2pt en-US true true =Fields!BALANCE_REMAINING.Value 2pt 2pt 2pt 2pt en-US 0.25in true true =Last(Fields!ROWID.Value)+1 2pt 2pt 2pt 2pt true true =Last(Fields!BALANCE_REMAINING.Value) 2pt 2pt 2pt 2pt en-US true true =0 2pt 2pt 2pt 2pt After true true Detail Detail_Collection Output true Before DataSet1 0.36in 0.68in 4.28125in 1.04in Textbox19 Payment Plan-TargetPayment =Parameters!TOTALDUE.Value =Parameters!ReportSvr.Value =Parameters!ReportDB.Value 0.165in 0.25in 4.28125in LightGreen 2pt 2pt 2pt 2pt true true Description_______________________________ Date_______________ 2pt 2pt 2pt 2pt 1in 1in 1in 1in