INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

COM and Automation

Export a Crystal Report to a different format without prompt by mgagnon
Posted: 14 Mar 03

oCRYSTAL = CREATEOBJECT('CrystalRuntime.Application')
oReport = oCRYSTAL.OpenReport('C:\employee.RPT')
oExport = oReport.ExportOptions()
oExport.DestinationType = 1 && To file
oExport.FormatType = 27 && Excel format
oExport.DiskFileName = "C:\employee.XLS" && Name of the file
oReport.Export(.F.) && Export without prompting

For the FormatType :
  • oExport.FormatType = 1 && Crystal Report

  • oExport.FormatType = 2 && Data Interchange

  • oExport.FormatType = 3 && Record Style

  • oExport.FormatType = 5 && Comma seperated values

  • oExport.FormatType = 6 && Tab seperated values

  • oExport.FormatType = 7 && Character seperated values

  • oExport.FormatType = 8 && Text

  • oExport.FormatType = 9 && Tab seperated text

  • oExport.FormatType = 10 && Paginated Text

  • oExport.FormatType = 11 && Lotus 123WKS

  • oExport.FormatType = 12 && Lotus 123WK1

  • oExport.FormatType = 13 && Lotus 123WK3

  • oExport.FormatType = 14 && Word for Windows

  • oExport.FormatType = 21 && Excel 5.0

  • oExport.FormatType = 22 && Excel 5.0 tabular

  • oExport.FormatType = 23 && ODBC

  • oExport.FormatType = 24 && HTML32 standard

  • oExport.FormatType = 25 && Explorer32 Extend

  • oExport.FormatType = 27 && Excel 7.0

  • oExport.FormatType = 28 && Excel 7.0 tabular

  • oExport.FormatType = 29 && Excel 8.0

  • oExport.FormatType = 30 && Excel 8.0 tabluar

  • oExport.FormatType = 31 && Portable Document format (PDF)

  • oExport.FormatType = 32 && HTML40

  • oExport.FormatType = 33 && Crystal Report 7.0

  • oExport.FormatType = 34 && Report definition

  • oExport.FormatType = 35 && Exact Rich Text

  • oExport.FormatType = 36 && XML

Mike Gagnon



Back to Microsoft: Visual FoxPro FAQ Index
Back to Microsoft: Visual FoxPro Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close