summary sheets from temp file

Mon Jul 14 14:15:49 PDT 2014

I'm just selecting all records -- there are no blank records in this file

Just to clarify Ken/Bruce/Chris......in the Define Ouput, should all my
lines of data be in the Subtotal section?
If I put 'aa' in the data lines section, the actual correct value shows up
there, just not if I have the output in the subtotal section?
Consequently, if I put ab in the 'data lines' section, it is blank as you
would expect......but ab is correct if it's in the subtotal section of the
output.....

On Mon, Jul 14, 2014 at 5:08 PM, Chris Rendall <crendall at teamind.com> wrote:

> What does you selection processing look like?  It sounds like you are
> selecting records where field 3 is blank so aa is getting set to blank.
>
> --- Chris
>
>
>
>
>
> From: scooter6 at gmail.com [mailto:scooter6 at gmail.com]
> Sent: Monday, July 14, 2014 4:00 PM
> To: Chris Rendall
> Cc: filepro-list at lists.celestial.com
> Subject: Re: summary sheets from temp file
>
> Yes that's what it said - so I did as you said and yes, in fact the beep
> msgbox only is encountered once - thanks  now line 1 is blank in the If:
> and Then: end
> Now if I can just figure out why aa is always blank then I'll be
> set.....thanks for that tip....
> Scott
>
> On Mon, Jul 14, 2014 at 4:54 PM, Chris Rendall <crendall at teamind.com>
> wrote:
> Does the first "If" line in your code have the "If 1="" then end"?  If so,
> take out the 1="" from the "If" line and just leave the "end" on the then
> line.
>
> If field 1 is not equal to blank then the code will continue into the
> @sbrk1 code, and then the code in @sbrk1 runs again when the break value
> changes causing it to run twice like you are seeing.
>
> --- Chris
>
> -----Original Message-----
> From: scooter6 at gmail.com [mailto:scooter6 at gmail.com]
> Sent: Monday, July 14, 2014 3:46 PM
> To: Kenneth Brody
> Cc: filepro-list at lists.celestial.com
> Subject: Re: summary sheets from temp file
> One more thing to note, on the actual print outs with this processing, the
> last page it prints (for client 5499, which is in fact the highest client
> number) does show aa as 0091 and ab as 0091 (which 0091 is the highest
> acct number for 5499) ?
> The first 3 pages (for clients 2435, 3194 and 3981) show aa is blank but
> ab is correct --
>
>
> On Mon, Jul 14, 2014 at 4:42 PM, scooter6 at gmail.com <scooter6 at gmail.com>
> wrote:
>
> > Field 1 is client number  (i.e. 2435, 3194, 3981, 5499) Field 2 is
> > acct number Field 3 is those 2 fields combined  with a "-" in middle
> > (i.e. 2435-0126,
> > 3194-0143)
> >
> > If I change message box to show all 3, it says "Value of field 1 is
> > 2435 field 2 is 0126 field 3 is 2435-0126"  When it encounters the
> > very first record of each unique client number, I have to hit enter
> > twice - and these values do not change after hitting enter first
> > time....only after hitting enter for 2nd time does it go to the next
> > account - but it's only the first acct it finds under each client? Why
> would that be?
> > For instance, when I get to client 5499, the message box shows "Value
> > of field 1 is 5499 field 2 is 0086 field 3 is 5499-0086"  After I hit
> > enter first time, the values stay the same....BUT, after I hit enter
> > for the 2nd time, and every consecutive time, it increments the values
> > properly....so after I hit enter for 2nd time, it shows 5499-0087,
> > then after 3rd time, it shows 5499-0088 and so on, but on the first
> > record it finds for each unique client number, I have to hit enter
> twice....?
> >
> >
> >
> >
> > On Mon, Jul 14, 2014 at 4:29 PM, Kenneth Brody <kenbrody at spamcop.net>
> > wrote:
> >
> >> On 7/14/2014 4:21 PM, scooter6 at gmail.com wrote:
> >>
> >>> 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
> >>>
> >> [...]
> >>
> >>  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:
> >>>
> >> [...]
> >>
> >>  My sort information is:
> >>>
> >>>    Sort field     :   1    |  2
> >>>    Length        :   4    |  4
> >>>    Descending:         |
> >>> Subtotal field:    x   |
> >>>
> >> [...]
> >>
> >> Since you're sorting on field 1, perhaps you should show us the value
> >> of that field?  Maybe the message box should show the values of
> >> fields 1, 2, and 3?
> >>
> >> --
> >> Kenneth Brody
> >>
> >
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/e5112040/attachment.html
> _______________________________________________
> Filepro-list mailing list
> 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
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
> _______________________________________________
> 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/085e4f89/attachment.html 