Home » Developer & Programmer » Reports & Discoverer » passing parameter list to report 9i
passing parameter list to report 9i [message #186446] Tue, 08 August 2006 00:31 Go to next message
engr_anzar
Messages: 2
Registered: August 2006
Location: KARACHI
Junior Member
hi 2 all
i m new new user
i wanna create parameter list on form and passing this parameter to 9i report ,if i m using this query ...
PROCEDURE run_report(where_clause VARCHAR2(50), person_id NUMBER) is

v_pl_id PARAMETERLIST;
v_pl_name VARCHAR2(10) := 'my_list';
v_rep_id REPORT_OBJECT;
v_rep_tx VARCHAR2(100);


BEGIN
-- delete paramter list if it currently exists
v_pl_id := get_parameter_list(v_pl_name);

IF NOT id_null(v_pl_id) THEN
v_pl_id :- destroy_parameter_list(v_pl_id);
END IF;


-- create parameter list
v_pl_id := create_parameter_list(v_pl_name);

-- add parameters
add_parameter(v_pl_id, 'where_clause', TEXT_PARAMETER, 'where person_id=' person_id);

-- run report
v_rep_id := find_report_object('my_report');
v_rep_tx := run_report_object(v_rep_id, v_pl_id);


END; /* End of Procedure */
END; /* End of package body */
/

-------
so this query shows error and how can i display rep on web (pdf format) for this now i user this query.


WEB.SHOW_DOCUMENT('http://132.147.100.100:8888/reports/rwservlet?
destype=cache&desformat=HTML&report=call_me2.rdf&userid
=scott/tiger@orav817&dno='||:text_no);

so plz solve my problems ( how can i add parameter list )

thanks in advance
regards,
Anzar Baig


Re: passing parameter list to report 9i [message #187122 is a reply to message #186446] Fri, 11 August 2006 00:12 Go to previous message
engr_anzar
Messages: 2
Registered: August 2006
Location: KARACHI
Junior Member
plzzz plzzzzz solve my problems
regards
AAb
Previous Topic: problem with report
Next Topic: After Printing ?
Goto Forum:
  


Current Time: Sun Dec 04 23:07:53 CST 2016

Total time taken to generate the page: 0.07430 seconds