<div dir="ltr">I have a database that has this type structure<div><br></div><div>Clt             Acct          Full Acct                  Date Received</div><div>-------         ---------      ----------------------     -----------------------</div><div>01234        00010      01234-00010          06/01/20</div><div>01234        00011      01234-00011           06/01/20</div><div>01234        00012      01234-00012           06/05/20</div><div>01234        00013      01234-00013           06/10/20</div><div>01235        00250      01235-00250           06/01/20</div><div>01235        00251      01235-00251           06/05/20</div><div><br></div><div>I want to create a report with oldest received date first and a 'summary' line for each batch then in Clt number order</div><div><br></div><div>For example, for the above data set, I want to see</div><div><br></div><div>Date Rec'd      Clt             Starting Acct      Ending Acct        Total in Batch</div><div>---------------      -----------    -----------------      ----------------         ------------------</div><div>06/01/20           01234        00010               00011                           2</div><div>06/01/20           01235        00250               00250                           1</div><div>                          Total Received 06/01/20                                        3</div><div><br></div><div>06/05/20           01234        00012               00012                           1</div><div>06/05/20           01235        00251               00251                           1</div><div>                           Total Received 06/05/20                                       2</div><div><br></div><div>06/10/20           01234        00013               00013                           1</div><div>                            Total Received 06/10/20                                      1</div><div><br></div><div><br></div><div>When I do @wbrk1 - I can get the Ending Account and the Total but even if I declare the Starting Acct before @wbrk1 - both variables still come out the same - so I'm apparently missing something there</div><div><br></div><div>I'm using sort order of Date Rec'd and descending and subtotal and subtotal on Clt </div><div>Running this rreport with -ih  (index H which is Date Rec'd)</div><div><br></div><div>I can post full processing table if that helps - but each report dataline is a field in the actual file</div><div>There is a little more I'm doing with it other than this, but it's really just displaying a few of the other fields - so didn't want to confuse by posting the full prc table</div><div><br></div><div>thanks </div><div>Scott</div><div>PDM</div><div><br></div><div><br></div><div><br></div><div><br></div></div>