Results 1 to 4 of 4

Thread: Picture in Report

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2004
    Location
    Kolkata, India
    Posts
    290

    Picture in Report

    Hi

    I save the picture in SQL Database as binary format through VB6
    and now I want to display the the picture in crystal report9.

    How can I do this Can anybody help on the issue


    Thanks

    ASM

  2. #2
    Just Married shakti5385's Avatar
    Join Date
    Mar 2006
    Location
    Udaipur,Rajasthan(INDIA)
    Posts
    3,747

    Thumbs up Re: Picture in Report

    I never use the crystal report for binary picture, but I want to suggest you that save the picture in a folder and save the path of that picture in your database as a string.
    Other wise your database gets heavy if there is so much data.
    And regarding your problem for calling the binary picture I am searching.

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

    Re: Picture in Report

    SQL Server databases are very powerful and if there is enough power and other resources on the server where SQL db is installed, it can handle storing image data. The harder part is to bind the image control to the field. Not sure if its automatic now in CR 9 or newer as I only have 8.5.

    RhinoBull has a good example of reading and writting images to and from a db in one of the links in his signature.
    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

  4. #4

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2004
    Location
    Kolkata, India
    Posts
    290

    Re: Picture in Report

    I will Change the same from binary to string.
    But how can I display the picture in crystal report.
    Pls guide through code..

    Thanks

    ASM

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