summary sheets from temp file

scooter6 at gmail.com scooter6 at gmail.com
Mon Jul 14 13:21:51 PDT 2014


Seems to me it's going thru @sbrk1 after each record.....I put a
'beep;msgbox...' statement in @sbrk as shown and it increases each time I
hit enter
Here are the records I have in the file:

2435-0126
3194-0143
3194-0144
3194-0145
3981-0059
5499-0086
5499-0087
5499-0088
5499-0090
5499-0091

So my processing now looks like this:

:1="":end::
@sbrk1::aa(4,#,g)=mid(3,"6","4");beep;msgbox "Value of aa is"<aa    'this
is the lowest acct number:
::end:
@wbrk1::ab(4,#,g)=mid(3,"6","4")  'this is the highest acct number:
::lookup cli = client  k=1   i=A  -nx:
::ac(30,uplow)=cli(2) :
::end:

I have tried this with both ",g" and without ",g"
If I use ",g" then aa and ab are always the same (the highest number, ab)
If I don't use ",g" then aa is always black, but ab is correct

My sort information is:

  Sort field     :   1    |  2
  Length        :   4    |  4
  Descending:         |
Subtotal field:    x   |

When I run this on all records, the msgbox I get happens in this order
(after each record, it's giving me the value of the acct number)

Value of aa is 0126   I hit enter, still shows
Value of aa is 0126   then it prints the page

Value of aa is 0143   I hit enter
Value of aa is 0144   I hit enter
Value of aa is 0145   I hit enter and it prints the page

Value of aa is 0059   I hit enter, still shows
Value of aa is 0059   I hit enter and it prints the page

Value of aa is 0086   I hit enter, still shows
Value of aa is 0086   I hit enter, shows
Value of aa is 0087   I hit enter, shows
Value of aa is 0088   I hit enter, shows
Value of aa is 0090   I hit enter, shows
Value of aa is 0091   I hit enter and it prints the page

Processing ends......

Not sure why aa would return different values each time I hit enter, if in
fact the subtotal is on client number....should only hit @sbrk1 when it
reaches a different client number, right??






On Mon, Jul 14, 2014 at 3:47 PM, Bruce Easton <bruce at stn.com> wrote:

> Scott, for the report to do what you need it to do, I would think you
> want it in client, then account order (so that it hits the lowest acct#
> first and the highest last within a client).  If you look back at Ken's
> initial reply on this, his first paragraph gives the answer, but, based
> on what we knew at that time, we only knew about the one combined field
> (which seems to be field #3).  So with those dummy fields global and
> "end"ing the @sbrk1 section, it should work the way he described if you
> sort on your field 3, but overriding the length of the sort to be 4.
> (Also, since we now know you have the other parts of the key stored
> separately, you could alternatively make the sort composite and sort on
> all of field 1 and then at the next level on all of field 2 and only
> specify to sub-total break (with the "x") on the level that's on field 1.)
>
> Bruce
>
>
> On 7/14/14 3:12 PM, scooter6 at gmail.com wrote:
> > Here is the 'structure' part of the file that's pertinent
> > Field 1 = 4,#  is the client number   ' in the examples here, that is
> > 2435, 3194 & 5498  - this is what it should sort on - a new page for
> > each unique client number
> > Field 2 = 4,allup  is the account number  'in the examples here, that
> > is what comes after the "-" 0001, 0002 for client 2435, 0143, 0144,
> > 0145 for client 3194
> > Field 3 = 9,allup  is the two fields combined  with a "-" in middle
> > 'i.e. 2435-0001, 2435-0002, 3194-0143, etc
> > So since the file has the client number in a field already, I have it
> > sorting on field 1 with a length of 4 - which appears to be okay,
> > since it's doing what I want it to do, except it's not finding the
> > 'lowest' account number...otherwise, everything works fine haha
> >
> >
> > On Mon, Jul 14, 2014 at 3:04 PM, Bruce Easton <bruce at stn.com
> > <mailto:bruce at stn.com>> wrote:
> >
> >     Scott - check the sort screen for this - did you sort on Account
> >     Number,
> >     but only for a length of four?
> >
> >     Bruce
> >
> >     On 7/14/14 2:55 PM, scooter6 at gmail.com <mailto:scooter6 at gmail.com>
> >     wrote:
> >     > adding 'end' in @sbrk1 had no effect - aa is still equal to ab
> >     on all
> >     > pages
> >     >
> >     >
> >     > On Mon, Jul 14, 2014 at 2:47 PM, Bruce Easton <bruce at stn.com
> >     <mailto:bruce at stn.com>
> >     > <mailto:bruce at stn.com <mailto:bruce at stn.com>>> wrote:
> >     >
> >     >     Ah yes, the lack of "end" for @sbrk1 is probably why your aa
> >     is being
> >     >     set to your ab.
> >     >
> >     >     Bruce
> >     >
> >     >     On 7/14/14 2:33 PM, Kenneth Brody wrote:
> >     >     > On 7/14/2014 1:57 PM, scooter6 at gmail.com
> >     <mailto:scooter6 at gmail.com>
> >     >     <mailto:scooter6 at gmail.com <mailto:scooter6 at gmail.com>> wrote:
> >     >     >> Ken,
> >     >     >>
> >     >     >> Here is what my output processing looks, with sort on client
> >     >     number (4
> >     >     >> characters and subtotal) and then full account number
> >     >     >> Everything works great except the 'starting (lowest)'
> >     number -
> >     >     that is
> >     >     >> coming out blank
> >     >     >>
> >     >     >> :1="":end::gP*P|VW_L&4foSDs:
> >     >     >> @sbrk1::aa(4,#)=mid(3,"6","4")  'this is the lowest number:
> >     >     > aa(4,#,g)=mid(3,"6","4") ; end
> >     >     >
> >     >     >> @wbrk1::ab(4,#)=mid(3,"6","4") 'this is the highest number:
> >     >     >> ::lookup cli=client  k=1   i=A -nx:
> >     >     >> ::ac(30,uplow)=cli(2) ' this grabs the name of the client:
> >     >     >> ::end:
> >     >     > [...]
> >     >     >> Any idea why 'aa' starting number is coming back blank?
> >     >     > [...]
> >     >     >
> >     >     > No ",g" flag.
> >     >     >
> >     >
> >     >
> >     >     _______________________________________________
> >     >     Filepro-list mailing list
> >     > Filepro-list at lists.celestial.com
> >     <mailto:Filepro-list at lists.celestial.com>
> >     >     <mailto: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/20140714/c48dae8d/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/20140714/836a6b5a/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/20140714/b9c1923e/attachment.html 


More information about the Filepro-list mailing list