how to export crystal report in excel file using vb 6.0
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3

Thread: how to export crystal report in excel file using vb 6.0

  1. #1
    Join Date
    Mar 2005
    Posts
    33

    Question how to export crystal report in excel file using vb 6.0

    hi

    I want to write a code in vb which will directly export crytal report into excel or pdf format.... Also tell me which components should i use?

    thnx in advance,
    varsha

  2. #2
    Join Date
    Jul 2003
    Location
    Florida
    Posts
    651

    Re: how to export crystal report in excel file using vb 6.0

    Do a search here
    I'd rather be wakeboarding...

  3. #3
    Join Date
    Jun 2004
    Location
    Kashmir, India
    Posts
    6,808

    Re: how to export crystal report in excel file using vb 6.0

    Hi Varsha,

    Use something similar to this one...

    Code:
    With CrystalReport1
    		 'Your other code like setting report Filename
    		 'referencing the database and otehr stuff goes here
    		 'Code for exporting the file to excel format is here
    		 'set the destination type as file
    		 .Destination = crptToFile
    		 'Set the file type to excel
    		 .PrintFileType = crptExcel50
    		 'Set the FileName
    		 .PrintFileName = "C:\MyFile.xls"
    		 .Action = 0
    End With

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center