Page 1 of 1

Image from database does not display

Posted: Mon Aug 01, 2016 5:36 pm
by loopyonerous
I'm trying to add an image to an existing report. Our data source is a T-SQL stored procedure in Microsoft SQL Server, and the image is stored in a table in a varbinary(max) column. I've modified the stored procedure to include the image in the result set that it returns, and Stimulsoft designer can see it. When I select "View Data" on the data source if the image column is populated, a portion of the image displays in the view data window, truncated to fit in a cell in the viewing grid. But when I place an image on the report I am unable to get the image to display; all I get is blank space. I've tried selecting the image data column for the image box, and I've also tried setting the Image URL to be the data column, but all I get is blanks.

What do I need to do to put an image from our database onto this report?

Re: Image from database does not display

Posted: Mon Aug 01, 2016 8:23 pm
by loopyonerous
By the way, the image is stored in our database in PNG format. I could change that to something else if needed, but so far everything I read implies I should be able to put any supported format into an image box and it should display. I have sent the database image column to a file and verified it is a valid PNG image.

Re: Image from database does not display

Posted: Tue Aug 02, 2016 9:15 am
by HighAley
Hello.

This should be enough. The PNG format is supported.
Could you send us your report template with sample data for analysis?

Thank you.

Re: Image from database does not display

Posted: Tue Aug 02, 2016 4:10 pm
by loopyonerous
Thanks - once I started trying to produce a small sample for you, I discovered that I was only displaying part of the image. Turning on the stretch property on the image helped immensely by making the whole image visible, and then I needed to adjust dimensions and a few other properties to get something that looks like the stored image.

Problem fixed - thanks!

Re: Image from database does not display

Posted: Tue Aug 02, 2016 6:09 pm
by Alex K.
Hello

Ok.
Let us know if you need any additional help.

Thank you.