Posted by 'Dave Schmoldt' on August 06, 2001 at 13:35:48 EST:
In Reply to: Report parameters posted by 'Robin' on August 06, 2001 at 10:51:08 EST:
I'm not sure about that, but it would be possible to code the report using a single view name, and then re-create the view before running the report, using whatever table you want to access as part of the view definition.
use dynamic SQL to replace the view:
create or replace view VW_DIRECTORY as
select name, address, city, state, zip
from table_i_want_to_use_this_time;
Then run the report that uses VW_DIRECTORY.
: I have set up a report to receive where parameters f
rom a form. Does anyone know if its possible to also tell the report which view to draw its information from? Such as:
: select name, address, city, state, zip
: from &directory_view
: &whereparam1
: &whereparam2
: &orderbyparam
: tia, robin