Want to schedule cystal report8

[AnandMishra]

I created roughtly 10 reports for company. All are working fine.

Problem is that daily morning i have to open the report and refresh the data to populate new data. It ia realy pain. Is there any way to schedule the report and populate new data from background? so morning report with new data is ready for manager.

Thanks for your help....

Anand
Anand
anandm@entcomm.com

 

[hmohrmann]

I use a Visual Basic routine that works stand alone in VB or as part of a Access database. The routine opens the original report, refreshes the data, and then saves the report in a different folder. That way I don't have to worry about damage to the original report.

Dim Rs As Recordset
Dim strStartDirectory As String
Dim strEndDirectory As String
Dim strFile As String
Dim crpApplication As CRPEAuto.Application
Dim crpReport As CRPEAuto.Report
Set crpApplication = CreateObject("Crystal.CRPE.Application&quot
Set crpReport = crpApplication.OpenReport(strStartDirectory & "\" & Rs!ReportName)
crpReport.DiscardSavedData
crpReport.ExportOptions.DiskFileName = strEndDirectory & "\" & Rs!ReportName
crpReport.ExportOptions.DestinationType = crEDTDiskFile
crpReport.ExportOptions.FormatType crEFTCrystalReport
crpReport.Export (False)

I hope this helps.
Harry

 

[John43]

Version 8.5 provides this functionality.