Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 310
  • Last Modified:

SQL Server Reporting Services and Retrieving Images from Database

I am currently having a problem of displaying images that should be dynamically generated based upon an inputted parameter by the user.  I can't get any images to display from the table where they are stored. I have gone through the image wizard and tried the different variations.  I have also tried storing the images as an image file as well as a binary file, but neither file type will display an image.   Does anyone know how to fix this problem?  Thanks.
0
timlambert
Asked:
timlambert
  • 3
  • 3
1 Solution
 
mrloumrlouCommented:
Are you positive the image files are not corrupt before it goes into the database?  Do they display right after they are made before being put into the database?
0
 
timlambertAuthor Commented:
Yes I am positive the image files are not corrupt.  I am able to create a report within Access and the images display, but when I either import the report into SQL Reporting Services or create a new report within SQL Reporting Services, none of the images will display.  I have tried several different attempts at trying to get the images displayed but I stil can't figure out what I am doing wrong.  Any Help?
0
 
mrloumrlouCommented:
Sorry, I must have missed your response.  Have you corrected your problem yet?
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
timlambertAuthor Commented:
No, I still have no corrected this problem yet.  I have also tried using this expression, =System.Convert.FromBase64String(Mid(System.Convert.ToBase64String(Fields!Picture.Value),105)) , and still I get the small box with the red x in it.  Do you have any suggestions?
0
 
timlambertAuthor Commented:
I'm sorry, that expression i said earlier that didn't work, actually does work.  I put the expression in the wrong value field that's why I was still have an error.
0
 
mrloumrlouCommented:
So you just fixed it now upon re-examination? Nice! Good thing I made a comment! :)

0
 
moduloCommented:
PAQed with points refunded (250)

modulo
Community Support Moderator
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now