Help on Report

[scooter6 at gmail.com]

Only part that confused me was here

 9  -------   -   -   -   -   -   -   -   -   -   -   -   -   - -
          If: cn ne 1
        Then: cn(5,#,g)=1;la(5,#,g)="";lb(5,#,g)=""
  10  -------   -   -   -   -   -   -   -   -   -   -   -   -   - -
          If: la lt 2
        Then: la=4
  11  -------   -   -   -   -   -   -   -   -   -   -   -   -   - -
          If: 2 gt lb
        Then: lb=4

4 being the 'date' field, you're saying if la (lowest acct) lt 2 (acct#)
then you're making la = 4 which is the date field?
Should that be la=2 ?
Same on following line - if 2 gt lb then lb=4 ?


On Thu, Jul 16, 2020 at 9:32 AM Richard D. Williams via Filepro-list <
filepro-list at lists.celestial.com> wrote:

> Hi Scott,
>
> This "should" do it. (see below)
>
> Richard D. Williams
> (713) 931-9938
>
>    1  -------   -   - -   -   -   -   -   -   -   -   -   -   -   -   -   -
>           If: 'fields - 1 clt#, 2 acct#, 3 full acct#, 4 date
>         Then:
>    2  -------   -   -   -   -   -   -   -   -   -   -   -   -   - -   -   -
>           If: 'set sub-total by date and then clt#
>         Then:
>    3  -------   -   -   -   -   -   -   -   -   -   -   -   -   - -   -   -
>           If: 'in the date sub-total area use @RS to count how many
>         Then: 'record were reported on that date
>    4  -------   -   -   -   -   -   -   -   -   -   -   -   -   - -   -   -
>           If: 'in the clt# sub-total area put the variables for
>         Then: 'the lowest acct# - la and the highest acct# lb
>    5  -------   -   -   -   -   -   -   -   -   -   -   -   -   - -   -   -
>           If: '
>         Then: '
>    6  -------   -   -   -   -   -   -   -   -   -   -   -   -   - -   -   -
>           If: 'ca keeps track when the date changes and resets the
>         Then: 'lowest & highest acct numbers#
>    7  -------   -   -   -   -   -   -   -   -   -   -   -   -   - -
>           If: ca ne 4
>         Then: ca(8,mdy/,g)=4;la="";lb=""
>    8  -------   -   -   -   -   -   -   -   -   -   -   -   -   - -
>           If: 'cn keeps track when the clt3 changes and resets the
>         Then: 'lowest & highest acct numbers#
>    9  -------   -   -   -   -   -   -   -   -   -   -   -   -   - -
>           If: cn ne 1
>         Then: cn(5,#,g)=1;la(5,#,g)="";lb(5,#,g)=""
>   10  -------   -   -   -   -   -   -   -   -   -   -   -   -   - -
>           If: la lt 2
>         Then: la=4
>   11  -------   -   -   -   -   -   -   -   -   -   -   -   -   - -
>           If: 2 gt lb
>         Then: lb=4
>   12  -------   -   -   -   -   -   -   -   -   -   -   -   -   - -
> end      If:
>         Then: end
>
> On 7/13/2020 1: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
> >
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://mailman.celestial.com/pipermail/filepro-list/attachments/20200716/6d707644/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/20200716/708f602d/attachment.html>