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?
Image from database does not display
-
- Posts: 3
- Joined: Mon Aug 01, 2016 5:17 pm
-
- Posts: 3
- Joined: Mon Aug 01, 2016 5:17 pm
Re: Image from database does not display
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
Hello.
This should be enough. The PNG format is supported.
Could you send us your report template with sample data for analysis?
Thank you.
This should be enough. The PNG format is supported.
Could you send us your report template with sample data for analysis?
Thank you.
-
- Posts: 3
- Joined: Mon Aug 01, 2016 5:17 pm
Re: Image from database does not display
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!
Problem fixed - thanks!
Re: Image from database does not display
Hello
Ok.
Let us know if you need any additional help.
Thank you.
Ok.
Let us know if you need any additional help.
Thank you.