How To Export Crystal Report to Excel 8.0
I'm using visual basic 6.0 and Crystal Reports 8.0.
Thanks
[151 byte] By [breeky5] at [2007-11-20 11:10:38] 
Does any body know how to export a report directly to Excel 8.0 file.
I'm using visual basic 6.0 and Crystal Reports 8.0.
Thanks
# 1 Re: How To Export Crystal Report to Excel 8.0
I already don't remember V8, but in 10 and XI there is and Export button icon -- envelope - what is giving you the list of different versions of Excelfor your export
ssakkerm at 2007-11-9 14:11:35 >
# 2 Re: How To Export Crystal Report to Excel 8.0
Crystal is an object to vb6In vb6 we manage the object by its properties,methods and events
So,
if you are using ocx :
Crystal1.ReportFileName = "somerpt.rpt"
Crystal1.Destination = crptToFile
Crystal1.PrintFileType = crptExcel50
Crystal1.PrintFileName = " xxxxx.xls"
Crystal1.Action = 1
if you are using rdc
Dim MyCR as CRAXDRT.Application
Dim MyRpt as CRAXDRT.Report
MyRpt= MyCR.OpenReport( "somerpt.RPT")
MyRpt.ExportOptions.DestinationType= 1 '1=file
MyRpt.ExportOptions.FormatType= 27 '27=excel
MyRpt.ExportOptions.DiskFileName= "somexls.xls"
MyRpt.Export(False )
This is only a start, i don't have vb6 & cr8.5 installed here
jggtz at 2007-11-9 14:12:37 >
# 3 Re: How To Export Crystal Report to Excel 8.0
Thanks for the reply guys...Yes, i've been using ocx to export reports directly to file. But the problem is, it only supports versions excel 5.0 and below. Excel 5 has a limit of appx. 16000 rows and my report needs more than that.
Maybe I'll give rdc a try and post my comments later..
Thanks again!~
breeky5 at 2007-11-9 14:13:35 >
# 4 Re: How To Export Crystal Report to Excel 8.0
Hi everyone,Just want to inform that the RDC works just fine!. Format type has more options than the ocx w/c is better.
Thanks!~
breeky5 at 2007-11-9 14:14:42 >
