Help on Report

[Jeff Harrison]

It's been a while, but I think that you can leverage the min and max functions for this. 
In your processing at line 1 (before the @brk) do something like ;Aa=min(acctfield) ; ab=max(acctfield) 
Now you can reference aa and ab when you are at the break and will have the expected values. 

Sent from Yahoo Mail on Android 
 
  On Wed, Jul 15, 2020 at 1:59 AM, scooter6--- via Filepro-list<filepro-list at lists.celestial.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> 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>
_______________________________________________
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/20200715/5a657b03/attachment.html>