Help on Report
Richard D. Williams
richard at appgrp.net
Thu Jul 16 12:04:33 PDT 2020
Sorry again, I meant field 2.
Yes you are right.
Richard
On 7/16/2020 1:46 PM, scooter6 at gmail.com wrote:
> 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
> <mailto: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
> <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/20200716/6d707644/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
>
--
This email has been checked for viruses by AVG.
https://www.avg.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20200716/c5bab8cb/attachment.html>
More information about the Filepro-list
mailing list