counting real records

[Walter D Vaughan Jr]

Yeah, you are on the right track.

Sort1 would replace the default top level sort on your report. So, it's
something you might want to make sure you understand from a high level.

It's not overly intuitive to program if you have not been exposed to it
before, but I bet 95% of my reports used them.

HOWEVER I started at the -v table process before I moved on to actually
deciding what to do in @wbrk1 and what the top level sort on the report
output looked like.

 

I thought Nancy Palmquist had something on vss3.com, but maybe someone else
can send you a link to a tutorial on how to use sort/selection tables in
filePro.

 

From: scooter6 at gmail.com [mailto:scooter6 at gmail.com] 
Sent: Monday, August 12, 2013 12:00 PM
To: Walter D Vaughan Jr
Subject: Re: counting real records

 

Can you expand on that a bit?

So this should be used if my command is        /u/appl/fp/rreport customer
-f Placesum -u -a -v <sort processing that you indicated>    ?

i.e.  I make a -v table called   sortit     and use the sort1 command in
there?

 

On Mon, Aug 12, 2013 at 11:50 AM, Walter D Vaughan Jr
<wvaughan at steelerubber.com> wrote:

> -----Original Message-----
> From: filepro-list-bounces+wvaughan=steelerubber.com at lists.celestial.com
> [mailto:filepro-list-
> bounces+wvaughan=steelerubber.com at lists.celestial.com] On Behalf Of
> scooter6 at gmail.com
> Sent: Monday, August 12, 2013 11:22 AM
> To: filepro-list at lists.celestial.com
> Subject: counting real records
>
> Should seem simple but let me explain...

[Walter D Vaughan Jr]
<snip>
Why are you not using a sort/selection table?
http://www.fptech.com/Products/Docs/fpmanhtm/how_do_i/advanced_concepts/sort
_select_processing.htm
http://www.fptech.com/Products/Docs/fpmanhtm/references/commands/sort.htm

sort1=cn&"-"&rn


_______________________________________________
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/20130812/8a30d349/attachment.html