Home » Developer & Programmer » Forms » Problem in running report from forms 6i.......Please help...!
Problem in running report from forms 6i.......Please help...! [message #265779] Fri, 07 September 2007 06:38 Go to next message
james_aron
Messages: 32
Registered: July 2007
Location: chennai
Member
hi all,
I am working in oracle forms 6i and i am trying to run report from form while press one of the push-button. works fine upto 2nd line from the begin key-word.After that its showing error like " FRM-40738:Argument 1 to builtin REPORT_OBJECT_STATUS cannot be null.". Can any-one help me of how to solve this and
wat would be the problem.........?

declare
run_rep varchar2(200);
rep_obj report_object;
rep_stat varchar2(20);
begin
rep_obj := find_report_object('report46');
run_rep := run_report_object(rep_obj);
rep_stat := report_object_status(run_rep);
if rep_stat = 'FINISHED' then
copy_report_object_output(run_rep, 'C:\Documents and Settings\trainee\Desktop\Icons\test.pdf');
else
message('error when running report');
end if;
end;

Please help asup!

regards,
jame

[Updated on: Fri, 07 September 2007 07:12]

Report message to a moderator

Re: Problem in running report from forms 6i.......Please help...! [message #265787 is a reply to message #265779] Fri, 07 September 2007 07:04 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Please, read OraFAQ Forum Guide to learn how to properly format your message.

Quote:
rep_stat := report_object_status(v_rep);

Where did 'v_rep' get its value? It seems that its current value is NULL.

Re: Problem in running report from forms 6i.......Please help...! [message #265789 is a reply to message #265787] Fri, 07 September 2007 07:11 Go to previous messageGo to next message
james_aron
Messages: 32
Registered: July 2007
Location: chennai
Member
Sorry small mistake, forget to change the name v_rep to run_rep...

declare
run_rep varchar2(200);
rep_obj report_object;
rep_stat varchar2(20);
begin
rep_obj := find_report_object('report46');
run_rep := run_report_object(rep_obj);
rep_stat := report_object_status(run_rep);
if rep_stat = 'FINISHED' then
copy_report_object_output(run_rep, 'C:\Documents and Settings\trainee\Desktop\Icons\test.pdf');
else
message('error when running report');
end if;
end;

Please help asup!

[Updated on: Fri, 07 September 2007 07:13]

Report message to a moderator

Re: Problem in running report from forms 6i.......Please help...! [message #266507 is a reply to message #265789] Tue, 11 September 2007 01:22 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
If you searched this forum for 'report_object_status' you would have found http://www.orafaq.com/forum/m/258026/67467/?srch=report_object_status#msg_258026 among many others. Add some parameters and see how you get on.

David
Re: Problem in running report from forms 6i.......Please help...! [message #266645 is a reply to message #266507] Tue, 11 September 2007 05:17 Go to previous messageGo to next message
james_aron
Messages: 32
Registered: July 2007
Location: chennai
Member
hi david,
Below is my code, everything is fine except report_object_status.......


declare
run_rep varchar2(2000);
rep_obj report_object;
rep_stat varchar2(20);
begin
rep_obj := find_report_object('REPORT48');
set_report_object_property(rep_obj,REPORT_DESTYPE,FILE);
set_report_object_property
rep_obj,REPORT_DESNAME,'c:\Testing.pdf');
set_report_object_property(rep_obj,REPORT_DESFORMAT,'PDF');

run_rep := run_report_object(rep_obj);
rep_stat := report_object_status(run_rep);

/*if rep_stat = 'FINISHED' then
message('report completed');
copy_report_object_output(run_rep, 'C:\Documents and
Settings\trainee\Desktop\Icons\test.pdf');
else
message('error when running report');
end if;
*/
end;

Could u tell me y it is storing null value in rep_stat. Programe error or system error..?
Re: Problem in running report from forms 6i.......Please help...! [message #266950 is a reply to message #266645] Wed, 12 September 2007 01:38 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you ever been able to get a report to run on your PC? Is the report server running? Have a look in the 'reports' forum.

David
Re: Problem in running report from forms 6i.......Please help...! [message #416143 is a reply to message #265779] Thu, 30 July 2009 16:38 Go to previous message
christianmlong
Messages: 3
Registered: July 2009
Junior Member
From the Forms 6i documentation for the RUN_REPORT_OBJECT built-in
Quote:

If you invoke Run_Report_Object with a blank Report Server property, the return value will be NULL. In that case, you cannot then use the built-ins Report_Object_Status and Copy_Report_Object_Output, because they require an actual ID value.

Previous Topic: report_object_status [ERROR]
Next Topic: report status using report_object_status in form builder
Goto Forum:
  


Current Time: Wed Dec 07 22:43:57 CST 2016

Total time taken to generate the page: 0.12111 seconds