Author Topic: [Closed unsolved] Displaying pictures stored in Database  (Read 13400 times)

Offline ReportNet Addict

  • Global Moderator
  • Statesman
  • *****
  • Join Date: Sep 2005
  • Posts: 957
  • Forum Citizenship: +65/-41
  • Creator of the Impact Suite
    • The Impact Suite
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
« Last Edit: 20 Sep 2005 12:28:24 pm by ReportNet Addict »

Darek

  • Guest
Re: Displaying pictures stored in Database
« Reply #1 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.

Offline ReportNet Addict

  • Global Moderator
  • Statesman
  • *****
  • Join Date: Sep 2005
  • Posts: 957
  • Forum Citizenship: +65/-41
  • Creator of the Impact Suite
    • The Impact Suite
Re: Displaying pictures stored in Database
« Reply #2 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....

Darek

  • Guest
Re: Displaying pictures stored in Database
« Reply #3 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.

Offline ReportNet Addict

  • Global Moderator
  • Statesman
  • *****
  • Join Date: Sep 2005
  • Posts: 957
  • Forum Citizenship: +65/-41
  • Creator of the Impact Suite
    • The Impact Suite
Re: Displaying pictures stored in Database
« Reply #4 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

Offline ahladia

  • Associate
  • **
  • Join Date: Jun 2010
  • Posts: 3
  • Forum Citizenship: +0/-0
Re: [Closed unsolved] Displaying pictures stored in Database
« Reply #5 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

 


       
Twittear