COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognosryan on 22 Jan 2014 10:03:32 AM

Title: Embedding image into a report
Post by: cognosryan on 22 Jan 2014 10:03:32 AM
Hi all,

I've been asked if this is possible but i've never come across this before. We have a report which has a list of candidate information for interviews. Is it possible to embed their photos if they are stored in the DB as image.

Also what are the limitations e.g size,quality etc and what effect this will have on report generation.

Thanks

Ryan
Title: Re: Embedding image into a report
Post by: MFGF on 22 Jan 2014 11:38:31 AM
Hi,

I'm thinking it would be a lot easier to have the images in a folder on the web server machine and hold the image name in the database. That way you could change the properties of the image name item to be an image and prefix the URL to that folder on the web server.

Cheers!

MF.
Title: Re: Embedding image into a report
Post by: cognosryan on 23 Jan 2014 04:43:25 AM
Hi MF,

Thank you for the reply,

I was thinking of the same approach however the amount of photos will be in the thousands and updated daily in the source system.

The report is hoping to work like this:

promptpage select the date of interview> Select the interview time slot>  this will show basic candidate information in that time with photos for security.

Back to the drawing board  :D

Cheers

Ryan
Title: Re: Embedding image into a report
Post by: cognosryan on 28 Jan 2014 06:23:21 AM
Just incase anyone is having the same problem, Cognos cannot transform image data BLOB (binary large objects) into a recognisable format.