How to Automate Report [message #255759] |
Wed, 01 August 2007 12:11 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Imran_Chennai
Messages: 22 Registered: June 2007 Location: CHN,INDIA
|
Junior Member |
![ryimrankhan@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
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 #257355 is a reply to message #256191] |
Wed, 08 August 2007 02:52 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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.
|
|
|