Skip to Content
0
Former Member
Nov 08, 2008 at 02:30 AM

Displaying image from database in report

33 Views

I need to include a picture (company logo) in numerous reports. This logo will be stored in an MS SQL Image field in a table (this bit I have already sorted out).

What I'm wondering is, what is the best way to retrieve this image from the database? Do I just include it in the view the report runs off? I'm hesitant to do this, as the view may return back hundreds of records, which means (I think) it will be sending the image along with it hundreds in time.

In short:

1) What is the best way to pass an image to a report.

2) If I include the Image field in a view which returns back hundreds of line, will the image be returned also hundreds of time, causing network congestion/performance issues?

3) If so (2), is there a way of sending the image only once, no matter how many rows are in the returned view?

Thanks.