Re: calling reports from forms

From: Joost Bataille <j.r.l.m.batailleREMOVETHIS_at_uva.nl>
Date: Tue, 9 Oct 2001 11:33:45 +0200
Message-ID: <9pug9p$p0s$1_at_mail.ic.uva.nl>

Hello Eugene, you wrote
> How to suppress reports parameter form when calling reports from forms
using
> RUN_PRODUCT? Manuals are not clear about that feature.
By accident I replyed twice and that was from home where I couldn't access my work stuff.
I'd like to add an example of this 'add_parameter' code, I use it at work and it works.
Please note the name of the 'parameter form' parameter, it's not 'PARAM_FORM' but 'PARAMFORM' without the underscore.

This procedure is very similar to the example in the manual. I tend to see this as composing a string to put on the commandline.

PROCEDURE run_report_bsp ( p_proces_code in his_boodschappen.proces_code%type

                         , p_datum        in his_boodschappen.datum%type
                         , p_aantal_dagen in number
                         , p_bsp_type     in his_boodschappen.bsp_type%type
                         )

IS

pl_id paramlist;

BEGIN pl_id := get_parameter_list('bsp_params');

if not id_null(pl_id) then
  destroy_parameter_list(pl_id);
end if;

pl_id := create_parameter_list('bsp_params');

• suppress the parameter form add_parameter( pl_id, 'PARAMFORM' , text_parameter, 'NO');
• run the Reports window maximized add_parameter( pl_id, 'MAXIMIZE' , text_parameter, 'YES'); add_parameter( pl_id, 'P_PROCES_CODE', text_parameter, p_proces_code); add_parameter( pl_id, 'P_DATUM' , text_parameter, to_char(p_datum, 'DD-MM-YYYY')); add_parameter( pl_id, 'P_DAGEN_TERUG', text_parameter, to_char(p_aantal_dagen)); add_parameter( pl_id, 'P_BSP_TYPE' , text_parameter, p_bsp_type );

run_product ( reports, 'boodschap', synchronous, runtime, filesystem, pl_id, null );

END; Received on Tue Oct 09 2001 - 11:33:45 CEST