selection for report without selection table

Bruce Easton bruce at stn.com
Thu Jul 24 10:47:35 PDT 2008


Bruce wrote Thursday, July 24, 2008 12:14 PM:
> 
> Mark wrote Thursday, July 24, 2008 11:53 AM:
> > 
> > Hi All,
> > 
> > I need a pointer.  There's a report someone did that relies on a 
> > processing
> > table that uses SELECT.
> > 
> > I need to issue this report, complete with the grand total 
> section, etc.,
> > but from inside a dreport session that's running on another table 
> > entirely.
> > I need to basically do it all via lookups or whatnot.
> > 
> > I -could- do it via a separate process, but -not- as a system 
> call, and I
> > need to get the selection data to any process without using selection
> > tables to issue the selections, since it can't be run interactively.
> > 
> > If I have a weak spot in fP, it's printing, mostly because I've rarely
> > needed it.  Hence...Help???  :)
> > 
> > TIA,
> > 
> > mark->
> > -- 
> > Fairlight->   
> > Consulting
> 
> Mark - above where you say 'selection tables' (3rd paragraph) - 
> are you thinking selection sets or selection processing?  
> Either way, both can be used non-interactively.  Also, I'm 
> curious - why does it have to run from another table?
> 
> Bruce
> 

Mark - I should have provided an example of what I said above 
about selection sets and processing not needing to be interactive.
I was just tweaking an old program yesterday that creates PDFs 
and the first phase of the program is an output request that 
uses both a selection set and selection processing - no user 
interaction at all:

~report -f [formatname] -s [sel_set_name] -v [sel_prc_name]

If this output request itself is issues from a system 
command, then I often will also use the -r/-rw ... flag(s) 
to send the data arguments (that might vary in value in the 
parent process) that, in an interactive session, would 
be in the form of runtime input commands.

But I see from your more recent post that you are trying to 
stay away from the system command, so I will reply to that 
one separately.

Bruce


Bruce Easton
STN, Inc. - authors of the filePro Developer's Reference
            the 38th filePro School from STN:  Advanced 
            Class - Tulsa, OK, Sept. 15-18, 2008





More information about the Filepro-list mailing list