Help on Report
scooter6 at gmail.com
scooter6 at gmail.com
Wed Jul 15 07:53:23 PDT 2020
Bruce,
Yes I got that and did reply - that helped a lot
Just figuring out how to sort these where they sub-total on date received
i.e.
Clt Name Starting Ending
01234 Clt Name 00010 00011
01235 Clt Name 00250 00250
Total Rec'd 06/01/20 3
01234 Clt Name 00012 00012
01235 Clt Name 00251 00251
Total Rec'd 06/05/20 2
I got the starting and ending number working thanks to you example
On Wed, Jul 15, 2020 at 10:38 AM Bruce Easton <bruce at stnincmd.com> wrote:
> 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>
> <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>
> <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>
> <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>
> <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/6f8891dd/attachment.html>
More information about the Filepro-list
mailing list