Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1044
  • Last Modified:

Export to Excel

I used VB6 to export the Crystal Report into Excel, but I got my export in Excel as a picture. There no columns or rows. Which code should I use to export the Crystal into real excel format?
Here is code that I used:


With crReport.ExportOptions
     .DestinationType = crEDTDiskFile
     .FormatType = crEFTExcel97
     .DiskFileName = gsExpFilePath
     .ExcelUseConstantColumnWidth = True
    '.ExcelConstantColumnWidth = 50
     .ExcelExportAllPages = True
 End With



Appreciate your time, DDB
0
DDB
Asked:
DDB
  • 2
  • 2
2 Solutions
 
mlmccCommented:
Which version of Crystal?

CR9 added a "Data only" capability.  Otherwise it is much more WYSIWYG.

For help look at
http://support.businessobjects.com/communityCS/TechnicalPapers/scr_exportexcel.pdf.asp

mlmcc
0
 
mlmccCommented:
My answer {13784803} or jrmn's {13791608} should have solved it.

mlmcc
0
 
jrmnCommented:
yes, I also think so...
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now