Help on Report

[scooter6 at gmail.com]

I guess that's the part I'm struggling with - since I'm using index for
date, the first record it finds may not be the lowest number in that 'batch'
Would it be better to create an index on date and full account number, then
grab the first 'acct'?
thanks


On Mon, Jul 13, 2020 at 3:59 PM Bruce Easton via Filepro-list <
filepro-list at lists.celestial.com> wrote:

> Scott - if the only problem is the Starting Acct#, then, are you using a
> global field to track when the Starting Acct# is less than one
> previously encountered within a Ctl#?   (And then resetting it back to
> an arbitrarily high value when you start a new Ctl# after reporting the
> Ctl#?)
>
> Bruce
>
>
> On 7/13/20 2:12 PM, scooter6--- via Filepro-list wrote:
> > I have a database that has this type structure
> >
> > Clt             Acct          Full Acct                  Date Received
> > -------         ---------      ----------------------
> >   -----------------------
> > 01234        00010      01234-00010          06/01/20
> > 01234        00011      01234-00011           06/01/20
> > 01234        00012      01234-00012           06/05/20
> > 01234        00013      01234-00013           06/10/20
> > 01235        00250      01235-00250           06/01/20
> > 01235        00251      01235-00251           06/05/20
> >
> > I want to create a report with oldest received date first and a 'summary'
> > line for each batch then in Clt number order
> >
> > For example, for the above data set, I want to see
> >
> > Date Rec'd      Clt             Starting Acct      Ending Acct
> Total
> > in Batch
> > ---------------      -----------    -----------------
> > ----------------         ------------------
> > 06/01/20           01234        00010               00011
> >           2
> > 06/01/20           01235        00250               00250
> >           1
> >                            Total Received 06/01/20
> >                3
> >
> > 06/05/20           01234        00012               00012
> >           1
> > 06/05/20           01235        00251               00251
> >           1
> >                             Total Received 06/05/20
> >               2
> >
> > 06/10/20           01234        00013               00013
> >           1
> >                              Total Received 06/10/20
> >                1
> >
> >
> > 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
> >
> > I'm using sort order of Date Rec'd and descending and subtotal and
> subtotal
> > on Clt
> > Running this rreport with -ih  (index H which is Date Rec'd)
> >
> > I can post full processing table if that helps - but each report dataline
> > is a field in the actual file
> > 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
> >
> > thanks
> > Scott
> > PDM
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> > URL: <
> http://mailman.celestial.com/pipermail/filepro-list/attachments/20200713/7231d1b1/attachment.html
> >
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > Subscribe/Unsubscribe/Subscription Changes
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20200714/670932b6/attachment.html>