Home » Developer & Programmer » Reports & Discoverer » How to call a report from a report in reports 10g ?
How to call a report from a report in reports 10g ? [message #227120] Tue, 27 March 2007 06:29 Go to next message
bazish
Messages: 28
Registered: August 2006
Junior Member
Which is the easiest way of calling a report from a report in reports 10g ?

Capri !
icon12.gif  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 Go to previous messageGo to next message
rubi
Messages: 10
Registered: August 2006
Junior Member
try srw.run_report
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 Go to previous messageGo to next message
bazish
Messages: 28
Registered: August 2006
Junior Member
i 'll definitly try.but where ?
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 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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.
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 Go to previous messageGo to next message
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 !

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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
bazish
Messages: 28
Registered: August 2006
Junior Member
by doing it when my second report 'll be called ?

Capri !
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 Go to previous messageGo to next message
rubi
Messages: 10
Registered: August 2006
Junior Member
your second report will be invoked by the srw.run_report package.
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 Go to previous messageGo to next message
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 !
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
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 !
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 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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.
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 Go to previous messageGo to next message
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 !
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 Go to previous messageGo to next message
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.
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 Go to previous message
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 !
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:
  


Current Time: Sun Dec 04 10:26:19 CST 2016

Total time taken to generate the page: 0.06143 seconds