Help on Report

[Bruce Easton]

Not sure if this was posted yesterday - I didn't get any reply.  By the 
way, as of today, my email address is new.

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
>