selection for report without selection table

Barry Wiseman bwiseman at optonline.net
Thu Jul 24 13:30:40 PDT 2008


Fairlight wrote:
> 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->

Mark, you're on the right track with your "separate process" thought: 
save the selection parameters in a file, run the report as a subsequent 
dreport job, modify the selection processing to grab args from the file 
instead of being interactive, and Bob's your uncle. By rewriting the 
report app to use FORMM in a loop as suggested later in this thread, 
you're entering a world of pain where you have to maintain your own page 
numbers, totals, etc.


More information about the Filepro-list mailing list