Home » Developer & Programmer » Reports & Discoverer » How to Automate Report
How to Automate Report [message #255759] Wed, 01 August 2007 12:11 Go to next message
Imran_Chennai
Messages: 22
Registered: June 2007
Location: CHN,INDIA
Junior Member

Hi Friends,

I am new to Oracle Report

Can any 1 help me to automate an oracle report into batch run

I have designed a report in reports 6i, getting one input from user (say one order_number generates one page report)

I need to make it as batch run with no of inputs(more than 1 order_number and o/p should be that much no. of seperate reports goes into printer by bulk ), so that there shud not any user intervention in future

Please give ur idea how to make it effective into production run

Thanx
Imran



Re: How to Automate Report [message #255803 is a reply to message #255759] Wed, 01 August 2007 15:56 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
User input can be substituted by another table - it would contain parameters someone needs to enter prior to executing the report. Also, you'd have to include this table into the report's query.

Scheduling will have to be done using your operating system scheduling utility; on MS Windows, it would be the "Scheduled Tasks" manager.
Re: How to Automate Report [message #256159 is a reply to message #255803] Fri, 03 August 2007 04:09 Go to previous messageGo to next message
Imran_Chennai
Messages: 22
Registered: June 2007
Location: CHN,INDIA
Junior Member

Hi ,

Now the report runs w/o user input,well. The concern abt my report now is that somebody will have to manually run this process. This should be eliminated. It should be something automated, wherein it will run on it's own.

Some batch job which will trigger automatically as per the pre defined schedule

Please give idea

Thanks
Imran
Re: How to Automate Report [message #256169 is a reply to message #255803] Fri, 03 August 2007 04:41 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I already did; there's nothing else I could say about it.

Littlefoot wrote on Wed, 01 August 2007 22:56
Scheduling will have to be done using your operating system scheduling utility; on MS Windows, it would be the "Scheduled Tasks" manager.

Re: How to Automate Report [message #256191 is a reply to message #256169] Fri, 03 August 2007 06:42 Go to previous messageGo to next message
Imran_Chennai
Messages: 22
Registered: June 2007
Location: CHN,INDIA
Junior Member

Is there any way to call report from plsql procedure
Re: How to Automate Report [message #257355 is a reply to message #256191] Wed, 08 August 2007 02:52 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
yes
you can use built in functions
run_product(,,,,,);
and run_report_object();
and use form to ask user to input data in text items ,dynamo combo's or l.o.v's and then call the report using above two functions
--regards IMTIAZ
Re: How to Automate Report [message #257362 is a reply to message #257355] Wed, 08 August 2007 03:14 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I believe Imran_Chennai is talking about database stored procedures (which do not suport functions you mention), not Forms procedures.
Previous Topic: Dynamic image in report from path
Next Topic: Printing a report in Landscape
Goto Forum:
  


Current Time: Thu Dec 08 08:17:30 CST 2016

Total time taken to generate the page: 0.05508 seconds