Cannot view Image from database in SSRS

  • I am using the Image control in report designer to show the image from database.

    it's showing in the local system but when I deploy the report on reporting server it's not showing the image.

    I tried this

    =System.Text.Encoding.Default.GetBytes(Mid(System. Text.Encoding.Default.GetString(Fields!Picture.Value),79))

    in value field of Image control but no luck....

    any solution??

    Thanks.

    Gunjan.

  • I can now view the bmp and jpeg images in image control but some how I am not able to view the .tiff images.

    why is that so?

    Does SSRS not support rendering a tiff image from database?

    Thanks.

    Gunjan.

  • I found one more thing; if we deploy the report with tiff image in database its not showing in the IE.

    but if you try out with the windows application then it shows the image.

    I think the reportviewer control in the IE causing the problems. While in windows applicaiton it shows the image.

    Is this a bug in SSRS?

    or I am missing something??

    Thanks.

    Gunjan.

  • No I don't think it is a bug because if your image is from a database you may have to add it to a rectangle before rendering so you could look at options like from project which means the image is part of your report solutions file. There is minor difference with embedding.

    Kind regards,
    Gift Peddie

  • I have added the rectangle and then assigned the value like Fields!ProductImage.Value to the value property. set the source as database and mime type as image/png. I have tiff image.

    In the preview its showing part of the image and Still its not showing an image on reporting server i.e in the web browser.

    Thanks.

    Gunjan.

  • That could be related to the size of the file because I know I had to convert a Bitmap to Gif to reduce the size of a file. I still don't think it is a bug but look into known issues with tiff rendering.

    Kind regards,
    Gift Peddie

  • This is what I am trying to figure it out. the problem is with the tiff image.

    but then why windows application's reportviewer can show the image while web application's report viewer not...??

    Thanks.

    Gunjan.

  • You left out that major factor because the Web version only deals with images you can render in a web application, the only way I know you can consume tiff in http is in the response object. Here is some code that may help you if not you need to look for code to convert tiff to bitmap and pass it to memory stream.

    http://www.codeproject.com/KB/reporting-services/report-viewer-hack.aspx

    Kind regards,
    Gift Peddie

  • Thanks...

    Yes that's true if we are showing the image in normal asp.net control. But we are showing reports in reportviewer control so that means to show tiff images one has to convert tiff to bmp. but how and when to do the conversion while we are showing in the report viewer control? so here Windows report viewer shows tiff image while web's report viewer not...

    :exclamationmark:

    Thanks.

    Gunjan.

  • There are two things here one the web version of the reportviewer control comes with restrictions of what you can render and I am not even aware of reporting services consuming tiff by default so you need to find code to again convert your tiff to image format that can be consumed by default like jpeg, gif or bitmap. Here are the sample code from Microsoft for the reportviewer control. One more thing the reportviewer control and reporting services are not the same, only remote mode of the control relate to reporting services.

    http://gotreportviewer.com/

    Kind regards,
    Gift Peddie

  • Yes we need to convert the tiff to bmp, jpeg, etc.

    So web's report viewer control is not supporting the tiff images and windows report viewer does...

    Microsoft should provide this feature in it....

    Thanks.

    Gunjan.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply