Home » Developer & Programmer » Reports & Discoverer » how to call report automatically (Report Builder 10g, Windows XP, Windows 2008 Server)
how to call report automatically [message #565289] Mon, 03 September 2012 03:08 Go to next message
new_oracle2011
Messages: 165
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.
Re: how to call report automatically [message #565291 is a reply to message #565289] Mon, 03 September 2012 03:21 Go to previous messageGo to next message
Littlefoot
Messages: 19314
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.
Re: how to call report automatically [message #565292 is a reply to message #565291] Mon, 03 September 2012 03:38 Go to previous messageGo to next message
new_oracle2011
Messages: 165
Registered: March 2011
Location: Qatar
Senior Member
can you do me another favour? how you create batch (.bat) file?
Re: how to call report automatically [message #565293 is a reply to message #565292] Mon, 03 September 2012 03:43 Go to previous messageGo to next message
Littlefoot
Messages: 19314
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.
Re: how to call report automatically [message #565379 is a reply to message #565293] Tue, 04 September 2012 03:18 Go to previous messageGo to next message
new_oracle2011
Messages: 165
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"
Re: how to call report automatically [message #565396 is a reply to message #565379] Tue, 04 September 2012 04:14 Go to previous message
new_oracle2011
Messages: 165
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?
Previous Topic: How to fetch data based on the given criteria.....
Next Topic: REP-1219 with text file
Goto Forum:
  


Current Time: Fri Jul 25 15:42:30 CDT 2014

Total time taken to generate the page: 0.14890 seconds