Home » Developer & Programmer » Reports & Discoverer » urgent run report with in report
urgent run report with in report [message #225500] Tue, 20 March 2007 02:30 Go to next message
sunil.madnani
Messages: 36
Registered: March 2007
Location: BHILAI
Member
hello friends
i m new to oracle froms and reports
how can i create a report which calls another report taking
contents of first report as parameters
regards
sunil
Re: urgent run report with in report [message #225664 is a reply to message #225500] Tue, 20 March 2007 15:20 Go to previous messageGo to next message
msaleem
Messages: 37
Registered: November 2006
Location: Pakistan
Member

Dear Sunil

you did not mentioned the version of report. If you are doing it in 10g Then use format trigger with any text to write trigger for calling another report using srw.hyperlink command

Thanks
Saleem
Re: urgent run report with in report [message #225963 is a reply to message #225664] Thu, 22 March 2007 02:05 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
@ sunil , saleem is right you must mention the version u r using, you have to create a push button to do that and write coding of calling another report.
Ashu
Re: urgent run report with in report [message #225986 is a reply to message #225664] Thu, 22 March 2007 03:25 Go to previous messageGo to next message
sunil.madnani
Messages: 36
Registered: March 2007
Location: BHILAI
Member
hello and thanks for ur response
i m using developer 6i, report 6i
can u plz send me some example with coding
it would be so nice of u
regards sunil
Re: urgent run report with in report [message #226011 is a reply to message #225986] Thu, 22 March 2007 05:00 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
@sunil right now i do not have but you can take the help from reports HELP or when you open Forms you take from Help.

Full code is written just change some parameters. In help write 'Calling reports' and attach the code with when button pressed trigger.

AT
Re: urgent run report with in report [message #226026 is a reply to message #225500] Thu, 22 March 2007 06:08 Go to previous messageGo to next message
msaleem
Messages: 37
Registered: November 2006
Location: Pakistan
Member

Dear Sunil,

Sorry for delay, I was busy and was not on net for some days.

Now you have to create a button in appropriate frame in your report and write down the following code. I used some values to pass as parameter in calling report. I think it will help you.

---- Code start here
procedure OpenButtonAction is
mdate varchar2(8);
tdate varchar2(8);
pathr varchar2(100);
cname varchar2(1000);
begin
mdate := to_char(:fromdate,'dd/mm/rr');
tdate := to_char(:lastdate,'dd/mm/rr');
pathr := :gla_path;
cname := :co_name;
if substr(:code,7,3) = '000' then
srw.message(300,'Detail not available..');
return;
end if;
srw.run_report('report='||pathr||'ledger.rep '||' co_name="'||cname||'" fromcode='||:code||' lastcode='||:code||
' fromdate='||mdate||' lastdate='||tdate||' batch=no gla_path='||:gla_path);
EXCEPTION
when srw.run_report_failure then
srw.message(30, 'Error in report.');
raise srw.program_abort;
end;

----- Code end here

Thanks
Saleem
Re: urgent run report with in report [message #226237 is a reply to message #226026] Fri, 23 March 2007 01:03 Go to previous message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
thanks saleem.
Previous Topic: Error while converting Reports 1.x -> Reports 9.0
Next Topic: passing number of parameteres in a single parameter
Goto Forum:
  


Current Time: Sun Dec 04 23:00:45 CST 2016

Total time taken to generate the page: 0.08523 seconds