BLOB (Image) no displaying

[CrystalGuru2005]

I am using SQL Server 2k, CR 10, and have a field (image data type). I am trying to display it in Crystal report but always get empty or blank image. What i am missing ?

Thanks

 

[dgillz]

What type of datbase? What type of image? .gif? bmp? I would try several different formats as I know that not all of them work well with crystal.

What are you seeing instead of the image? Blank space?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[CrystalGuru2005]

I am using
1. MS SQL Server 2000
2. table with a column has data type (image)
3. image: I tried jpeg, png, tiff
4. I see blank space

when I click field in Crystal report it recognize it as BLOB field but diplay blank.

Thanks

 

[CrystalGuru2005]

Also, my TSQL insert statement looks like (only one column with image data type)

insert into imagetable values ('C:\AK-Per\Pictures\HPIM1378.JPEG')

Just in case there is something wrong with sql statement.

 

[dgillz]

Why do you have an insert statement? Aren't the images ALREADY in the database? Crystal is used to report against the database, not insert values into it.

Drag the blob database field (not a path to an image as you seem to indicate) onto the report canvas. Execute the report. What do you see?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[CrystalGuru2005]

The INSERT statement is not part of Crystal report. I have run it seperately in query analyzer to have a table with images. When I drag the blob field in report canvas it shows blank field.

I don't know how can I make it more simple.

thanks

 

[Turkbear]

Hi,
From the Crystal docs regarding Images and SqlServer, it appears that the SqlServer BCP command has to be used to insert the image into the table...Don't know if that is an issue here, but thought it worth mentioning..Can you display the image from the database by any other means to be sure it is actually inserted correctly?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[vidru]

That INSERT statement isn't loading the images into your database, it's just inserting the paths. There's a whitepaper on the BO site that gives some examples of how to upload images into different types of databases:

http://support.businessobjects.com/communityCS/TechnicalPapers/cr_insert_images.pdf.asp

-dave

 

[CrystalGuru2005]

Thanks all you guys, all I was missing the BCP utility to insert the image into the database. It works fine now, though it has certain limitations (image type and size)

Thanks again