OraFAQ Forum: Reports & Discoverer » How to Automate Report

Home » Developer & Programmer » Reports & Discoverer » How to Automate Report

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

How to Automate Report [message #255759]

Wed, 01 August 2007 12:11

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

Report message to a moderator

Re: How to Automate Report [message #255803 is a reply to message #255759]

Wed, 01 August 2007 15:56

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: How to Automate Report [message #256159 is a reply to message #255803]

Fri, 03 August 2007 04:09

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

Report message to a moderator

Re: How to Automate Report [message #256169 is a reply to message #255803]

Fri, 03 August 2007 04:41

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: How to Automate Report [message #256191 is a reply to message #256169]

Fri, 03 August 2007 06:42

Imran_Chennai
Messages: 22
Registered: June 2007
Location: CHN,INDIA

Junior Member

Is there any way to call report from plsql procedure

Report message to a moderator

Re: How to Automate Report [message #257355 is a reply to message #256191]

Wed, 08 August 2007 02:52

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

Report message to a moderator

Re: How to Automate Report [message #257362 is a reply to message #257355]

Wed, 08 August 2007 03:14

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	Dynamic image in report from path
Next Topic:	Printing a report in Landscape

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 01:19:28 CST 2024