JimmyEdwards
Technical User
Hi All,
I'm reposting this in here, because I don't think I put it in the right place to begin with.
Db - SQL 2005
Crystal XI (11.0.0.1282) Developer edition
Connecting via an ODBC connection using the SQL native driver.
I have a BLOB field in my database containing a bmp image. When I try to insert this into a crystal report it shows as a blank field (i.e. does not show the image). Here's what I've tried:-
1) Replaced the bmp with a jpg - made no difference.
2) Set the field to can grow (in case of blank space). The field size doesn't change at all, still no image displayed.
3) Tried placing the image directly in the report - the image does display properly, but I need the report to pick up the image from the database, as there is more than one possibility.
4) Tried an old version of crystal. We used to use Crystal version 4.6. I tried it in this, and it works perfectly! The image displays exactly as it should.
5) Tried printing and exporting in the hope that it just wasn't showing the image in the crystal preview screen - it doesn't show on a print or a pdf export either.
Does anyone have any idea why it won't work in crystal 11? Are there any settings relating specifically to BLOB fields hidden away somewhere? THe image in the database is obviously OK because the old version of crystal displays it OK.
Cheers
James
I'm reposting this in here, because I don't think I put it in the right place to begin with.
Db - SQL 2005
Crystal XI (11.0.0.1282) Developer edition
Connecting via an ODBC connection using the SQL native driver.
I have a BLOB field in my database containing a bmp image. When I try to insert this into a crystal report it shows as a blank field (i.e. does not show the image). Here's what I've tried:-
1) Replaced the bmp with a jpg - made no difference.
2) Set the field to can grow (in case of blank space). The field size doesn't change at all, still no image displayed.
3) Tried placing the image directly in the report - the image does display properly, but I need the report to pick up the image from the database, as there is more than one possibility.
4) Tried an old version of crystal. We used to use Crystal version 4.6. I tried it in this, and it works perfectly! The image displays exactly as it should.
5) Tried printing and exporting in the hope that it just wasn't showing the image in the crystal preview screen - it doesn't show on a print or a pdf export either.
Does anyone have any idea why it won't work in crystal 11? Are there any settings relating specifically to BLOB fields hidden away somewhere? THe image in the database is obviously OK because the old version of crystal displays it OK.
Cheers
James