I am generating some weekly reports in Crystal Reports and exports it to RTF (Disk File). I have one text file which displays min:sec. I need to do an average on min:sec for 7 days. For that I have created some formula's using ToNumber, ToText, etc. If I export it from crystal report it exports fine. But when I am trying to export through VB automation it gives me runtime error-'2147191667(8004748d): The String in non-numeric'.
VB Code :
Set crxExportOptions = Report.ExportOptions
crxExportOptions.FormatType = crEFTExactRichText
crxExportOptions.DestinationType = crEDTDiskFile
crxExportOptions.DiskFileName = "C:\Reports\Weekly.rtf"
Initially when I was not displaying the average for min:sec the above vb code was running fine.
Anyhelp is appreciated. Thanks,