selection for report without selection table

Bruce Easton bruce at stn.com
Thu Jul 24 14:23:35 PDT 2008


Barry Wiseman wrote Thursday, July 24, 2008 4:31 PM:
> 
> 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.

I agree - having done some char-based reports like that before, 
that's probably why I haven't try to do any web-based like that - 
it IS a pain trying to follow the code keeping track of all those little 
forms  - they start growing in your filelist like tribbles.

Also, regarding the print command, I stated: 
'Yes the print command.  but hopefully you're not also trying 
to control sorting based on user input.'   But I think that lack 
of being able to control sorting at runtime would only apply to 
when you are trying to control selection with the print command 
during the output processing phase.   With the technique of 
storing and retrieving selection parameters, where 
a -v table is used, then you can, of course override 
the sort specification easily also using stored parameters.

Bruce

Bruce Easton
STN, Inc.



More information about the Filepro-list mailing list