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