Re: Reports 3.0 question

[Quoted] It still doesn't work. My query is now:

        select * from my_table where table_fk is not null &p_where

Could it be the way I'm calling the report that's wrong ? I'm using this code

declare
 ...
begin
  v_list_id := create_parameter_list('dummy');   buffer := ' and (post_nr=2100)';

  add_parameter(v_list_id,'P_WHERE',text_parameter,buffer);
  add_parameter(v_list_id,'READONLY',text_parameter,'YES');
  add_parameter(v_list_id,'PARAMFORM',text_parameter,'NO');
  add_parameter(v_list_id,'ORIENTATION',text_parameter,'LANDSCAPE');

run_product(REPORTS,'TEST_REP',SYNCHRONOUS,RUNTIME,FILESYSTEM,v_list_id,NULL); end;

• Ole Bredesen-Vestby