OraFAQ Forum: Reports & Discoverer » How to call a report from a report in reports 10g ?

Home » Developer & Programmer » Reports & Discoverer » How to call a report from a report in reports 10g ?

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

How to call a report from a report in reports 10g ? [message #227120]

Tue, 27 March 2007 06:29

bazish
Messages: 28
Registered: August 2006

Junior Member

Which is the easiest way of calling a report from a report in reports 10g ?

Capri !

Report message to a moderator

Re: How to call a report from a report in reports 10g ? [message #227383 is a reply to message #227120]

Wed, 28 March 2007 02:17

rubi
Messages: 10
Registered: August 2006

Junior Member

try srw.run_report

Report message to a moderator

Re: How to call a report from a report in reports 10g ? [message #227485 is a reply to message #227120]

Wed, 28 March 2007 06:31

bazish
Messages: 28
Registered: August 2006

Junior Member

i 'll definitly try.but where ?

Report message to a moderator

Re: How to call a report from a report in reports 10g ? [message #227604 is a reply to message #227485]

Wed, 28 March 2007 15:04

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

In one of PL/SQL program units you're about to write and invoke from one of report's triggers (for example, AFTER PARAMETER FORM, BEFORE REPORT, ...), or directly from a trigger.

Report message to a moderator

Re: How to call a report from a report in reports 10g ? [message #227667 is a reply to message #227485]

Wed, 28 March 2007 23:38

bazish
Messages: 28
Registered: August 2006

Junior Member

Actually the scenario is that I have a report in which suppose a list of names is there. I want another report called on the basis of a name selected by passing that name_id as a parameter to the called report.

In Reports 6i that is easily done by a BUTTON. But i am unable to find a solution here.

Hope its clear now.

Capri !

Report message to a moderator

Re: How to call a report from a report in reports 10g ? [message #227677 is a reply to message #227667]

Thu, 29 March 2007 00:45

rubi
Messages: 10
Registered: August 2006

Junior Member

specify 'PL/SQL' in the filter type of your calling report's query and insert the srw.run_report parameters in the pl/sql filter.

SRW.RUN_REPORT
('REPORT=name_the_report
parameter_name='||:column_name);

you second report should be ready to acccept the parameter from the calling report.

Report message to a moderator

Re: How to call a report from a report in reports 10g ? [message #227690 is a reply to message #227677]

Thu, 29 March 2007 01:23

bazish
Messages: 28
Registered: August 2006

Junior Member

by doing it when my second report 'll be called ?

Capri !

Report message to a moderator

Re: How to call a report from a report in reports 10g ? [message #227698 is a reply to message #227120]

Thu, 29 March 2007 02:03

rubi
Messages: 10
Registered: August 2006

Junior Member

your second report will be invoked by the srw.run_report package.

Report message to a moderator

Re: How to call a report from a report in reports 10g ? [message #227699 is a reply to message #227698]

Thu, 29 March 2007 02:06

bazish
Messages: 28
Registered: August 2006

Junior Member

I know that package 'll invoke my report. But the problem is.Suppose i have 10 records on a page & I want to call a report for each record one by one.

How i may achieve this ?

Capri !

Report message to a moderator

Re: How to call a report from a report in reports 10g ? [message #227703 is a reply to message #227120]

Thu, 29 March 2007 02:10

rubi
Messages: 10
Registered: August 2006

Junior Member

since you put srw.run_report in the group's pl/sql filter for every field retrieve from your query it will execute the srw.run_report commands.

Report message to a moderator

Re: How to call a report from a report in reports 10g ? [message #227704 is a reply to message #227703]

Thu, 29 March 2007 02:16

bazish
Messages: 28
Registered: August 2006

Junior Member

then if i have 10 records on a report, 10 reports 'll be called ?

in this case its of no use for me.

my requirments are a bit different. i want to invoke report at will against any record of my choice.

Capri !

Report message to a moderator

Re: How to call a report from a report in reports 10g ? [message #227705 is a reply to message #227704]

Thu, 29 March 2007 02:23

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

So write a FORM instead (not report); display records in a tabular data block. Create a "Print report" button and run report for the current record.

Report message to a moderator

Re: How to call a report from a report in reports 10g ? [message #227708 is a reply to message #227705]

Thu, 29 March 2007 02:33

bazish
Messages: 28
Registered: August 2006

Junior Member

this is the conservative solution.i know this already.anyhow thanx very much for the help.

i just wanted to know that if there is any option in reports 10 g ?

Capri !

Report message to a moderator

Re: How to call a report from a report in reports 10g ? [message #227719 is a reply to message #227120]

Thu, 29 March 2007 03:05

rubi
Messages: 10
Registered: August 2006

Junior Member

does it mean that your query's result will be the reports name?
if that is so, just specify that the report is equal to that field.

Report message to a moderator

Re: How to call a report from a report in reports 10g ? [message #227721 is a reply to message #227719]

Thu, 29 March 2007 03:13

bazish
Messages: 28
Registered: August 2006

Junior Member

no thats not so. i just want to call a report on a suitable trigger for any record on a page of a report.

suppose.

report out put is.

Name_Id Name
1 Capri
2 Rubi

now i rewuire to call an individual report for capri or rubi via a trigger whenevr i want.

in reportd 6i we use to put a button against each record.& the report is called by clicking on that.

what whould we do here ?

Capri !

Report message to a moderator

Previous Topic:	How to create report at runtime / use parameter for column (merged)
Next Topic:	How to make borders uniform when viewing the report on web?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 19:50:17 CDT 2024