IMAGE IN SQL REPORTING SERVICES

[member27]

HI ALL, Iam using sql reporting services ,i want to keep image from database I kept IMAGE AND KEPT THE DATASOURCE FIELD AS (EX PHOTO_LOCATION) IN THAT PHOTO_LOCATION FIELD IAM HAVING IMAGE NAME .. (I ALSO KET THE IMAGE LOCATION IN TAT FILED AND CHECKED ,BUT IMAGE IS NOT COIMG) WHEN I RUN THE REPORT IMAGE IS NOT VISIBLE ONLY TAT BLANK IMAGE IS COMING .I ALSO KEPT THE MIMET TYPE CORRECTLY

[ChandraRam]

By

cbenan wrote:

IN THAT PHOTO_LOCATION FIELD IAM HAVING IMAGE NAME ..

do you mean the image's file name? You need to store the actual image in your database, and then use it in your report. Google for how to store images in a database - I'm sure you will find a large number of hits on CP too. Using all caps in a message is the equivalent of shouting

[member27]

ok...i hvae image path also in my database ..i gvae that field and checked ..but also it is not wrking

[Ben Fair]

I believe there is a property of the image that can be set to 'External' that allows you to use the value to refer to a location; however, this may only work with a URL location or perhaps in UNC format. Sorry, but I don't recall the name of the property off-hand.

Keep It Simple Stupid! (KISS)