Sunday, March 25, 2012

calling reports from forms

I have been trying to call my report from form through this code but neither it gives me any error nor its showing any report.

declare
report_id Report_Object;
report_job_id VARCHAR2(100);
BEGIN
report_id:= find_report_object('REPORT5');
report_JOB_ID:=run_report_object(report_id);
END;

Comm Mode : async
desctype : screen
Ex mode: runtime
file name : F:\Docs\Forms\vivek.rdf

report5 is the name of report object in the navigator.

What could be the problem??Hi,

Does Your report works fine? Is it fetching the required records ?|||Yep perfectly !

Originally posted by satish_ct
Hi,

Does Your report works fine? Is it fetching the required records ?|||Try using RUN_REPORT(<<filename>>)|||Originally posted by shelva
Try using RUN_REPORT(<<filename>>)

RUN_REPORT runs only from report as SRW.RUN_REPORT and not from form.|||Hey sorry u r right
its ALL_REPORT(<<FIILE NAME>>) from forms

Or in ur method, just give full path of the reports file name|||Originally posted by shelva
Hey sorry u r right
its ALL_REPORT(<<FIILE NAME>>) from forms

Or in ur method, just give full path of the reports file name

Never heard of it and neither it works.|||Oye again typing mistake

its CALL_REPORT.. sorry again

No comments:

Post a Comment