COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: sir_jeroen on 17 Sep 2005 09:52:43 AM

Title: [Closed unsolved] Displaying pictures stored in Database
Post by: sir_jeroen on 17 Sep 2005 09:52:43 AM
Has any1 experencie in displaying pictures that are stored in a database BLOB field?

I set MimeType to "image/jpeg" in Framework Manager and "DisplayType" to "Picture". I also tried MimeType to "image/bmp" and "DisplayType" to "Value".

I'm using SQLServer's Northwind as sample database and I want to display the Employee's photo in the table Employee.

Nothing worked :S
Title: Re: Displaying pictures stored in Database
Post by: Darek on 19 Sep 2005 12:16:50 PM
I don't know if you can use BLOBs directly. I believe you will have to develop a servlet or .Net page to return it from the databse as image/jpeg.
Title: Re: Displaying pictures stored in Database
Post by: sir_jeroen on 19 Sep 2005 12:32:37 PM
Than can you tell me why there's a mimetype option?
I would say that it would render the request as an image....
Title: Re: Displaying pictures stored in Database
Post by: Darek on 20 Sep 2005 11:52:16 AM
We are talking HTML here right? If so, you cannot inject any binary data into HTML output to make an image. You will need to have a servlet, JSP or ASPX page that will set the mime type in an HTML header while returning a BLOB in response to an HTML query.
Title: Re: Displaying pictures stored in Database
Post by: sir_jeroen on 20 Sep 2005 12:27:58 PM
Ok.. so I was guessing wrong here :'(
Tnx for your efforts and advice... I'll close the topic now
Title: Re: [Closed unsolved] Displaying pictures stored in Database
Post by: ahladia on 13 Sep 2010 08:43:18 AM
Hi Darek;
have you figured out yet how to display a stored Oracle BLOB image that is saved as jpeg, in Report studio?

Dimos