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