Home » Developer & Programmer » Forms » Re: calling a report from forms
Re: calling a report from forms [message #79935] Fri, 26 July 2002 09:12 Go to next message
Tyler
Messages: 123
Registered: January 2002
Senior Member
Thank you so much for your reply, but now I'm getting that the report can not be found...
Here is my code...

declare
splr_list paramlist;
report_handle varchar2(100);
report_id report_object;
begin

splr_list := CREATE_PARAMETER_LIST('splr_list');

IF NOT ID_NULL(splr_list) THEN
ADD_PARAMETER(splr_list,'P_SPLR_CODE',TEXT_PARAMETER,:SPLR_NAME);
-- RUN_PRODUCT(REPORTS,'EVENTS_REP',SYNCHRONOUS,RUNTIME,FILESYSTEM,splr_list,NULL);
report_id := FIND_REPORT_OBJECT('EVENTS_REP');
SET_REPORT_OBJECT_PROPERTY(report_id, REPORT_OTHER,P_SPLR_CODE);
report_handle:= RUN_REPORT_OBJECT(report_id);
DESTROY_PARAMETER_LIST(splr_list);
END IF;
end;

You can see that I've commented out the run product line, and that line works when not commented, so the report name is right... thus why can't it find it with this new code?

Thank you for your time,

~ T ~
Re: calling a report from forms [message #79966 is a reply to message #79935] Tue, 30 July 2002 02:43 Go to previous message
Dadoke
Messages: 1
Registered: July 2002
Junior Member
did you 'attach' the report to the form
it's a new node almost at the bottom where you must create an item in order to use it as an object

i had the same problem because 'oracle' forgot that in the help files ... :)
Previous Topic: freezing buttons in forms
Next Topic: text item validation
Goto Forum:
  


Current Time: Tue Nov 30 12:24:27 CST 2021