selection for report without selection table
Fairlight
fairlite at fairlite.com
Thu Jul 24 09:44:16 PDT 2008
You'll never BELIEVE what Bruce Easton said here...:
> 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?
Based on what I've seen, a selection processing table is in place that asks
for data for range limiting on dates, etc.
You know my personal model of doing web-based work from a central control
file, as I've shown you how I do it. I need to marry that to conventional
printing without altering the command line or invoking another concurrent
licensed process (5,0.14--any system call to another eats a license
seat, and no we can't upgrade).
So how would you do it in OG from a control file? :) I've done something
with FORM once or twice, but the original code wasn't mine. Would that
work, if I switch to dclerk as I did for those instances? I could write a
file with the limiting info I need, then exit and have the next command do
the clerk/FORM. Or another dreport with this non-interactive selection
processing, Then subsequent commands to do the PDF generation, etc. Am I
on the right track if I write my limiting data to a file, then run dreport
on the -v table, but take out the interactive questions and replace it with
file I/O that gets my data from the first dreport? I have a command chain
like that with cleanup that I've used before. My question I guess is the
selectiop processing issue.
Thanks!
mark->
More information about the Filepro-list
mailing list