Help on Report
scooter6 at gmail.com
scooter6 at gmail.com
Thu Jul 16 12:13:06 PDT 2020
la (lowest) and lb (highest) come out the exact same?
but this puts me on the right track - I 'think' I can work on it from here
- I appreciate you taking time to assist
On Thu, Jul 16, 2020 at 3:04 PM Richard D. Williams <richard at appgrp.net>
wrote:
> 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> 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
>>
>
>
>
> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> Virus-free.
> www.avg.com
> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
> <#m_-327808414198533810_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20200716/32c8f536/attachment.html>
More information about the Filepro-list
mailing list