Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    121

    Question Unanswered: Supressing Oracle Report's Default Parameter From

    Hello,
    I created an Oracle form that passes parameters to an Oracle report. The problem, is that after entering the parameters values on the form, the reports default parameter form displays when I press the button on the form to generate the report . Below is a sample of the WHEN-BUTTON-PRESSED trigger for the button on the Oracle Form...

    DECLARE

    param_periph paramlist;

    BEGIN
    param_periph := CREATE_PARAMETER_LIST('tmp_data');
    add_parameter(param_periph, 'p_chart', TEXT_PARAMETER, :TXT_CHART);
    add_parameter(param_periph, 'PARAMFORM', TEXT_PARAMETER, 'NO');
    add_parameter(param_periph, 'p_physician', TEXT_PARAMETER, :TXT_PHYS);
    add_parameter(param_periph, 'p_location', TEXT_PARAMETER, :LST_LOCATION);
    add_parameter(param_periph, 'p_start', TEXT_PARAMETER, :TXT_APPT_DATE);
    add_parameter(param_periph, 'PARAMFORM', TEXT_PARAMETER, 'NO'); --supress default parameter form.

    run_product(reports, 'U:\opis_reports\peripheral_rev.rdf', synchronous, runtime, filesystem,'param_periph', NULL);

    DESTROY_PARAMETER_LIST(param_periph);

    End;


  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    You have it almost right, take out the quotes around param_periph. You are passing a link to the collection, not a literal string.

    run_product(reports, 'U:\opis_reports\peripheral_rev.rdf', synchronous, runtime, filesystem,param_periph, NULL);
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Aug 2002
    Posts
    121

    Talking Supressing Oracle Report's Default Parameter From

    Beilstwh,
    Thank-you, thank-you, thank-you!


    That's great! It works beautifully now. Damn syntax



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •