mdorion@cmtl01.UUCP (Mario Dorion) (12/01/88)
For a few weeks I have been using Oracle's SQL*Forms and SQL*Report. My only
grief with SQL*Report is that it's user interface facilities are very
restricted. The ASK and TELL commands aren't quite enough to build input screens
or whatever user interface I'd like to build.
My question is: is there a way to have these two programs work harmoniously
together? Is there a way for example to have a form acting as a 'pre-report
screen' and that would gather information that would then be passed to
SQL*Report as variables?
Since these two software are part of the same package I'd really tend to
expect them to be able to work together. Am I missing something?
--
Mario Dorion | E-mail: mdorion@X02.UUCP
XIOS Systems | ...uunet!attcan!cmtl01!X02!mdorion
Montreal, Canada |
1 (514) 744-3410 | No thanks, no penguin, I already got one!blinder@oracle.uucp (Ben Linder) (12/02/88)
Well, linking forms and RPT is not too complicated. My favorite approach is to link the two using a parameter table in the database. Have a table which contains a column for each parameter the report requires, then use a form to load the data into the table. Once the RPT is called, it can SELECT from the table, execute the report, and DELETE the row from the table. Keep in mind SQL*REPORT can execute any valid SQL DML statement. This can be the basis for a rather elegant system which can manage batch reports, etc. Glad to help Ben Linder ---------------------------------------------------------------------- Ben Linder Oracle Corporation Advanced Services
hans@imshp1.im.se (Hans R|cklinger) (12/05/88)
One way of doing this is to have a special table that contains the
selected values for the report. In other worlds you design a special
screen for ordering the report. This screen also update a report queue.
A special process reads the report queue and starts the report with
the que number as input redirection. In the report there is a an
execute statement that reads the ordering table (one for each report)
Regards Hans R|cklinger/Patrik Fransson
--
Hans Rocklinger | hans@im.se
Industrimatematik System AB |
V Hamngatan 8 |
S-411 17 GOTHENBURG, SWEDEN