locked
insert image from database to text object in crystal report using vb.net RRS feed

  • Question

  • User532789297 posted

    Hi!

    how to insert image from database to text object in crystal report using vb.net?

    Thanks.

    Thursday, June 29, 2017 9:03 AM

All replies

  • User-1509636757 posted

    Based on your question description, I understand that you are storing Images in byte format in database table. If this is correct then Please refer to these step by step articles that demonstrate how you can display images from database table by having a DataColumn in DataSet with DataType as System.Byte[]

    1. Crystal Reports Display Images From Database Asp.Net
    2. Display image from database in Crystal Report in ASP.Net using C# and VB.Net
    Thursday, June 29, 2017 9:20 AM
  • User-707554951 posted

    Hi  bearamzz

    The text object is used to display text, database fields, and special report fields. Each text object can display one of these or a combination of all three.
    The purpose of following links:

    1. show how you to upload and save images directly in a SQL Server database table as binary data and display in Crystal Reports.

    2. Show how you to store images in a folder and display in Crystal Reports.

    http://www.c-sharpcorner.com/UploadFile/4d9083/store-and-retrieve-image-on-crystal-report-from-sql-database/

    https://www.aspsnippets.com/Articles/Display-image-from-database-in-Crystal-Report-in-ASPNet-using-C-and-VBNet.aspx

    if you just want to insert image binary to text object. You could refer to the steps below to learn how to combine database fields in a text object

    1. Create a text box and size it big enough to hold both db fields.

    2. Insert both fields initially in the report footer field temporarily.

    3. drag the first field into the text box. You should now see the db
    field name {field1}  inside the text box. 

    https://www.youtube.com/watch?v=WMTQxU-GTnI

    Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    Best regard

    Cathy

    Friday, June 30, 2017 2:32 AM