locked
add image file to crystal report from sql server 2000 RRS feed

  • Question

  • Hi,

    In my project i need to include the image files into details section of the crystal report and i will be having those images in a table in the sql server 2000 database as image fields..and im doing this in c#(VS 2008)..so can anyone help on this one..

    Tuesday, November 3, 2009 5:37 AM

Answers

  • Harry this is not the issue,

    The sample you point to uses a datastream to display an image in the viewer background not in the report itself.

    If you have the data in SQL stored as SQL Type Image then you can simply insert the table field into the Crystal report and Crystal should do the conversion for you and display the images in the report.

    I've just tested this with a dataset with images in and it works fine out of the box.

    Regards

    Rupert
    the problem is not what you don't know it's what you think you know that's wrong
    • Proposed as answer by Rupert Davis Monday, November 9, 2009 2:46 PM
    • Marked as answer by Harry Zhu Wednesday, November 11, 2009 4:32 AM
    Monday, November 9, 2009 2:45 PM

All replies

  • Hi,

    You might want to push the data into a dataset then show the image :
    http://www.codeproject.com/KB/vb/Image_in_Crystal_Reports.aspx

    Harry


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Monday, November 9, 2009 4:01 AM
  • I want to know,too.
    Monday, November 9, 2009 9:20 AM
  • Harry this is not the issue,

    The sample you point to uses a datastream to display an image in the viewer background not in the report itself.

    If you have the data in SQL stored as SQL Type Image then you can simply insert the table field into the Crystal report and Crystal should do the conversion for you and display the images in the report.

    I've just tested this with a dataset with images in and it works fine out of the box.

    Regards

    Rupert
    the problem is not what you don't know it's what you think you know that's wrong
    • Proposed as answer by Rupert Davis Monday, November 9, 2009 2:46 PM
    • Marked as answer by Harry Zhu Wednesday, November 11, 2009 4:32 AM
    Monday, November 9, 2009 2:45 PM
  • thanks..it works...
    Tuesday, November 10, 2009 11:41 AM