Results 1 to 4 of 4

Thread: Crytal report -> export to excel

  1. #1

    Thread Starter
    Junior Member
    Join Date
    May 2007
    Posts
    16

    Crytal report -> export to excel

    Can anyone tell me how can i export crystal report to an excel file in visual basic 6?

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Crytal report -> export to excel

    Moved from the CodeBank

  3. #3
    Frenzied Member Asgorath's Avatar
    Join Date
    Sep 2004
    Location
    Saturn
    Posts
    2,036

    Re: Crytal report -> export to excel

    Hi.
    In vb.net its very simple.
    Code:
    crReportDocument.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile
    crReportDocument.ExportOptions.ExportFormatType = ExportFormatType.Excel
    crReportDocument.Export()
    "The dark side clouds everything. Impossible to see the future is."

  4. #4
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Crytal report -> export to excel

    EXPORTING DLLs


    Distribute these DLLs if your application has exporting functionality. Only those DLLs distributed will be valid options for exporting. For example, if only U2ddisk.dll and U2fcr.dll are distributed, then you can only export a report to a file disk in a Crystal Report format.


    Refer to 'Runtime.hlp' and look under 'Exporting' for more information.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

Posting Permissions

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



Click Here to Expand Forum to Full Width