Image from database does not display

Stimulsoft Reports.NET discussion
Post Reply
loopyonerous
Posts: 3
Joined: Mon Aug 01, 2016 5:17 pm

Image from database does not display

Post 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?
loopyonerous
Posts: 3
Joined: Mon Aug 01, 2016 5:17 pm

Re: Image from database does not display

Post 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.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Image from database does not display

Post 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.
loopyonerous
Posts: 3
Joined: Mon Aug 01, 2016 5:17 pm

Re: Image from database does not display

Post 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!
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Image from database does not display

Post by Alex K. »

Hello

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

Thank you.
Post Reply