OraFAQ Forum: Reports & Discoverer » how to call report automatically

Home » Developer & Programmer » Reports & Discoverer » how to call report automatically (Report Builder 10g, Windows XP, Windows 2008 Server)

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

how to call report automatically [message #565289]

Mon, 03 September 2012 03:08

new_oracle2011
Messages: 164
Registered: March 2011
Location: Qatar

Senior Member

Is it possible to automate the execution of some reports build with Oracle report builder? Like I want to run such and such report to run daily at 2:00pm or at the end of every month/year.

Report message to a moderator

Re: how to call report automatically [message #565291 is a reply to message #565289]

Mon, 03 September 2012 03:21

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

Senior Member
Account Moderator

Schedule them with your operating system's scheduling tool (that would be Task Scheduler on MS Windows). You'd execute the report from the command line (see documentation for more info); actually, you'd probably want to put that statement into the batch (.BAT) file and run .bat using the scheduler.

Report message to a moderator

Re: how to call report automatically [message #565292 is a reply to message #565291]

Mon, 03 September 2012 03:38

new_oracle2011
Messages: 164
Registered: March 2011
Location: Qatar

Senior Member

can you do me another favour? how you create batch (.bat) file?

Report message to a moderator

Re: how to call report automatically [message #565293 is a reply to message #565292]

Mon, 03 September 2012 03:43

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

Senior Member
Account Moderator

In any text editor (such as Notepad). You'd just put a statement that runs a report from the command line into that batch file.

Report message to a moderator

Re: how to call report automatically [message #565379 is a reply to message #565293]

Tue, 04 September 2012 03:18

new_oracle2011
Messages: 164
Registered: March 2011
Location: Qatar

Senior Member

I am using rwservlet for automatic execution of reports. Automatic printing and creating pdf file is working properly. but when i come to send email through below command and i was getting an error like REP-50159 (Executed successfully but there were some errors when distribute the output)

http://172.16.13.5:7778/reports/rwservlet?server=rep_pda_server_frhome1+report=AUTO_REPORT.rdf+userid=scott/tiger@db.world+desformat= pdf+DESTYPE=mail+DESNAME="xyz@abc.com"=CC="xyz@abc.com"+BCC="xyz@abc.com"+REPLYTO="xyz@abc.com"+FROM="xyz@abc.com"

Report message to a moderator

Re: how to call report automatically [message #565396 is a reply to message #565379]

Tue, 04 September 2012 04:14

new_oracle2011
Messages: 164
Registered: March 2011
Location: Qatar

Senior Member

I have searched this REP-50159 error in google and i found that i have to set the email server (SMTP) in Oracle Reports Server. If possible can somebody help me in setting this from very first step?

Report message to a moderator

Previous Topic:	How to fetch data based on the given criteria.....
Next Topic:	REP-1219 with text file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 20 00:56:48 CDT 2013

Total time taken to generate the page: 0.37649 seconds