Help on Report

[scooter6 at gmail.com]

Ahh ok gotcha
So to subtotal by oldest date first, my sort on output is        date
rec'd    descending and x (since I don't want form feed) then 1 (clt#) ?

On Tue, Jul 14, 2020 at 12:52 PM Bruce Easton <bruce at stn.com> wrote:

> First, an assumption.  I'm assuming that your Ctl as referenced for one
> 'batch' is the same critter as the first part of your full Acct# based
> on what you've shown.
>
> Just use a couple of global dummy fields to keep track of the lowest and
> highest within one ctl.  Below. 'acct_no' can be replaced by your field
> number for the account number field.
>
>    If: lo eq ""'these 6 lines execute for EVERY rec processed
> Then: lo="~~~~~"
>    If:acct_no lt lo
> Then: lo(5,*,g)=acct_no
>    If: acct_ho gt hi
> Then: hi(5,*,g)=acct_no
>    If:
> Then: end
> .
> .
> @wbrk1 If:   '<--minor sort (Ctl)
>       Then: print; hi=""; lo="~~~~~"; end
>
> @wbrk2 If:   '<--major sort (Date Recv'd)
>       Then: [whatever you're doing now]; print; end
>
>
> On 7/14/20 10:21 AM, scooter6 at gmail.com wrote:
> > 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
> > <mailto: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
> >     <mailto: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
> >     <mailto: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/be925d51/attachment.html>