Embedding image into a report

[cognosryan]

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

[MFGF]

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.

[cognosryan]

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

[cognosryan]

Just incase anyone is having the same problem, Cognos cannot transform image data BLOB (binary large objects) into a recognisable format.