simple count

Bruce Easton bruce at stn.com
Thu Jun 12 13:10:03 PDT 2008


Bruce Easton wrote Thursday, June 12, 2008 3:57 PM:
[..]
> > 
> > Scott - try this (fPseudo-coded) running *report out of fileA:
> > 
> >   If:  yd eq ""
> > Then:  yd(10,mdyy/,g)=@td-"1095"  'poor man's 3 yrs ago date
> >   If:
> > Then:  lookup fileB  k=(joinkey)  i=[joinindex] -nx
> >   If:  not fileB
> > Then:  end
> >   If:  fileB(incidentdatefld#) le yd and statusfld# eq "10"
> > Then:  tl(6,.0,g)=tl+"1"
> >   If:
> > Then:  end
> > @wgt0  If:  '**or something else if it actually has to print out
> >      Then:  errorbox "My total count is:"<tl
> > 
> > ** like assign a dummy field there and put in grand total 
> > area on a format where the data area is blank (since 
> > you don't want any detail by each record).
> > 
> > Bruce
> > 
> 
> Actually, from what I suggested above, I think you could 
> just put the "tl" dummy in the grand-total area of the report 
> format.   Also note this suggestion is intended to run 
> completely out of output processing (no selection processing).
> 
> Bruce

oh for crying out loud - i guess I have to refine this some more ...

(especially if you're needing this to  be a permanent function for someone)

do this part in sort/sel prc [ -v ](but select instead of counting):

> >   If:  yd eq ""
> > Then:  yd(10,mdyy/,g)=@td-"1095"  'poor man's 3 yrs ago date
> >   If:
> > Then:  lookup fileB  k=(joinkey)  i=[joinindex] -nx
> >   If:  not fileB
> > Then:  end
> >   If:  fileB(incidentdatefld#) le yd and statusfld# eq "10"
> > Then:  select
> >   If:
> > Then:  end

(and of course it could be sped up more if you had an index built 
on that status field using the fabled lookup - technique)

Then in your final output prc, i think you could  
simply have

       Then:      end
@wgt0  If:      errorbox @ts<"Records"; end


Bruce

Bruce Easton
STN, Inc.




More information about the Filepro-list mailing list