Hello everybody,
I'm recently tring to run report from withing forms 9i. I have Oracle 9i DS and oracle 9i DB.
What i did so far :-
In forms 9i i made 2 data blocks one is database block showing in content canvas. the other data block contain one button also displayed on content canvas.
under forms there's a Report node from where i made the first report just a simple one to try to run from click on button.
when i clik on + sign selecting report node it gives a dialouge box for creating new report.
i chose the new report placed file name " myrep" and *Base report on block " the first data block which is database block named verify"*
and this open the report application i did all the jobs just simple and run it from report and it was displaying the report.
so far no problem.
then i install a server by *" rwserver -install server=myrepserver"* it installed as windows nt service and up running.
*in forms's report node the new report was named report1* in its property pallet i place the server name as *myrepserver* in the *when-button-pressed* trigger i place the code as follow :-
declare
report_id report_object;
reportserverjob varchar2(100);
begin
report_id:=find_report_object('report1');
reportserverjob:=run_report_object(report_id);
end;
it compiles successfully.
when i run the form it runs ok no problem in all the activity on the data block like query , insert etc.
when i press the button it gives
*frm-41214 unable to run report*
i checked the report server console it was running and it shows ready and job queue as 1. but very quickly goes to 0 .
so any suggestion where i'm doing wrong.
thanks
rahul.
Edited by: Rainbow on Sep 26, 2008 1:08 AM
Edited by: Rainbow on Sep 26, 2008 1:13 AM
Edited by: Rainbow on Oct 11, 2008 11:17 PM