Re: Forms & reportwriter...more help requested.

Rocqueforte OLeary (roleary_at_st.nepean.uws.edu.au) wrote:
> Using the guide on page 6-2 of "Building reports with reportwriter" ,
> I have to "Insert parameter values into a temporary table and select
> from this table in my report" because I have a large number of
> parameter values and these values can vary. Okay, since I'm in a
> multi-user environment, I'll have create a uniquely named table at run
> time and drop it when finished with it.Okay, use date and time. Here I
> discover you can't create tables in forms...a host call to sql*plus
> will be necessary.

[ Incredulous mode on ] Burgle? [ Incredulous mode off] Have one table, call it eg REPORT_PARAMETERS which exists all the time. Give it columns REPORT_RUN_ID, PARAMETER_NAME, PARAMETER_VALUE. Then for each report, a select can pick up all the appropriate values: SELECT PARAMETER_NAME, PARAMETER_VALUE FROM REPORT_PARAMETERS WHERE REPORT_RUN_ID=:this_report;

or to get a value from the table you're reporting on: SELECT whatever
FROM report_table, REPORT_PARAMETERS

WHERE report_table.column like '%'||REPORT_PARAMETERS.PARAMETER_VALUE||'%'
  AND REPORT_PARAMETERS.PARAMETER_NAME='This column'
  AND REPORT_RUN_ID=:this_report;

As long as ALL the parameters exist (may be null, but must exist...)

YMMV

--
  _________________________   _________________________________________
 /  Tommy Wareing          \ /  And I dream of movies                  \
|  p0070621_at_brookes.ac.uk   X   They won't make about me when I'm dead  |
 \  0865-483389            / \      - Jon Bon Jovi, Keep the Faith     /
  ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~