Tim Van Wassenhove

Passionate geek, interested in Technology. Proud father of two

04 Aug 2007

Professional SQL Server 2005 Reporting Services

Last couple of days i’ve been reading Professional SQL Server Reporting Services. Today i wanted to display some images so i decided to use the Northwind database which has an Employees table that contains photos.. I set the MIMEType to image/bmp, Source to Database and Value to =Fields!Photo.Value but i kept getting a red cross instead of the image

image of a sql server reporting service report where an error box appears instead of the image

After a lot of searching, i found the following in Hitchhiker’s Guide to SQL Server 2000 Reporting Services:

<p>
  And yes, once i used this as value for the image, everything worked as expected:
</p>

<p>
  <img src="http://www.timvw.be/wp-content/images/reportingservices-02.gif" alt="image of a sql server reporting service report where an image is correctly displayed" />
</p>