OraFAQ Forum: Reports & Discoverer » urgent run report with in report

Home » Developer & Programmer » Reports & Discoverer » urgent run report with in report

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

urgent run report with in report [message #225500]

Tue, 20 March 2007 02:30

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

Report message to a moderator

Re: urgent run report with in report [message #225664 is a reply to message #225500]

Tue, 20 March 2007 15:20

msaleem
Messages: 44
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

Report message to a moderator

Re: urgent run report with in report [message #225963 is a reply to message #225664]

Thu, 22 March 2007 02:05

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

Report message to a moderator

Re: urgent run report with in report [message #225986 is a reply to message #225664]

Thu, 22 March 2007 03:25

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

Report message to a moderator

Re: urgent run report with in report [message #226011 is a reply to message #225986]

Thu, 22 March 2007 05:00

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

Report message to a moderator

Re: urgent run report with in report [message #226026 is a reply to message #225500]

Thu, 22 March 2007 06:08

msaleem
Messages: 44
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

Report message to a moderator

Re: urgent run report with in report [message #226237 is a reply to message #226026]

Fri, 23 March 2007 01:03

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

thanks saleem.

Report message to a moderator

Previous Topic:	Error while converting Reports 1.x -> Reports 9.0
Next Topic:	passing number of parameteres in a single parameter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 16:30:58 CST 2024