Hi,

I'm a Crystal Reports newbie, and I need help, I want to write a java programm that work periodicly(each hour for example ). This programm should update the report source *.rpt with data taked from a mysql database and export it in a PDF file.

I'd like to know what I need to do that.
I have Crystal Reports 9 advanced edition and crystal enterprise reports application server.

Thanks

CR 9 comes along with a new version of Crystal Enterprise ,namely,8.5 which has in-built Scheduling options.

Advanced Crystal Enterprise allows :    Flexible scheduling service for larger reports

• Minimize hits on your database by scheduling a report and letting users view the pre-generated instance.
• Deliver larger reports with acceptable end-user response time.
• Automatically output reports in specific formats.
• Schedule reports to specific destinations (e.g. email, FTP).

I would suggest that you take a look at the example provided by Crystal Decisions by following the link :Crystal Enterprise Java™ Report Application Server sample code 

 

Various other Report Scheduling tools are also available : To know more ,please visit : Crystal Reports Scheduling / Distribution

 

 

Pooja M.,
http://home.attbi.com/~pooja.mohan